I totally agree with you that a lot of half full pages is bad for disk storage, memory consumption and reading a lot of extra pages due to the low...

Thank you for pointing this out to anyone! Optimizing queries and keep your statistics up to date is far more efficient for the performance. The impact of fragmentation is even...

That was an easy question. You can have different compression levels for different partitions of an index and thats why you need to look at sys.partitions. You can also find...

Tricky! I guessed 3, estimated, actual and live

That was interesting!

That one was too easy, I almost thought it was a trick question

I have never used Python, but this seems to be a nice feature.

I also stuck with the answers about the products, as the query had nothing to do with products. I then assumed there has to be some issues in the query...

Thanks for the Question! That was unexpected.

Easy question. If you delete the login you can get some problems because the owner doesn't exist anymore. Thats why it is imortant to change the owner.

I only get the A in the grid, but A B C D E F in text result. Strange.

One problem with EOMONTH is that it doesn't return the time, and if you convert the date to datetime, you will not get the end of month as the time...

This is a very useful setting!

As already answered, sysdatabases are for backward compatibility, but instead of creating your own script for re-indexing, you should consider using the Ola Hallengren maintenance solution. Read more at

I almost got it wrong as I didn't see the comma first and got confused so I had to read the options twice. Sometimes the devil is in the details.