SELECT * FROM Posts WHERE Tags IN ('Clustered Index')
I love SQL Server internals, I do and I just said it. Why? because thanks to all the tools, documentation and community members that share their knowledge, folks like me can understand how a super complex piece of software like…
So spring time is here and probably you feel like cleaning up your databases, and that’s good. In previous posts…
Following a conversation with my junior DBA, I decided to show you what happens when we disable indexes and in particular when we disable the clustered index for a…
When it comes to technical subjects like databases, we must always look for proven solutions and best practices, which usually take us from A to B in the most efficient way. Usually. But what happens…
One of the basic (and well used during interviews) questions about SQL Server internals is how you call a table without a clustered index, and that in SQL Server is called a HEAP….