Viewing 15 posts - 10,231 through 10,245 (of 22,219 total)
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
Hmm... Don't know. I thought it was already available.
"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:28 am
Thought of one other place where I store a lot of my scripts. My blog. I put more stuff up there than anywhere else, and it's always online when 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
December 3, 2012 at 6:15 pm
ScottPletcher (12/3/2012)
SQL should be able to easily do "simple parameterization" -- the old name, "auto-parameterization", seems clearer to me -- on that query. That is, SQL...
"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 3, 2012 at 6:13 pm
I have a blog post on the basic things to look at first[/url] when you're looking at an execution plan. That's where I would start.
As to the XML plans....
"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 3, 2012 at 11:58 am
Yes, that's an indication that you're probably using dynamic or ad hoc queries and every single variation of the parameter values is resulting in a different execution plan. That's really,...
"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 3, 2012 at 10:46 am
Viewing 15 posts - 10,231 through 10,245 (of 22,219 total)