New SQL Standard Article

A new article for the SQL Standard is now available.  You can find the article here.  The article is by Sam Bendayan and covers the topic of set-based programming. Check it out.

TableSpace Update

The last post in the series on finding the sizes of your tables showed us how we could find that size via a set-based method similar to using sp_MStablespace.  In that post I showed you […]

May 2010 S3OLV Meeting Recap

On the evening of May 13th, S3OLV held its monthly meeting.  We had some really good discussion, and got to participate in a couple of good presentations. Charley (Chapter President) gave a presentation on his […]

T-SQL Tuesday #006: A Blobbing We Will Go

In the DMVs for SQL 2005 and SQL 2008 there is more than one place you can find the information about the size of your LOB data?  And it goes without saying that there is more than one way to find information about LOBs in your database.

Exceptional DBA

It is once again that time of year.  It is time to nominate the DBA in your life for the Exceptional DBA of the Year Award.  This award is sponsored by RedGate.  You can read […]