That sounds familiar.

A few years back...

Ray K (12/21/2009)

---

Hypothetical situation: let's say my .NET OOP code and my SQL Server reside on different servers. I have a large amont of data (let's say, 5,000...

Ok, good.

I have seen this before, can't necessarily tell you exactly what causes it though. Sometimes things like an index rebuild will 'fix' corruption. It could also have been that...

I'm still working. Need to get a report done for current client for when they get back from vacation. Doesn't really bother me, I have plenty of time to get...

Seth Delconte (12/18/2009)

---

I think there are some serious advantages to using stored procs over raw ad hoc SQL queries. Stored procedures allow your queries to become more efficient, as...

Here's my reason for recommending stored procedures.

If the procedure is performing poorly, someone (the DBA, the developer, an outside consultant, etc) can take the proc, tune it, ensure that it...

What what will give you is all indexes that have had at least one update but no seeks, scans or lookup since the database was last started. It won't show...

Maybe I'm missing something here, but how on earth is using SQL 2008 Enterprise edition instead of SQL 2005 Standard Edition saving money? The licensing rules for the SQL 2005...

Please run the following from management studio and post the full output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

I do hope you have a clean backup of that database. Also, take...

Alvin Ramard (12/21/2009)

---

You're not missing anything....

Am I missing something with this thread?

http://www.sqlservercentral.com/Forums/Topic836986-146-1.aspx

Seems odd to ask on a forum for the reason that a drive is missing from a server.

Set up a test server and try the upgrade out. Seriously, you should not be considering doing something like this to your production server without any idea what's going to...

Then speak to whoever is in charge of the server and storage and ask what happened to the drive.

You're going to have to give us more than that it you want help. The exact error would be a start. What the "Backup is doing with query." really is...

Generally no. Blocking usually...