Monthly Archives: May 2010

Getting a Page of Results

Posted on May 5, 2010 by way0utwest

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 … Continue reading →

Posted in Blog | Tagged , | Comments Off on Getting a Page of Results

CLR Stability

Posted on May 4, 2010 by way0utwest

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 … Continue reading →

Posted in Uncategorized | Comments Off on CLR Stability

A Glimpse of the Future

Posted on May 4, 2010 by way0utwest

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 … Continue reading →

Posted in Uncategorized | Comments Off on A Glimpse of the Future

When Did SQL Server Restart?

Posted on May 3, 2010 by way0utwest

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 … Continue reading →

Posted in Uncategorized | Comments Off on When Did SQL Server Restart?