SELECT * FROM Posts WHERE Date_Posted = 'May 2016'
It’s been some time since I started with my first SQL-G Hack, and I think those are precisely the kind of posts you might want to find when searching…
TRUNCATE TABLE in SQL Server is well known for what it does as feature, but how it actually works is easily misunderstood, and for long time, the same…
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…