SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2010

Can Deadlocks be Resolved by Adding an Index?

Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.

First, let me set the scene: One of the applications I support has had issues with deadlocks for some time now. The deadlocks are really a result of design issues that it… Read more

0 comments, 718 reads

Posted in Adventures in SQL on 27 September 2010

A Little Help with Azure Please

Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say that when I first heard about the product I was skeptical. The problem I had is that I already have servers, lots of them in fact. I struggled to find… Read more

0 comments, 304 reads

Posted in Adventures in SQL on 23 September 2010

What Did that Geek Just Say?

Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is people that can either not explain what they mean in simple terms or that choose not to in order to appear knowledgeable. I still have a long way to go… Read more

0 comments, 303 reads

Posted in Adventures in SQL on 21 September 2010

How is Fill Factor Impacting My Indexes?

The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices for fill factors on indexes actually does to the structure of those indexes. I have to give special thanks to Brent… Read more

0 comments, 782 reads

Posted in Adventures in SQL on 14 September 2010

Quote of the Day

I do not usually post a quote of the day but since this is my own quote I decided to share it.

Today is the first day of the rest of your life. Make it yours, own the day. Repeat tomorrow. This has been your wake up call.

Read more

0 comments, 311 reads

Posted in Adventures in SQL on 13 September 2010

In the Interest of Disclosure

Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like most classes had at least 1 new thing for everyone to take away. The big takeaway for me was that I must disclose that I am employed by CDW when… Read more

0 comments, 379 reads

Posted in Adventures in SQL on 3 September 2010

A Stored Procedure to Move SSIS Packages Between Servers

Today’s post is one that I have been debating on whether to publish for a while. The purpose of the stored procedure I am sharing is to move SSIS packages stored via SQL Server Storage from one server SQL 2005 server to another in a way that can easily be… Read more

0 comments, 919 reads

Posted in Adventures in SQL on 1 September 2010