The Voice of the DBA
Archives: May 2010
Is Pivot Worth it?
I’ve been trying to learn more about the T-SQL changes in SQL Server 2005/2008 over time. I don’t have requirements to write a lot of T-SQL, so I have to futz around with it and just try things I see in articles or presentations. One that I’ve been meaning to… Read more
6 comments, 590 reads
Posted in The Voice of the DBA on 11 May 2010
Creating a Server Audit - SSMS
Building a server audit consists of first setting up the audit. You do that in SSMS through the…
3 comments, 1,586 reads
Posted in The Voice of the DBA on 10 May 2010
SQL Saturday #49 – Call for Speakers
SQL Saturday #49 in Orlando just opened their call for speakers. I’m debating if I want to go out there. The event is on Oct 16, 2010, and this is always one of the larger SQL Saturday crowds. I have a lot of friends there, but I was hoping… Read more
3 comments, 827 reads
Posted in The Voice of the DBA on 6 May 2010
Internal Marketing
I heard this recently at my company. Our group, which is relatively removed from the main business of writing software, doesn’t always have the best relationship with everyone else. I think some of it might be that they don’t understand what we do, and some might be that they don’t… Read more
6 comments, 686 reads
Posted in The Voice of the DBA on 6 May 2010
Getting a Page of Results
The other day I was looking over a couple of articles on paging, looking to see if I could learn something new in T-SQL. I’ve implemented some SQL2000 era paging systems, none of which performed wonderfully, so I checked out Jacob Sebastian's basic Server Side Paging and Paul White’s Optimizing… Read more
2 comments, 367 reads
Posted in The Voice of the DBA on 5 May 2010
CLR Stability
Recently I was at a UK user group meeting and Simon Sabin of SQL Skills presented a short “SQL Nugget” on UDFs and some of the issues with performance. He then showed a better way using a TVF and mentioned that in many cases the CLR can perform on par… Read more
1 comments, 590 reads
Posted in The Voice of the DBA on 4 May 2010
A Glimpse of the Future
I’m not sure what happened here. I walked up to my desktop, wiggled the mouse, and nothing happened. In the true definition of insanity, I then did it a few more times and achieved the same result. Hitting the keyboard didn’t help and it appeared frozen.
Weird, but no cause… Read more
8 comments, 481 reads
Posted in The Voice of the DBA on 4 May 2010
When Did SQL Server Restart?
I saw Joe Webb’s post, and then Gethryn Ellis’ post as well on when SQL Server last restarted. It’s something that can be handy when troubleshooting and trying to figure out what’s going on with SQL Server.
I’ve also used it to track potential issues as well, like when… Read more
3 comments, 402 reads
Posted in The Voice of the DBA on 3 May 2010