We have the database_name, object_name, object_schema_name but don’t have index_name. So when accessing information in sys.dm_db_index_usage stats, it becomes troublesome to find out index name
Category: Administration
Getting List of All Files and Their Growth Information
SQL Server defaults to growing data files by 1MB and transaction logs by 10%; neither of those are best practice. If your database is small
Getting Database Data/Log File Growth from Default Trace
How to calculate database growth rate using default trace?
How to find out what is causing page splits?
Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why. They were not have performance issue but
How to find the log file usage for a transaction in SQL Server 2005?
Word of caution before you try/read this: I am using undocumented function to read the trace file. I do not grantee the results to be
Last updated date for statistics?
There is many ways to get his information; however in most cases you get information for a single table. If you want to get it
SQL Canada (SQLCAN) 