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 […]
Tag: SQL
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 […]
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 […]
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 […]
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.
IP and Default Trace…T-SQL Tuesday #005
When it is necessary to provide reports on activity occurring on the server, it pays to do a little prep work. Be Prepared. It is not an easy task to be able to go back in time and report on data that isn’t captured. The little prep work that one may need to do is well worth the effort in the end.
Index Info
I recently came across an interesting script to help show index info and usage. As I began to dissect the script, I noticed that the script was intended for SQL 2005 and beyond but was […]
Stepping Stone Cert
A few of us have been deliberating and discussing the need for a bridge certification between the MCITP and MCM certifications from Microsoft. This discussion was brought about due to an editorial by Steve Jones […]
FizzBuzz Revisited
I had bigger plans for this series than what has transpired. I think that is a testament as to how things can rapidly change or other events can change your plans. The first thing that […]