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 […]
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 – […]
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 […]
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 […]
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 […]
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 […]
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!
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 […]