COOL_ICE (10/6/2009)

---

If data lost is very negligible and your management can afford the data loss, you are good to go.

Run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS on Live DB

If data loss id...

Can you have a look at the SQL error log. Please post all of the error messages relating to this database

Traceflag 1400 is only needed if you're running SQL 2005 RTM. If you're running SP1 or above, it's not needed,...

repent_kog_is_near (10/6/2009)

---

Guru

All your points are well taken. Yes, the DB is heavily hit for I/O bottleneck (we use perfmon-Avg. Disk Queue Length is 27; % disk time 2100; Current Disk...

repent_kog_is_near (10/5/2009)

---

Steve

I have read some emphasis to take out all clustered index into .ndf; some take all non-clustered into ndf. I guess what you saying is regardless of C or...

Offhand I don't, but...

Did you read the article?

Table definitions and index definitions please.

See if you can narrow down which query is the problem. It may just be one of them, or it may be that proc that's called at the bottom. The...

Here's the breakdown of the exam - http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-443&Locale=en-us#tab2

wodom (10/5/2009)

---

Steve Jones - Editor (10/5/2009)

---

It's easy to say I want to do this, but think about the times where you have an issue. What if you get halfway through...

Guru Nagabhushan (10/5/2009)

---

The trouble is , as I said before, it is escalating the amount of deadlocks and increasing our run times for the "batch" because it has to come...

Would you mind sharing the actual subject and context for the question?

Homework? Test? Interview?

SELECT

CAST([2] AS VARCHAR(50)) AS [Size],

CAST([3] AS VARCHAR(50)) AS Placement

INTO #Parse

FROM Split

PIVOT ( MAX(value) FOR idx IN ( [1], [2]) ) AS P

A disk full error shouldn't take a disk offline. What does the cluster log say?