Database Engine

Spring may be long gone but you still need to clean up MSDB

Spring may be long gone but you still need to clean up MSDB

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look after itself. In fairness it does to a certain extent (no, that’s not a pun), it’s configured out of the box not to be the fastest, but to be stable. The problem is that SQL […]

FLOAT datatype casting issue

FLOAT datatype casting issue

Do you use the FLOAT datatype? If so you had better read this…… Today I came across an issue somebody posted on the Microsoft Connect site citing a bug with how the FLOAT data type was calculating a value when being cast to various other datatypes. You can read the original connect item here – […]

Cycling is good for you

Cycling is good for you

It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour de France, Chris Froome finishing second and Mark Cavendish winning the final stage. I have a huge amount of admiration for their dedication to the sport, it takes massive amounts of physical and mental stamina […]

Writing queries without data

Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This may be because you don’t have a machine with enough storage capacity, it might even be on a laptop so there is also the security aspect. So how do you address the issue of writing […]

Rollback Gotchas – Part 2

In part 1 of this 2 part series on rollback gotchas we looked at the physical operations. In part 2 we are going to look at an example of when the rollback statement does not appear to work at all and take a look into the reason why this is. One of the big debates […]

Rollback Gotchas – Part 1

Most people understand what a transaction is and how to set them up. The scope of this post is not to explain how transactions work within SQL Server, but for completeness sake I’ll provide a brief overview: The basic premise is that SQL Server will run each statement as an implicit transaction unless the BEGIN […]

Identifying Query Plans that are not good enough

Identifying Query Plans that are not good enough

After doing my usual daily checks I noticed that I had an unread blog entry – Reason for Early Termination of Statement by Grant Fritchey (Blog|Twitter) in my RSS Feeds, Grant’s posts are always very good so I put a few moments aside to take a look through and I’m glad that I did!

Recovering TempDB

In a previous post “Moving TempDB” I provided step by step instructions on how you can move your TempDB database with an emphasis on reducing disk IO contention. If you have read this post you will notice that I did not change the path for the TempDB database files from the USB stick back to […]