several other things come to mind:

1) use the KEEPFIXED PLAN option that is available in 2000 (btw, you did say 2000 was your version, right? this is the 2005...

My guess is that you need a lower fill factor on the NC indexes coupled with routine maintenance to get back to that fill factor. This will minimize the...

How much free space is in the database? Are you allowing the database to grow using autogrowth or are you proactively sizing the database? If the former, double...

The server is obviously underpowered for what it is being asked to do. Period.

Having said that, I would go ahead and try the /3GB switch IF you...

I also believe that SELECT INTO #tmp... will be a minimally logged evolution whereas INSERTing into an already created temp table will be fully logged and thus less performant.

You CAN...

The SQL Server MVPs beat Microsoft up before and during the MVP summit in April. That and many other forces combined to make them realize that they had to...

From my earlier post: ...

A screenshot or two could be helpful here too. A picture is worth ...

My advice is to never use DTA at all!! I have seen it do AWFUL things to databases. Well, actually that works in my favor since I get...

Here is the Bible on deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

It is certainly conceivable that page lock escalation is involved in your problem. Perhaps you can set all indexes back to...

Andras Belokosztolszki (6/18/2008)

---

indraprakash (6/18/2008)

---

thanks,

But this is not the solution of my query. I want to know how to delete dulicate records without using any new table or any add any...

The main problem here is that you can never benefit from index seeks with encrypted columns. Thus performance is going to be suboptimal. To get around this you...

Take a look at ApexSQL Edit. Among its many incredible features is very nice source code control integration. Tell them TheSQLGuru sent you and you can pick up...

I strongly encourage everyone who wishes to do so to write "more readable/maintainable" code that involves cursors - and my email address is kgboles@earthlink.net. Keep that handy so you...

Not sure you can use that as a basis for avoiding cursors though. There have been many more bugs fixed (and likely many more exist) where set-based queries are...