Tags » SQL Performance

SQL SERVER - Backing Up and Recovering the Tail End of a Transaction Log - Notes from the Field #042

: The biggest challenge which people face is not taking backup, but the biggest challenge is to restore a backup successfully. I have seen so many different examples where users have failed to restore their database because they made some mistake while they take backup and were not aware of the same. 825 more words

SQL Authority

SQL SERVER - Cardinality Estimation and Performance - SQL in Sixty Seconds #072

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query.  154 more words

SQL Authority

SQL SERVER - Introduction to SQL Server 2014 In-Memory OLTP

In SQL Server 2014 Microsoft has introduced a new database engine component called In-Memory OLTP aka project “Hekaton” which is fully integrated into the SQL Server Database Engine. 1,348 more words

SQL Authority

LEFT JOIN vs NOT IN vs NOT EXISTS Performance Comparison

A typical task that is asked of programmers in SQL is to determine whether a matching row exists for a given condition in a table. I am aware of three methods for accomplishing this task (there may be others, but as of this post these are the only ones that I know about): 1,184 more words

SQL

#Oracle DBA Bookshelf

My recommendations for the DBA bookshelf at work is: 174 more words

General