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 […]
Tag: Scripts
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 […]
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. […]
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 […]
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 […]
Security Audit
This article demonstrates a script that will generate a nice html report of your database security suitable for the auditors.
Log Growing Pains Article
I Just had an article published at SQLServercentral on troubleshooting the cause of log growths. At the conclusion of that article I had a reference to my blog with the expectation of having had time […]