When doing calculations in SQL Server queries it is important to know that anything without a decimal is going to be treated as an integer and therefore will cause the result to be an integer as well. For instance, lets take 598/128 and look at some results. This will obviously give us a decimal for a result...or at least it SHOULD. SELECT 598/128 = 4 This is clearly NOT an even 4, however SQL has decided to round the result even without us telling it to. Now lets take a look at SELECT CONVERT(D...
Read More
I have recently been dealing with a situation with a client where the transaction log has become an issue. Naturally during the research portion of trying to figure out what is wrong I wanted to find things like the size of the transaction log or what the autogrowth is set to. You can find out much of this information through the UI relatively easily. However, it becomes a pain when you are checking on multiple databases to have to keep looking up the same information. Luckily everything you cou...
I just wanted to give everyone a quick update on some of the awesome things that are going on this year. One of the most rewarding parts of my job is that I get a lot of knowledge that I can go out and share with everyone to help others do their jobs a little better. There are a lot of wonderful ways to get involved in the SQL community and it is something that has helped me out many times over the ccourse of my career. I don't say this to make me sound like I am sooo smart, I am just like every...