Viewing 15 posts - 7,171 through 7,185 (of 22,219 total)
kevaburg (12/2/2014)
Grant Fritchey (12/1/2014)
"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 2, 2014 at 5:51 am
Nah, the other plan knew that it was only returning a single row from the seek too.
Pretty sure Scott's onto something. Indexes sure won't hurt and if you can...
"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 1, 2014 at 5:51 pm
Robert Frasca (12/1/2014)
Grant Fritchey (12/1/2014)
"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 1, 2014 at 11:26 am
The pain point on the WithMAX plan is the fact that it's doing a Loops join against 1.9 million rows. That's effectively a cursor. But, it looks like your full...
"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 1, 2014 at 10:54 am
On most systems, most of the time, the vast majority of tables should have, at minimum, a clustered index. I'll bet if you put it on the right place, in...
"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 1, 2014 at 8:50 am
Just because it's not an incrementing number doesn't mean that it's not a good choice for the clustered index. Also, the cost of an insert is usually quite high for...
"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 1, 2014 at 7:50 am
The trick would be to look at the execution plan to understand how your delete statement is being processed. Table scans can be costly depending on the size of your...
"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 1, 2014 at 3:35 am
Always go the Books Online for knowledge fundamentals. It's the single best and most accurate resource 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
November 28, 2014 at 8:52 am
Yeah, looks like you're running the release version. Just go here for details. There's also a link to the cumulative updates if you want to try them out.
"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
November 28, 2014 at 8:50 am
I don't know anyone having major issues with it. In fact, it seems to have fixed several problems people were having with 2012. I'd say it's been ready since April....
"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
November 28, 2014 at 8:48 am
You need to have indexes in place that will give the optimizer something to work with. As it is, the only option it has is to scan the tables.
"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
November 27, 2014 at 10:15 am
The differential backup will be used only if you specify it yourself for backups. It won't automatically run unless you set it up. The differential will only backup changes 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
November 27, 2014 at 10:11 am
Be sure you test the in-memory stuff on a non-production server. Once you create a database as in-memory, it has to stay that way forever. You don't want to do...
"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
November 27, 2014 at 10:08 am
Just disable the service. It's the kind of thing you may want to reenable in the future. Plus, it won't save memory, just storage.
"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
November 27, 2014 at 5:22 am
The GUID will fragment a lot more, that's for certain. I'd be inclined to use the three integers. They sound like the natural key anyway. And compound keys are not...
"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
November 27, 2014 at 5:21 am
Viewing 15 posts - 7,171 through 7,185 (of 22,219 total)