This puzzle, I have discovered accidentally. In one of the recent project, I had to display two dates next to each other. Now, when I was doing this, I accidentally did a mistake while I was typing that out. Indeed, this puzzle about strange results when adding two dates.
One of the most popular questions I received during my SQL Server Performance Tuning Practical Workshop is how users can run sets of procedure when their SQL Server starts automatically. Today, let us see a simple tutorial to run stored procedure at server startup.
Question: Can You DROP Offline Database?
Just the other day one of my customers asked me that they are facing a situation where they have specified in their backup script RETAINDAYS option but it is actually not deleting their older database backups.
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
With the new Intel Skylake CPUs coming out recently it seemed like a good time to discuss CPU resources and how to know if they’re running optimally. After all, there’s little sense in upgrading your server if your current one is already data starved. Let us learn about how to balance your SQL Server facing data starvation.
Question: How to Create Primary Key Without ANY Index?