Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below This deleted all the data […]
Does Partitioning Improve Performance?
Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This […]
Full Text Search on Varbinary (max) Columns and using the Right filters
I love Full text search in MS SQL Server. Although I haven’t seen it being used a lot in client locations, I do use it a lot within […]
SQL 2016 – Stretch database in detail –CTP 2.3 screenshots with BOL corrected now
If you have been following the buzz around MS SQL 2016 you would surely have heard of Stretch database. The concept is interesting and new and probably something […]
administration / MSSQL / TSQL
Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!
When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use […]
Drawing a graph in SQL Server Management Studio
Had some spare time today so I used it to finally get around to a small project I had in mind. The intention is just to do it […]
NULL Management, SPARSE Columns, Vertical partitioning and a query
When discussing DW design I often take a lot of time to emphasize the impact Nulls have on query performance, aggregations, design, storage and much more. While this […]
Which is better Count (*) or Count (id)?
While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so […]
It’s gorGEOus what you can do with this data type
Had some spare time on my hand today and created the company logo in the MS SQL Server Geometry datatypes. The Geography and Geometry datatypes are one the […]
Game Theory and Databases
CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with […]