We can estimate the resources using DMV's, also if you have access to Idera's SQL diagnostic manager v7.5 you can generate reports on expected database growth, expected resources.

There are few DMV's thru which we can estimate. Also, if you have Idera's SQL diagnostic manager you have the facility to estimate database growth, resources.

If you are running on SQL Server 2005 please refer to http://support.microsoft.com/kb/949199

If not, this sometimes happens when more than one disk intensive maintenance tasks are running at the...

Select columnname1, columnname2

FROM

tablename

WHERE datecolumnname BETWEEN DATEADD(dd, -30, '20110420') AND '20110420'

Restore the database to a test server (not to the same server that the database already exists); extract the stored procedure code and permissions on the stored procedure; put the...