At long last I am bringing the next installment in this mini-series.  You can find the rest of the articles by perusing the last article I wrote on the topic.  That article was a correction to the TableSpace script about which I had already blogged.

As you will recall, this… Read more

Last week I posted an article about plagiarism.  This is a follow-up to that.  After posting that blog article, Steiner quickly removed the copied content.  The tone may have been a bit harsh in that article.  My feeling on the subject has shifted only slightly.  Steinar was trying to… Read more

Recently I received a new opportunity via email.  Steve Jones at SQLServerCentral sent me an email to see if I would be interested in helping review a book and write about it on my blog.  I told Steve I would be happy to help out.

The book is titled Defensive… Read more

Today I ran into an interesting website.  While I was trying to locate information concerning a SQL Saturday event, I came across one of my blog entries on another site.  I syndicate to SQLServerCentral and SQLServerpedia and am fully aware that my blogs would be verbatim on each of those… Read more

Today I ran into an interesting website.  While I was trying to locate information concerning a SQL Saturday event, I came across one of my blog entries on another site.  I syndicate to SQLServerCentral and SQLServerpedia and am fully aware that my blogs would be verbatim on each of those… Read more

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.

Read more

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 how to find the sizes using the SQL 2005 system objects rather than the scheduled… Read more

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 current SAN migration and some of the sticking points that he is experiencing.  To say… Read more

Once again it looks like I was early for the T-SQL Tuesday event.  Last month I submitted my entry on reporting as was the topic last month.  If you recall, last month I was a week early.  As it turns out, this month I am a full month early.  This… Read more

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 more about it here or here.

For many of us there is a very… Read more

This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this thursday (May 13, 2010).  We have a couple of presentations lined up to teach us about signing your digital certificates and also to learn about some of the DMVs in… Read more

In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft.  These stored procedures use different methods to display information about a table in a SQL Server database.  In this post, I want to delve a little deeper into the sp_MStablespace stored… Read more

In SQL Server there are two stored procedures that help one to determine the size of a table.  One is documented and more widely popular, the other is not.  These two stored procedures are sp_spaceused and sp_MStablespace.  Dugi wrote a blog article about the the two stored procedures in March… Read more