I was able to figure out what was causing this issue, and it was data related. In my dataset I was using NTILE(7) to assign column numbers and split the...

I second the request for more articles on indexing! As junior-ish DBA to a new company (and the only real DBA), I had to evaluate various performance bottlenecks fairly quickly....

Great thoughts! I'd also like to add that the SQL Server certifications are an excellent way to gain exposure to technologies that you may not have an opportunity/desire to dive...

Thanks for the tip! I'll definitely start there. Yesterday I actually printed out the Wait Statistics section from the Accidental DBA e-book - glad to know I was on the...

I figured that was the case. Thanks for confirming!

I've definitely got my work cut out for me... the table in question has 55 indexes. :crazy:

I've never responded to one of the editorials before, so here goes....

This article really spoke to me because I'm in this type of small team organized chaos right now. We're...

Thanks to both of you for your replies! This did help a bit in getting it more into the format I needed. I was tired of trying to juggle XML...

I did need to drop and re-create all of the non-clustered indexes in order to do the datatype change. Unfortunately, the clustered index wasn't included in this and he got...