@gail

1000 pages or 10000 pages ?

well it depends , sorting willbe done in either of...

appple (8/11/2010)

---

I done Rebuild On Non clustered Index,

before rebuild on my index, framentation percentage is 80%,

after rebuilding indxes it is showing me same percentage,

Can Please Suggest me on...

Reading books : storing data in table variables

small practice : storing data in temp table

lots of practice: storing data in physical table

daily a...

SureshS_DBA (8/13/2010)

---

Hi Bhuvenesh

the inputBuffer gives just the last transaction for that spid. As i metioned, If I ran another statement in same sesin, where I opened transaction, then it will...

Read this Multiple Instances of SQL Server

Post the Sp you are using for deletion along with related index/table definfiton.

Additionally, you can use "batch approach" to delete the heavy data volume.

try this ---------------------------------------------

-- Script to get file sizes from SQL Database

-- Script by Gareth Thompson (2010/08/06)

-- Tested on SQL 2005 and 2008.

---------------------------------------------

SET QUOTED_IDENTIFIER OFF

SET NOCOUNT ON

DECLARE @dbname varchar(50)

declare @string varchar(250)

set...

that area(sp.script/job) will get failed where you have hardcoded the password

this can give you

declare @spid int

select @spid = spid from sys.sysprocesses where open_tran = 1

dbcc inputbuffer(@spid)

but it needs to be executed ...

Any example or link ?

Yes i accept that i am not good in Sql but this is the...

Post the table defintion/index defintion and sample data along with desired sample output.

See how to post queries article from my signature:-)

you can also use profiler to see where things are being holding up

ekknaveen (8/11/2010)

---

There is a SP running and its very big to paste it here. But can anyone tell me why its coming and how we can overcome with this. It...