We are seeing very high PAGELATCH_EX and PAGELATCH_SH wait types along with high WRITELOG waits. I've diagnosed the query causing the PAGELATCH waits and can eliminate them by reducing the insertion ...

After reading The Data Loading Performance Guide I am unsure if its necessary to add the TABLOCK table hint to an empty temporary table, defined with a clustered index in order to get minimal logging.
...

This question was posted on Stack Overflow but left unanswered, I was hoping maybe here I might find an answer.
What I understand about databases that if a queried or requested record is found in the ...

I am curious about how MySQL's GET_LOCK function actually works. I understand what it means when I ask for a lock, and what the potential return values are.
But I want to get a better understanding ...

If a table is <8kb in size in SQL Server then presumably it is all stored on a single page. Thus - aside from enforcing a unique constraint - is there any performance benefit that could be obtained ...

When we execute SQL query, then Relational Engine optimize it and pass query plan to Storage Engine which then ask for a page with actual data.
If data page isn't in memory, then SQL pull those pages ...

When an index is disabled, the definition remains in the system catalog but is no longer
used.
SQL Server does not maintain the index (as data in the table changes), and the index
cannot be used to ...

I have a three-column (int, smallint, smallint) composite clustered index with three leaf levels. My question is how and when does SQL Server create multiple leaf levels (index_level 0) for the same ...

Which SQL Server system database is more important: master or resource?
If the resource database is damaged, can the database engine work?
Can the system work with only the master database? If not, ...