[font="Courier New"]@wware,

I didn’t see anything offensive in anyone’s reply so far nor was I offended in anyway. So, there is absolutely no need to apologize here.

Criticism is good and if...

@mike-2 Dougherty, @wware, @SanjayAttray

Is it mentioned anywhere in QoD that this change is going to be deployed to production while the DBA is on vacation?

I don’t...

Run these commands and you will know more information. And if you can share the info here.

Select name, log_reuse_wait_desc from sys.databases

GO

DBCC LOGINFO(YourDBNAME) WITH TABLERESULTS

GO

SELECT name AS [File Name] , physical_name...

The first thing the OP needs to do is look at the data from the below queries.

select name, log_reuse_wait_desc from sys.databases

GO

USE DBNAME

GO

SELECT name AS 'FileName' , physical_name AS 'PhysicalName', size/128...

Paul Randal (8/18/2009)

---

ok - this isn't a good question. I wrote DBCC CHECKDB and I got the answer wrong. I guess it could be down to BOL stating that disabled...

bitbucket,

Most of the comments on this post were constructive criticism, which I took nicely and Thanks for the kind words. I wish I could have wrote more questions on SSC...

Scott Coleman (8/17/2009)

---

From Nov 2008 Books Online:

DBCC CHECKALLOC checks the allocation of all pages in the database, regardless of the type of page or type of object to which they...

bitbucket,

Not sure I am grasping your last post. Is it a question or statement?

Note that DBCC CHECKDB is re-written by Paul Randal in SQL Server 2005 but you are referring...

First, I take the criticism that this could have been worded better. I wrote this probably 6-8 months ago but got published now so the context is NOT fresh off...

Good one. Can you exclude the session_id where this script is running?

Try to use this post from Jonathan and see if it helps.

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/22/error-945-severity-14-state-2-database-mssqlsystemresource-cannot-be-opened.aspx

*Caution*: use at your own risk and I am NOT an expert DBA.

Try to use TSQL for this instead of the SSMS.

ALTER DATABASE DBNAME

ADD FILE

(

NAME = NEWFILE,

FILENAME = 'D:\NEWFILE.ndf',

SIZE = 50000MB,

MAXSIZE = 100MB,

FILEGROWTH = 5MB

) TO FILEGROUP SECONDARY;

GO

>> I want...

Gail, you are absolutely right. I should put more effort in clearly specifying that.

Gagan,

Is it 32 or 64 bit?

Post the results of this query. This will tell you exactly where is the bottleneck.

-- Isolate top waits for server instance since last restart or...

>>Is there a way to count number of queries executed on sql server in the past

Try this to pull the queries that have been executed the most on the...