Viewing 15 posts - 9,976 through 9,990 (of 22,224 total)
Extended events are the future. Trace events and Profiler are on the deprecation path. Just on that alone, you're doing the right thing. But the fact is, extended events operate...
"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
March 13, 2013 at 12:59 pm
What I meant was store the Month & Day values as those, either during the insert/update process or as calculated columns. Performing functions on columns in any kind of criteria...
"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
March 13, 2013 at 9:25 am
That's a screen capture of an execution plan. Not the execution plan. There are properties behind all those operators that tell a more complete store than just the graphical pictures.
"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
March 13, 2013 at 6:14 am
The amount of storage is the cause of IO, not the potential storage. If there are 300 bytes not used, they're not used. There's no additional cost for that. It'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
March 13, 2013 at 6:13 am
No, you won't get a conversion. You may see truncated data of course, but no conversion.
"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
March 13, 2013 at 5:37 am
Default ANSI connection settings maybe?
Take a look at the SELECT operator in both plans. Compare every value. What's different?
"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
March 13, 2013 at 5:01 am
A million individual insert statements is a horrible approach. Period. Doing it within a single transaction will be painful because you're going to have to have a huge transaction log...
"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
March 13, 2013 at 4:59 am
Without the execution plan to look at details, it's hard to know. Recommended indexes are just suggestions. First, I'd take a look at the SELECT operator to see if you're...
"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
March 13, 2013 at 4:56 am
You're getting type conversions on a couple of the columns. I'd look to see if that might be causing issues. Also, a Nested Loops join for millions of rows 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
March 13, 2013 at 4:50 am
PhilM99 (3/8/2013)
So why don't I write: My experiences constantly teach me: YOU KNOW NOTHING!
I agree. Constantly learning. I write anyway because someone has to do it. And yeah, the old...
"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
March 8, 2013 at 9:32 am
Bhuvnesh (3/8/2013)
Grant Fritchey (1/31/2013)
Get a copy of SQL Server 2008 Internals by Kalen Delaney. Then read it 100 times. You'll still be confused (as I am) but less so.
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
March 8, 2013 at 4:23 am
karthik M (3/8/2013)
is this a secret maintened by microsoft ? 🙂
Short answer, yes.
Longer answer, Microsoft publishes some of the internals because it helps people understand how or why things are...
"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
March 8, 2013 at 4:21 am
GilaMonster (3/7/2013)
Unless the data's small enough it can manage entirely within the memory grant. Not much chance of that except with trivial data.
Not arguing, just clarifying, won't it allocate some...
"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
March 7, 2013 at 9:34 am
I sure wouldn't turn on both. In fact, I'd suggest just using 1222, not 1204.
How about taking a look at the system_health extended event session. It automatically captures full deadlock...
"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
March 7, 2013 at 9:11 am
I don't have a document I can share with you. Sorry. Maybe something I need to write up.
The maintenance that is available to you with Azure SQL Databases is limited...
"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
March 7, 2013 at 6:41 am
Viewing 15 posts - 9,976 through 9,990 (of 22,224 total)