SQL Server Quickie #35 – Crash Recovery
Today I have uploaded SQL Server Quickie #35 to YouTube. This time I’m talking about Crash Recovery in SQL Server. Thanks for your time, -Klaus
Indexes on VARCHAR Columns
Years ago I wrote about how SQL Server stores VARCHAR columns in the Navigation Structure of an index. As you might know, the key columns of an index in SQL Server (Clustered Index, Non-Clustered Index) have a size limitation of a maximum of 900 bytes. Imagine now that you want to fool SQL Server, and …
sys.dm_exec_input_buffer in SQL Server 2016
Hands up: who of you at least once in your DBA career has used the DBCC INPUTBUFFER command to retrieve the last SQL statement that a specific session has submitted to SQL Server? Almost all of you! We all know that DBCC commands are little bit awkward, because you can’t call them in a T-SQL …
Disabling Clustered Indexes in SQL Server – a really good idea?
Last week I taught an internal SQL Server Performance Tuning course to a customer in Switzerland. As usual we had a lot of fun, and at some point an attendee asked me one of the best questions of my life: “Can you disable a Clustered Index?” At first I was really scared about that question, …
Disabling Clustered Indexes in SQL Server – a really good idea? + read more
SQL Server Quickie #34 – Statistics
Today I have uploaded SQL Server Quickie #34 to YouTube. This time I’m talking about Statistics in SQL Server. Thanks for your time, -Klaus
