Hi Gail,

Sorry maybe I didn't phrase it very well. The usual series of events is

- Procedure starts suffering from parameter sniffing (symptoms are time-outs in the web-app, usual speed in...

Hi HowardW,

I have read just read through that and had previously read the Erland Sommarskog page on the same topic that she refers to and unfortunately it's no help. We...

The link you referred to said it for me

"A computed column can not directly access any column outside its table. This limitation may be overcome by using a User Defined...

I got the answer right but only based on the American-centric nature of previous questions. A question for the Americans here though; if Reindeer is the logical answer and Turkey...

I don't like this move, and it's not just because it might prove more expensive, it just seems fundamentally wrong to start counting cores, and here's why.

Multi-core CPUs were largely...

Thanks for your comments, I can see how your second post could be useful in some circumstances if you had a common set of scripts you regularly used. Unfortunately as...

David Hutcheson (6/14/2011)

---

"SSMS does - just occasionally - report an error where none exists."

Really? This is the fifth most common SQL Server error? After using SQL Server pretty much every...

I think given the number of self-confessed 'accidental DBAs' I have come across on here, the more safety nets, the better. That's not to imply they necessarily need them but...

I think its interesting to note that the percentage for each answer is currently pretty close, certainly there is no clear leader of the 4. That says to me that...

Taking my fiancee out for her birthday 🙂

da-zero (12/22/2010)

---

paul.goldstraw (12/22/2010)

---

I got it right based on the fact that an update statement shouldn't ever be able to change the number of records in a table - since 8...

I got it right based on the fact that an update statement shouldn't ever be able to change the number of records in a table - since 8 rows were...

da-zero (10/11/2010)

---

paul.goldstraw (10/11/2010)

---

Well it looks like i'm going to be in the minority by saying i think it was a poor question. I got it wrong because I was expecting,...

Well it looks like i'm going to be in the minority by saying i think it was a poor question. I got it wrong because I was expecting, funny enough,...

Thank you 456789psw 🙂

Well our current system kind of works a bit like what you're describing. I am always wary of describing what we do where I work,...