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 […]
Category: News
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 […]
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 […]
Marathon Schedule
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are Hurricane Half Marathon, HobbleCreek Half Marathon, Top of Utah Half Marathon, Top of Utah Marathon, […]
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I have since seen a request to add to that script. The addition would add some […]
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior can be somewhat concerning since that view should have a unique entry for each index. […]
SQL 2008 R2
Really short post here. I just found out that Stacia Misner (blog |blog 2 | @StaciaMisner) and Ross Mistry have released the SQL 2008 R2 book. I knew this book was in the works from […]
Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and MCITP. I had planned on keeping regular updates about the topic on my blog and […]
BLOB Report T-SQL Tuesday #005- Reporting
Checking for BLOBs that were created in the Primary Filegroup by default. To move them was a manual process and is a different topic from the crux of this one. Since the initial report to find the BLOBs, I have evolved it somewhat to try and find the size of each object, as well as to report on the usage related with each.
S3OLV April Meeting Recap
We held our meeting last night and had a good time. Thanks to those that were able to make it out. Comments made after the meeting were favorable. People enjoyed the meeting, there was a […]