Viewing 15 posts - 1,966 through 1,980 (of 18,926 total)
If scripted, this won't affect perf at all.
October 18, 2011 at 6:55 am
I preffer a trace for this.
Error logs are for errors (in my preference). I don't like parsing 1 gazillion succesful logins to get to the 1-2 errors I need...
October 18, 2011 at 6:39 am
Missing a commit?
Missed a rollback (maybe a trigger)?
Are you sure the select / update match in the where?
October 18, 2011 at 6:31 am
ruan.keyser (10/18/2011)
Great stuff!Thanks
The whole blog is awesome.... if you can free up a few days (20+ hours of great videos too).
October 18, 2011 at 6:15 am
adlakha.22 (10/18/2011)
@ninja's_RGR'usWht u suggest to do?
I already gave my opinion.
I love perf tuning, but 30 hours of work for free is outside my charity range at the moment....
October 18, 2011 at 6:14 am
If you want even more checks than what the BPA does. Not sure if disk part is included in this list, but the author definitely knows about that.
October 18, 2011 at 6:04 am
Just a reminder of the goal of the OP. You guys were not supposed to play with the qry at all! 😀
Query Optimization using Indexes
October 18, 2011 at 5:58 am
SELECT COUNT(*) AS Total
, SUM(CASE WHEN Age >= 25 THEN 1 ELSE 0 END) AS CntAge25AndOver
, SUM(CASE WHEN Sx = 'M' THEN 1 ELSE 0 END) AS CntMales
FROM dbo.Table
October 18, 2011 at 5:49 am
Mithra (10/18/2011)
Not so urgent Ronald.Any help on this would do when you find time.This job is failing from long time with the same error.Thanks again.
While we wait for Gail, do...
October 18, 2011 at 5:47 am
Corruption on sql 2000 if anyone's interested in following Gail's advice (as soon as she reads this and starts giving it! :-D)
http://www.sqlservercentral.com/Forums/Topic1191903-5-1.aspx
October 18, 2011 at 5:27 am
Are you in a hurry to fix this?
I'd call in an expert on this one. I'm just not 100% sure you can fix it without losing any data (index...
October 18, 2011 at 5:25 am
pwalter83 (10/18/2011)
Ninja's_RGR'us (10/17/2011)
pwalter83 (10/17/2011)
Ninja's_RGR'us (10/17/2011)
Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.Issue resolved
So what was...
October 18, 2011 at 5:13 am
Jeff Moden (10/17/2011)
Ninja's_RGR'us (10/17/2011)
Jeff Moden (10/17/2011)
I certainly missed this one. Thanks folks! I really appreciate the great thoughts. :blush:Let's put it in the duplicate category ;-).
Let's not. 😉
Replication?...
October 18, 2011 at 4:57 am
It's weird how dirt and dir don't see quite as old as one another :-D.
October 17, 2011 at 7:15 pm
Jeff Moden (10/17/2011)
I certainly missed this one. Thanks folks! I really appreciate the great thoughts. :blush:
Let's put it in the duplicate category ;-).
October 17, 2011 at 6:54 pm
Viewing 15 posts - 1,966 through 1,980 (of 18,926 total)