Start by notifying anyone relevant that the data has probably been lost, because that's the likely outcome without backups.

What exactly are you trying to do and what are the error...

Restore from your last good backups. That's the only reliable solution.

Table definitions, index definitions and the actual execution plan please?

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

How many people can quote the textbook definitions of 1NF, 2NF and 3NF from memory in complete sentences? There was no delay on that particular answer,...

Rod at work (7/21/2015)

---

Very much to my surprise the first query resulted in a count of 10432 records. However the second query returned 10433 records?! How is that possible? Could...

Parameter sniffing, or more correctly lack thereof. google: Grant Fritchey parameter sniffing, you should get one of his articles.

What exactly do you mean by 'won't run'?

Powershell should have a method. It's not really something that you'd do within a database.

If this database is critical, don't fiddle with writepage or similar, you could easily make things worse. Export what data you can, recreate the DB, get the system up and...

If the output listed is all that checkDB returned, this is not repairable.

Restore from your last good backup. If you don't have a backup. Script the objects out (tables,...

The info in the transaction log will be the same no matter if the admin console is used, management studio or anything else. The host name won't be there. The...

There's nothing you can tune with that query. You're telling SQL to create a duplicate copy of the table, so it has to read the existing table from disk (if...

Why do you think hash joins are a problem?

http://www.sqlservercentral.com/articles/Performance+Tuning/115825/

To be honest, that's one of the fairly safe upgrades. 2000 -> anything is one that's very likely to have something break. Anything -> 2014 needs testing because of the...

Yes, because without quotes that's getting treated as a mathematical expression, specifically as two numbers being subtracted from 2015.

2015 - 07 - 20 = 1988

The calculated value of 1988 is...