Viewing 15 posts - 16,756 through 16,770 (of 22,228 total)
This will be my first time in Vegas too. I'm not crazy about gambling, but I understand other forms of entertainment are available. I'll spend most of my time at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 13, 2009 at 6:02 am
Kit G (8/12/2009)
Grant Fritchey (8/12/2009)
I'm pretty sure they are. There was a new printing of The Moon is a Harsh Mistress just recently. I'm rereading Farnums Freehold on my Kindle...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2009 at 6:47 am
Kit G (8/11/2009)
Bob Hovious (8/11/2009)
Maybe one day there will be a remake that gets it right.
Well, the remake might get the specials correct (the bugs, suits and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2009 at 5:35 am
I am not witty, but here's my pass:
No Longer Single Double
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2009 at 8:03 am
GilaMonster (8/10/2009)
Chad Crawford (8/10/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:32 pm
I do want to raise one point that was mentioned earlier. In 130 or so comments, where is the author? I think he put forward an honest best faith effort...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:24 pm
GilaMonster (8/10/2009)
timothyawiseman (8/10/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:17 pm
timothyawiseman (8/10/2009)
GSquared (8/10/2009)
Have to sort of disagree with you on this one. Temp tables cause statement recompiles in 2005/8, and proc recompiles in 2000, but even those are often/usually...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:16 pm
GilaMonster (8/10/2009)
Grant Fritchey (8/10/2009)
In my haste I even missed things, like using a WHILE loop as a cure for cursors... when will that die?
Well, they are a cure for cursors....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:40 am
I agree with Paul. Split up the machine and you should be good to go. However, it's worth noting, the "good" instance might not be quite so good any more.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:34 am
It was a good faith effort, but based on the "Oh boy, I gave this 5 stars, my life is better" responses that were in the discussion in a few...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:34 am
I saw Gail's answers and I think she hit the ones I was going to hit, but I'm feeling the need to pile on a bit.
#8: KEEPFIXED PLAN can...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:21 am
That's tough. But in terms of performance, you could still use a TOP with an ORDER BY and arrive at one row, if somewhat randomly. It usually performs better,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2009 at 7:02 am
Well, it's possible, if you're backing up to the same place every time, that your backups are aggregating within a single file. If so, when you run a restore, you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 8, 2009 at 5:13 am
Agent alerts is the easy way. Why have something polling the server when it's already built in.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 7, 2009 at 3:41 pm
Viewing 15 posts - 16,756 through 16,770 (of 22,228 total)