Viewing 15 posts - 8,101 through 8,115 (of 22,219 total)
Koen Verbeeck (5/19/2014)
Grant Fritchey (5/19/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
May 19, 2014 at 7:50 am
free_mascot (5/19/2014)
If you have doubt and server is not production you can enable trace for the specific database and check the activities going on?
You can trace production too, surely. Just...
"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
May 19, 2014 at 7:39 am
If you're upgrading because of concerns about the general age of the software, then you should just upgrade to the latest version. There shouldn't be any discussion. But, any other...
"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
May 19, 2014 at 7:38 am
Security has frequently been a problem in SSDT. My recommendation would be to use the post-deployment scripts. That way you can break it down as needed, but still have 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
May 19, 2014 at 7:34 am
I usually just refer to row and column. They may not be 100% ISO approved terms, but, everyone knows what you're referring to for the most part. And if we'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
May 19, 2014 at 7:32 am
Nope. Just ran through all of it for an update to the book. It's as bad as it ever was.
"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
May 19, 2014 at 7:26 am
I have a query that uses the execution plans in cache to identify potential missing indexes[/url]. Just remember though, these are just potential candidates. You should thoroughly evaluate the recommendations.
"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
May 19, 2014 at 7:00 am
jcrawf02 (5/19/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
May 19, 2014 at 6:55 am
Jake Shelton (5/19/2014)
Ie alter the table structure to change datatype so that these match between tables, or create the indexes that use datatypes that match...
"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
May 19, 2014 at 6:24 am
If you used this:
Insert into table_name (j,k) values (Newid(),1123,456)
Then the default of NEWSEQUENTIALID wasn't actually used. Microsoft says that NEWSEQUENTIALID will be faster, so that's not a surprise. It's right...
"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
May 19, 2014 at 6:17 am
If you read the documentation on NEWSEQUENTIALID, you'll see that it says that each GUID generated is greater than the previous GUID (until you get a reboot), but not that...
"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
May 19, 2014 at 4:18 am
Yeah, seems reasonable. On my dev machine I just installed it right over the top of 2012 with no issues. Just so you know.
"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
May 18, 2014 at 7:05 am
SQLRNNR (5/16/2014)
Grant Fritchey (5/16/2014)
To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix the conversion so that the...
"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
May 17, 2014 at 4:30 am
17 indexes is not a small amount. That alone will negatively impact inserts and updates. So you should make sure you need all those indexes.
To address the scan, you need...
"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
May 16, 2014 at 2:23 pm
A CTE mostly just addresses formatting in this case. It's not going to change performance. You still have to address the things that I brought up or you'll just see...
"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
May 16, 2014 at 5:06 am
Viewing 15 posts - 8,101 through 8,115 (of 22,219 total)