Skip to main content

Posts

Showing posts from July, 2020

Troubleshooting and Query Tuning in SQL Sever

What is SQL Server ? - SQL Server ( RDBMS ) of Microsoft is a windows plateform which ensure the concurrency and a transactions. - Various SQL Server developer performs the basic ACID pricipal to maintain dignity and accuracy of a transactions. What is ACID Principal? - As we know the in every transactions developer ensure the transaction should be complete and there is no breach of a data dependent on another transactions these basic rule simple called ACID principal. A tomicity confirm the transaction either all or non will execute. C onsistency ensure in any transactions can't leave your database in half of the state. I solation ensure each transactions are independent. D urability ensure in database will keep record of pending changes in such of way server can recover from an abnormal termination. OLEDB (Driver) ODBMS (Driver) Support hierarchical and relational both such as Excel, XML. Support only relational data such as RDBMS. ...