application is running very slow...there are no blockings or dead locks....i know some changes can be made to sql query and i do see some i/o issues.thanks

Here is my config please help..

Microsoft SQL Server 2005 - 9.00.3353.00 (Intel X86)

Copyright (c) 1988-2005

Microsoft Corporation

Standard Edition...

in that case stmt_start shows 440 and stmt_end shows -1, what does this mean?

No for both. But the problem is fixed now after bouncing the server, should i back up the encryption key now?

thanks

ic...now got a better idea. So dropping a clustered index also rebuilds a NC and again while creating a clustered index rebuilds a NC , i didnt know that. I...

but why do i need to rebuild all the indexes when i can just drop and recreate one index on a table?

both please..

thank you so much guys, things are more clear now. There is a table with bunch of NC and one Clustered..all of them are fragmented, i think the quickest way...

so is it confirmed that rebuild clustered index WILL ONLY DROP AND CREATE CLUSTERED index and will drop/recreate the NC?

works for create table thanks...can you tell me the same way for create/alter stored procedure. I tried doesnt work since you cant have 4 part naming convention while creating proc..thnaks

hello, i am running into the same issue...how can i execute the output of SP on a remote server linked server..

Exec ('use Test_Script exec dbo.Test_CreateTable') at [ABC-DEV]

Msg 2812, Level 16,...

thanks....does that mean that if a procedure is running would it have more than one thread?

thanks Pradeep. I did read your article, it was helpful. Pradeep i do see different procs using most of the CPU but how would i know which sql inside the...

thanks for reply...sorry to ask this dumb question..but when can u say that CPU usage is high...i know sql server is using 98% of cpu...but lets say from the profiler...