Viewing 15 posts - 10,006 through 10,020 (of 22,219 total)
The entire query is compiled when you execute it. But the path through the actual data will follow the CASE statement.
But, this example shows the problem with using this approach....
"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
February 14, 2013 at 5:11 am
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
"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
February 14, 2013 at 4:54 am
Ratheesh.K.Nair (2/13/2013)
Thanks Anthony.They want real time data..Any way??
Wait, they want real time static data? That doesn't make any 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
February 14, 2013 at 4:47 am
Brad's books is extremely good. You should also check out Thomas LaRock's book DBA Survivor. It covers the job from a different point of view.
"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
February 14, 2013 at 4:41 am
rodjkidd (2/14/2013)
Grant Fritchey (2/13/2013)
Dave Ballantyne (2/13/2013)
rodjkidd (2/13/2013) Remember stitting there with a bad, bad hangover, just hoping I didn't throw up 🙂
That sums up the sqlbits experience 😉
God I hope...
"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
February 14, 2013 at 4:05 am
SQLSACT (2/13/2013)
GilaMonster (2/13/2013)
Why would you see a tempDB allocation when something's not spilling to TempDB?
From Grant:
All temporary tables (hash/work tables, temp tables, table variables) are written to disk as well...
"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
February 14, 2013 at 3:55 am
Dave Ballantyne (2/13/2013)
rodjkidd (2/13/2013) Remember stitting there with a bad, bad hangover, just hoping I didn't throw up 🙂
That sums up the sqlbits experience 😉
God I hope not. I have...
"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
February 13, 2013 at 4:17 pm
Jeff Moden (2/13/2013)
"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
February 13, 2013 at 9:38 am
Cadavre (2/13/2013)
So, the SQL Bits agenda has been released, anyone going? I'm planning on grabbing a Friday ticket tomorrow morning, but unsure about the Saturday.
I'm presenting on Saturday. I'll be...
"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
February 13, 2013 at 8:17 am
Stats being out of date like that is only one possible cause of a spill, but yeah, that could be it. And yes, what you're seeing is SQL Server wants...
"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
February 13, 2013 at 8:09 am
Ever is probably an over-reaction, but in general these types of naming conventions just don't make sense. How is tblInvoices easier to understand than Invoices? How is it more clear?...
"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
February 13, 2013 at 7:18 am
Thanks for the kind words.
The differences in the tempdb usage are probably just down to the variations within the plan. As to exactly why you're getting what you're getting... I'm...
"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
February 13, 2013 at 4:05 am
I think we're back to the Roadhouse rule set here. Be nice.
"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
February 13, 2013 at 4:01 am
sqlfriends (2/12/2013)
Grant Fritchey (2/12/2013)
"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
February 12, 2013 at 10:23 am
If it's read only during the day, then the first thing I'd do is make the database a readonly database. That will eliminate all locking, which will help performance some.
There's...
"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
February 12, 2013 at 6:13 am
Viewing 15 posts - 10,006 through 10,020 (of 22,219 total)