Viewing 15 posts - 12,571 through 12,585 (of 22,224 total)
Jim Murphy (5/13/2011)
WayneS (5/13/2011)
My only regret was in not having more time to just sit around with all of them to chat and get to know them better.
I agree. I...
"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
May 14, 2011 at 5:07 am
WayneS (5/13/2011)
Brandie Tarvin (5/13/2011)
Alvin Ramard (5/13/2011)
Had to laugh when Grant mentioned DBCC TimeWarp in a presentation. 😀Oh, you have to share. In what context did he mention it?
Oh, just 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
May 13, 2011 at 7:02 am
That's a lot of questions at once.
My first suggestion, look at setting up a Central Management Server. This will allow you to take control of the other servers from a...
"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
May 9, 2011 at 5:43 pm
It really depends on the size of the database and the rate of growth. I wouldn't get hung on specific numbers. If a database is growing very slowly, it 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
May 9, 2011 at 5:36 pm
GSquared (5/9/2011)
"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
May 9, 2011 at 5:22 pm
ejavier.r.dk (5/9/2011)
Now, I want to use the info from the trace in SCOM, and I know SCOM...
"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
May 9, 2011 at 10:40 am
Not sure what article you're talking about, but I'd check the connection settings between the two. Probabably one has different ANSI settings than the other which leads to a different...
"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
May 9, 2011 at 8:24 am
If you really do want to learn the internals, Gail is right (something you can just say about most things, most of the time), Benjamin's book is a great place...
"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
May 9, 2011 at 7:23 am
Pretty much use Michelle's scripts. They're solid as can be. We had reasonably wide maintenance windows and the databases weren't terribly large (100gb each) so we did full maintenance 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
May 9, 2011 at 6:31 am
I'll be there.
"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
May 9, 2011 at 6:29 am
To add one thing to what Gail said:
... and you've tested them extensively on the query that you're planning to use them on.
Test, test, test and then test some 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
May 9, 2011 at 6:14 am
rootfixxxer (5/6/2011)
But one thing i don't understand, why there's such difference between 2000 and 2005,...
"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
May 9, 2011 at 6:04 am
The one thing you can do, that Gail was leaning towards, would be to have a table on a filegroup. You can restore a filegroup individually.but, the issue here is...
"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
May 9, 2011 at 5:36 am
Steve Jones - SSC Editor (5/6/2011)
I used to go to a networking conference with my boss. A bit of a boondoggle, but...
"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
May 7, 2011 at 4:51 am
vijayakumarn (5/6/2011)
Using the left join i can achieve only one record... but i want two more record respect to the values 'B' and 'C' in the table-2
Sounds like you're not...
"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
May 6, 2011 at 7:17 am
Viewing 15 posts - 12,571 through 12,585 (of 22,224 total)