Viewing 15 posts - 17,041 through 17,055 (of 22,219 total)
GilaMonster (7/13/2009)
Lynn Pettis (7/10/2009)
On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.
For that matter, anyone heard from Grant? I think...
"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
July 13, 2009 at 6:24 am
Phil,
Sorry I didn't respond to this sooner. I've been away (enjoying SUMMER as opposed to what's going on in New England these days). I always knew you were more than...
"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
July 13, 2009 at 5:21 am
Oh, no. You don't want to capture it to the graph. You need to set up a counter log to capture the data to a file over time. I've got...
"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
July 1, 2009 at 9:23 am
It's not that complicated. Take a moment in time, say now, measure your production system for a period of time, I usually try for 24 hours and do it on...
"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
July 1, 2009 at 8:24 am
John Sansom (7/1/2009)
Grant, an “Annual Power Down” sounds like some sort of...
"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
July 1, 2009 at 7:55 am
Are you doing a complete refresh of the data every time? If so, you might want to consider getting an incremental process in place.
Structurally, another way to speed this up...
"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
July 1, 2009 at 7:52 am
Pretty much, you have to have a valid backup, the privileges on the server, and enough space to support the backup. That's about it. What were you looking for?
"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
July 1, 2009 at 7:36 am
Minimum once a year during our annual power down, but in general we try to keep them up as long as possible. In practice, it's probably 2-3 times a year...
"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
July 1, 2009 at 7:34 am
GSquared (7/1/2009)
Grant Fritchey (6/30/2009)
GSquared (6/30/2009)
GilaMonster (6/30/2009)
GSquared (6/30/2009)
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting...
"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
July 1, 2009 at 7:11 am
That's a pivot operation. Do a search on it. I'm not great at them, so you'd be better off looking up what the real experts have to say.
"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
July 1, 2009 at 6:26 am
Gianluca Sartori (6/30/2009)
GSquared (6/30/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
June 30, 2009 at 4:24 pm
GSquared (6/30/2009)
GilaMonster (6/30/2009)
GSquared (6/30/2009)
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting required. Let...
"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
June 30, 2009 at 4:18 pm
I ain't singing and I ain't dancing, but I will take one of those particle accelator things please.
"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
June 30, 2009 at 12:47 pm
Roy Ernest (6/30/2009)
At least I am not dead yet.... I am not a ghost....:hehe:
Heh. You really were skipped right by. Shame since you had the answer PDQ.
"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
June 30, 2009 at 12:29 pm
That looks like you're on the right track to me.
By the way, it's kind of a waste of space & time & readability to put 'tbl_' in front of table...
"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
June 30, 2009 at 12:15 pm
Viewing 15 posts - 17,041 through 17,055 (of 22,219 total)