Viewing 15 posts - 31 through 45 (of 81 total)
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...
March 7, 2012 at 2:24 am
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...
March 6, 2012 at 10:30 am
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...
January 31, 2012 at 4:19 am
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...
December 23, 2011 at 9:42 am
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...
November 9, 2011 at 4:29 am
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...
July 4, 2011 at 2:15 am
David Hutcheson (6/14/2011)
Really? This is the fifth most common SQL Server error? After using SQL Server pretty much every...
June 14, 2011 at 2:14 am
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...
June 9, 2011 at 2:03 am
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...
March 18, 2011 at 6:46 am
Taking my fiancee out for her birthday 🙂
March 11, 2011 at 4:40 am
December 22, 2010 at 8:28 am
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...
December 22, 2010 at 7:14 am
October 11, 2010 at 3:16 am
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,...
October 11, 2010 at 2:45 am
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,...
August 4, 2010 at 10:02 am