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
Category: Administration
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 Server Integration Services Issue (Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum))
TITLE: Microsoft SQL Server Management Studio —————————— Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: The SQL server
SQL Canada (SQLCAN) 