There's still an easy / cheap way out for now. Just overload the server with ram (as much as it can take, or the client is willing to pay...

It would have been better to run checkdb in this manner :

DBCC CHECKDB('db name') WITH NO_INFOMSGS, ALL_ERRORMSGS

The 1st switch eliminates all the noise from the results (which makes it...

"happy" waiting.

That's a good lesson learned for the "junior" dba?

And maybe another one for the managing team. Nothing is as simple as it seems and it's better to...

seriously how busy are the disks on avg?

The day all the queries are tuned correctly and you're still getting IO problem because you have too much sales (and losing some...

Depends on how you guys edited the table in EM.

Far too often the code defaults to something like this :

begin tran

create table2 (new definition)

insert into table2 SELECT * from...

You've had this working on dev for 9 months or on prod??

This code will fail in multi-user execution.

Try this, create a temp table in connection 1 in ssms...

Ok then try my trick with exec & tableresults see if that works for you.

What error are you getting atm?

Just my 0.02$, I always preffer to save the output of checkdb.

I have a perm table in which I run

insert into dbo.table (columns)

EXEC ('')

I...

You guys really need to learn english. There was rarely, if ever, a better written question.

It clearly stated to execute 3 batches separately with begin / end points in...

How can I possibly know that? I don't see you're screen and I can't investigate nor did I ever see those queries before.

I'd love to help but I have...

http://sqlfool.com/2011/06/index-defrag-script-v4-1

Lavanyasri (10/3/2011)

---

HI All,

I am continuously seeing the below queries taking more cpu time .

EXEC master..xp_sqljdbc_xa_end @P0 OUT, @P1 OUT, @P2, @P3, @P4

EXEC master..xp_sqljdbc_xa_start @P0 OUT, @P1 OUT, @P2, @P3, @P4,...

Well the real issue is that you should know in advance to what table you need to get data from. This is the funcdamental problem you have to fix...

Jeff Moden (10/2/2011)

---

I can...

Evil Kraig F (9/30/2011)

---

Lexa (9/30/2011)

---

Defrag with the overallocated DB? What do you use for defraging and...