Viewing 15 posts - 10,231 through 10,245 (of 22,224 total)
Yep, Gus has it nailed. Management Studio is making that conversion. Plus, in the engine, SQL Server itself is using a binary to deal with execution plans, not XML, so...
"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
December 19, 2012 at 12:13 pm
Whatever your data structures are, so should your parameters be, both in data type and length. What do the structures look like?
"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
December 19, 2012 at 12:10 pm
CGSJohnson (11/21/2012)
Hi, Grant. Given it has been a while since your last post on this topic, and with the introduction of new releases of E/F, any new opinion(s)?Thanks...Chris
Nope. Sorry....
"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
December 9, 2012 at 4:38 am
Everything is getting fixed. Sorry for any issues.
"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
December 7, 2012 at 3:21 am
david.williams 50026 (12/5/2012)
No but i_att_type IS a column, how do I tell it to use that? I thought WHERE ID = i_att_type; was telling it WHERE to update?
No, it...
"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
December 5, 2012 at 7:00 am
david.williams 50026 (12/5/2012)
grrr I am using the following syntax:BEGIN TRANSACTION
UPDATE dbo.attcat
SET Val = 50
WHERE ID = i_att_type;
--ROLLBACK TRANS
But keep getting:
Msg 207, Level 16, State 1, Line 2
Invalid column name 'ID'.
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
December 5, 2012 at 6:49 am
david.williams 50026 (12/5/2012)
"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
December 5, 2012 at 6:23 am
Lars-640955 (12/4/2012)
"Free eBook: SQL Server Execution Plans, Second Edition"
And you can quote me on that one!
My time is my...
"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
December 5, 2012 at 6:07 am
Patrick Kansa (@pkansa) (12/4/2012)
No worries, 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
December 5, 2012 at 6:06 am
It's the book on query tuning. I'd suggest you get the 2008 version of the book. Most of what's in it will be applicable to 2000, unlike the 2012 book...
"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
December 4, 2012 at 11:08 am
kent.kester (12/4/2012)
To be honest, I had to read it a couple times and go through what I thought I knew before saying anything. 😉
Ha! I passed it along to...
"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
December 4, 2012 at 8:06 am
kent.kester (12/4/2012)
Found a typo in the Editorial Review:
My book leads you right from the basics of capturing plans, through how to interrupt them in their various...
"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
December 4, 2012 at 7:37 am
Thinking about it a little more, you can also look at using extended events. There's actually a blocked_process_report. But, I'm not sure exactly how to modify that. I may 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
December 4, 2012 at 4:53 am
I suspect that will work.
If you query sys.dm_exec_requests, you'll see that there is a pretty easy way to spot that you have blocking:
SELECTCOUNT(*)
FROMsys.dm_exec_requests AS der
WHEREder.blocking_session_id > 0;
Now all you 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
December 4, 2012 at 4:52 am
You could, but you'd be even better served by running a query against sys.dm_exec_requests and looking for blocked processes. This will work better because instead of having to execute 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
December 4, 2012 at 4:37 am
Viewing 15 posts - 10,231 through 10,245 (of 22,224 total)