Viewing 15 posts - 11,821 through 11,835 (of 22,224 total)
Yeah, it would have to be. That's my understanding of how it works.
Heaps are generally weak tables. They have a place in design, but their use should be relatively exceptional....
"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
September 25, 2011 at 5:53 am
a) It depends. Over the last few years I was, in a very lazy fashion, looking for work. I did some interviews, but I wasn't really serious about it. 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
September 25, 2011 at 5:50 am
Just a question, is SQL SErver the only service running on this machine? If so, give it all the memory it can take (leaving a couple of gb for the...
"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
September 25, 2011 at 5:40 am
For remote queries, to see what they are doing, you must look at those queries on the remote server as well as locally.
"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
September 25, 2011 at 5:34 am
I went back and read the article again because it just doesn't feel right to me somehow and then I saw this:
The more I travel, the more I observe that...
"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
September 23, 2011 at 11:19 am
GSquared (9/23/2011)
Grant Fritchey (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading...
"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
September 23, 2011 at 11:06 am
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading about muck-raking journalism...
"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
September 23, 2011 at 11:00 am
GilaMonster (9/22/2011)
SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/
Chapter 8: "The how and why of Page Restores", Grant...
"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
September 22, 2011 at 3:10 pm
jcrawf02 (9/22/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
September 22, 2011 at 10:44 am
Ninja's_RGR'us (9/22/2011)
Kiara (9/22/2011)
GilaMonster (9/22/2011)
Jim Murphy (9/21/2011)
And where's Gail? Is she not keeping you guys in line?
Doing the final checks and tweaks on Jonathan's book.
Keep this lot in line? How...
"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
September 22, 2011 at 6:24 am
forsqlserver (9/22/2011)
Nice Grant...But this is giving the error of invalid arguments...means some invalid...how does it related with plan...
Sorry, you have to be more clear what "this" is.
This works fine...
"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
September 22, 2011 at 4:43 am
Waits stats will show you what processes are waiting on, but you won't see what's up with that single request. Instead, I'd suggest using Dynamic Management Objects (DMOs). You 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
September 22, 2011 at 4:30 am
Scripting would be the only way I'd consider it. Even if you just backup & restore msdb to the other server (which won't work), you still need to deal with...
"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
September 22, 2011 at 4:20 am
Assuming you want to minimize downtime, you might want to look into setting up log shipping so that you can get the TB worth of data moved over and only...
"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
September 22, 2011 at 4:17 am
It really depends on the size of the company and your disaster recovery plan. My former employer was rather large. We had an offsite facility, several hundred miles away that...
"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
September 22, 2011 at 4:15 am
Viewing 15 posts - 11,821 through 11,835 (of 22,224 total)