Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2010

Space Used

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

4 comments, 629 reads

Posted in SQL RNNR on 25 May 2010

Content Copy Followup

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

0 comments, 315 reads

Posted in SQL RNNR on 24 May 2010

SQL Book Review

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

0 comments, 244 reads

Posted in SQL RNNR on 21 May 2010

Plagiarized or Copied

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

0 comments, 246 reads

Posted in SQL RNNR on 20 May 2010

Plagiarized

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

2 comments, 254 reads

Posted in SQL RNNR on 20 May 2010

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.

Read more

1 comments, 238 reads

Posted in SQL RNNR on 20 May 2010

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

56 comments, 506 reads

Posted in SQL RNNR on 19 May 2010

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

38 comments, 266 reads

Posted in SQL RNNR on 14 May 2010

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

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

1 comments, 374 reads

Posted in SQL RNNR on 11 May 2010

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

For many of us there is a very… Read more

13 comments, 411 reads

Posted in SQL RNNR on 11 May 2010

May UG Meeting

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

1 comments, 207 reads

Posted in SQL RNNR on 11 May 2010

SQL 2005 TableSpace

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

83 comments, 3,670 reads

Posted in SQL RNNR on 5 May 2010

Table Sizes

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

9 comments, 382 reads

Posted in SQL RNNR on 3 May 2010