GT-897544 (2/17/2010)

---

If failure was at I\O SAN controller level, Server Team had already told you before you go to check SQl server error logs that it is hardware failure, Even...

It looks like the only difference is the sequence. Is that correct? If so, you'll need to specify how you want it ordered, otherwise SQL just gives you...

Lynn Pettis (2/17/2010)

---

GSquared (2/17/2010)

---

SuzDBA (2/16/2010)

---

The business purpose revolves around the fact that right now the application does not perform optimally and the load of all databases on 1 server would...

peterzeke (2/17/2010)

---

...

GSquared -- yeah, the relationships get kind of goofy. Technically, cost is associated with a claim; specifcally, the cost is associated with a service not a diagnosis. But, when...

SuzDBA (2/16/2010)

---

The business purpose revolves around the fact that right now the application does not perform optimally and the load of all databases on 1 server would be too much....

GT-897544 (2/16/2010)

---

GSquared (2/16/2010)

---

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very...

GT-897544 (2/16/2010)

---

RBarryYoung (2/16/2010)

---

tstaker (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the impression...

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

Before you get into a dander any further. I have a couple questions, has this actually happened to you and how did you solve it? ...

Books Online DBCC CHECKDB uses an internal database snapshot for the transactional consistency needed to perform these checks. This prevents blocking and concurrency problems when these commands are executed. For...

Sounds to me like a normalization problem. The dollar amount should either be treated as a line-item, which means summing them up will give a correct result, or should...

Elliott W (2/16/2010)

---

GSquared (2/16/2010)

---

Judging from this and other forums, yes, there are troll DBAs. My main concern with them is that they give this kind of garbage out, and...

You have a problem in this line:

set @hours=(RTRIM(@minutes/(24*60))

Three open-parens, two closes.

Those can be a pain to spot by eye.

Possible? Yes. Advisable? Almost never.

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

Alvin Ramard (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get...

tstaker (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the impression that he...