Viewing 15 posts - 5,686 through 5,700 (of 22,219 total)
If you hit problems with the book, you can always post questions here.
"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 19, 2015 at 5:26 am
Here's the documentation on how to use ATTACH.
"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 19, 2015 at 4:09 am
BL0B_EATER (8/14/2015)
Grant Fritchey (8/13/2015)
Eric M Russell (8/13/2015)
"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 14, 2015 at 8:46 am
The fact that it ran differently on your machine could very easily be because it compiled a new, and better, execution plan on your machine. Also, what about blocking 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 14, 2015 at 8:43 am
They should be. They don't have to be. I'd sure put them up there. You'll pay for those VMs, but those costs should, by and large, be less than moving...
"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, 2015 at 1:06 pm
Eric M Russell (8/13/2015)
"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, 2015 at 12:12 pm
That makes absolute sense.
"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, 2015 at 12:11 pm
Interesting. Then it prefers to use an average of the statistics and a generic plan, not a specific plan based on a value. Sounds like it might be bad parameter...
"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, 2015 at 11:49 am
Luis Cazares (8/13/2015)
GilaMonster (8/13/2015)
Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.
That reminds me of a job posting I recently received on the mail....
"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, 2015 at 11:38 am
SimonH (8/13/2015)
The Data Factory, looks like somewhere to start, looks interesting an were going...
"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, 2015 at 11:36 am
Capture the plan when it's gone bad and when it's good. Look at the Properties for the first operator. You'll see the compile time values used. That should let 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 13, 2015 at 11:35 am
SQLRNNR (8/13/2015)
Grant Fritchey (8/13/2015)
caojunhe24 (8/12/2015)
#temp is much more useful than @tempReally? What about in the case of recompiles?
Or a user-defined table type?
Better yet...
A user defined memory optimized table type?
What about...
"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, 2015 at 11:33 am
If they don't have an SLA that prevents, then I'm all for going into the single database for stuff that belongs in that database for all the reasons you list.
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
August 13, 2015 at 11:31 am
Sean Lange (8/13/2015)
Grant Fritchey (8/13/2015)
Lynn Pettis (8/13/2015)
Ed Wagner (8/13/2015)
I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.
Having been...
"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, 2015 at 9:44 am
Luis Cazares (8/13/2015)
Eirikur Eiriksson (8/13/2015)
Grant Fritchey (8/13/2015)
WayneS (8/13/2015)
Crystal Ball, report to Aisle 5
I'm sure that a large part of this is English as a second language. But lordy, can 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
August 13, 2015 at 9:43 am
Viewing 15 posts - 5,686 through 5,700 (of 22,219 total)