Browse by Tags

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Published 21 February 8 6:22 AM | SSQA.net

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...

Filed under: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow

SQL Server TSQL to find complete CONSTRAINT information on a table catalog?

Published 9 January 8 7:26 AM | SSQA.net

I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name...

Filed under: sql server, databases, dba, function, requirement, tsql, tablename, constraint, values

How to be an Exceptional DBA - free ebook.

Published 2 January 8 12:14 PM | SSQA.net

A new year gift to the SQL Server users!! As the title states every DBA wants to be exceptional within their environment . Within your demanding role there are more things that needs importance in continuing the fire-fighting techniques to keep up the...

Filed under: sql server, databases, red-gate, dba, download, ssp, sql-server-performance, ebook, beginners in sql serever

SQL Server 2005 Performance Dashboard Reports - making most out of it!

Published 26 June 7 4:19 AM | SSQA.net

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow...

Filed under: dashboard, sql server, performance, databases, dba, reporting