how big is the table? on a HP DL 380 G5 with 22GB RAM and 64 bit software it took us close to a day to drop a non-clustered index,...

check out Evault or Avamar which is now part of IBM or EMC. Forget which one.

is this on HP hardware? if yes you can look at the stats on the...

drop any clustered indexes on the table

drop the PK

create a new PK specifying clustered

i personally think DTA is a piece of junk. i just look at the query and see which indexes need to be created and create them. sometimes i test in...

i'm troubleshooting a similar issue. We have an app that usually uses a subscriber for R/O access. Few weeks ago we failed it over to the publisher while we worked...

i tried this on one of our new 64 bit boxes with 20GB RAM. Still spikes it to 100%, but it runs in like 30 seconds compared to 10 minutes...

where i work they went crazy with UDT's a few years back and now almost every column in almost every table is a UDT

reason is to enforce business rules. sales...

about a month ago i had a strange problem. server rebooted after a BSOD and db went into suspect mode. errors about sql server can't obtain a lock.

kicked everyone out...

i'll be changing things on a QA server and will set this there to see what effect it has

if this runs as a sp won't it run step by step under one spid? if you want check my post history, i posted my check blocking script a few...

from what I read on AWE and 64 bit it depends. you have to test and some workloads will benefit and others will be worse. Slava doesn't say to do...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=360&messageid=355979#bm356969

the online will only work if you have Enterprise Edition

i think on tape it's rar so if you can read the tape as bare files you can do it. look in your tape drive documentation to see if it...

/****** Object: Table [dbo].[blocking] Script Date: 07/17/2007 11:34:39 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[blocking](

[tabID] [int] IDENTITY(1,1) NOT NULL,

[spid] [smallint] NOT NULL,

[status] [varchar](50) NOT...

/****** Object: StoredProcedure [dbo].[check_blocking] Script Date: 07/17/2007 11:33:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE procedure [dbo].[check_blocking]

as

/*

select distinct a.spid, substring(a.status,1,10) status, a.blocked, substring(a.NT_Login,1,16) NT_Login,

substring(a.program_name,1,24) program_name, a.real_time,...