What version of SQL and what edition?

If you have 2005/2008 Enterprise Edition, consider table partitioning for your large table. Then you can switch partitions out to do archiving. Works...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic882515-1549-1.aspx

http://www.sqlservercentral.com/articles/Indexing/68439/ and the rest of the series.

Also, there's a lot of information, especially on index architecture in the SQL Books Online. Have you read all of that?

If you still have...

When dealing with a cluster, only shared drives that are dependencies of the SQL Server service are accessible from SQL Server

In general, use two different temp tables or, instead of dropping the temp table, truncate it and change the second select into to an insert into.

SELECT #Customer.*

INTO #CTemp

FROM #Customer

WHERE #Customer.zip_code...

Points for posts, points for answering QotD correctly.

http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

Maybe I'm missing something, but that entire piece can be one update statement

update customer

set local_fl = CASE zip_code WHEN '92646' THEN 1 ELSE 0 END

Does that work? I honestly can't...

Tom Van Harpen (3/12/2010)

---

I checked out the article when I think back to the profiler output (don't have it in front of me) but it appeared that it may have...

No! The errors in your logs, the ones that I quoted...

Why not? Detach/attach and backup/restore will result in the same thing. A database converted to the new version on the new...

Alvin Ramard (3/12/2010)

---

I'm waiting for the I'm Not a DBA Competition. I'll nominate myself...

Because that's a variable in the first script (not a parameter), SQL can't tell what they value of it is at compile time and it has to make a guess...

You have IO problems. Get some diagnostics running on those drives or, better idea, get the DBs onto different storage before they completely fail.

A read of the file 'S:\MSSQL10.MSSQLSERVER\MSSQL\DATA\central_city_Data.MDF' at...

Paul White (3/12/2010)

---

GilaMonster (3/12/2010)

---

Gianluca Sartori (3/12/2010)

---

That would be funny! I was officially nominated DBA two weeks ago, it's a bit early to enter a competition and pretend that I'm "exceptional"!...

It's a local security policy setting. Grant the SQL Server Service account rights.