Viewing 15 posts - 6,091 through 6,105 (of 22,226 total)
audiocool (5/18/2015)
Many thanks for your valuable advise. Could you please guide me through the steps to troubleshoot the problems in my environment. I had around 10 databases with 2...
"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, 2015 at 6:53 am
From what you're describing here, just a backup and restore will work. But if you're only looking to move the structures and the DDL for the database, you might consider...
"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, 2015 at 6:49 am
If you look at the plans, the very first operator, the SELECT operator, has a little exclamation mark. That's a warning. If you open the properties for this, you'll get...
"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, 2015 at 4:46 am
Jeff Moden (5/16/2015)
Me: Tell...
"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, 2015 at 4:00 am
David Webb-CDS (5/15/2015)
"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, 2015 at 3:33 am
Better to understand why you're getting different plans. Usually this is because of differences in statistics between the machines. But, it could be other stuff. For example, differences in 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 16, 2015 at 3:25 am
Sean Lange (5/15/2015)
Luis Cazares (5/15/2015)
Leading...
"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 15, 2015 at 10:45 am
Luis Cazares (5/15/2015)
Leading commas or...
"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 15, 2015 at 9:50 am
Eric M Russell (5/15/2015)
Grant Fritchey (5/15/2015)
"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 15, 2015 at 9:27 am
Alvin Ramard (5/15/2015)
Grant Fritchey (5/15/2015)
"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 15, 2015 at 7:19 am
What Gail says ( pretty much what I always say).
The way I usually put it, build your structures and write your queries with the fact that there is an optimization...
"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 15, 2015 at 6:45 am
Biggest thing to remember is that you're going to have to maintain a two-phase commit on your transactions. You have to successfully write to both SQL Server and Couchbase 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
May 15, 2015 at 6:42 am
mdsantos (5/15/2015)
But after some minutes I get "...
"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 15, 2015 at 6:39 am
Just this, all by itself, is going to lead to poor performance:
ltrim(ppt_ClaimsManagerDescriptionManual)
If you can't bring in a consultant, and I'm with Kevin, you need to, second best choice, get...
"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 15, 2015 at 6:38 am
Alan.B (5/13/2015)
RECOMPILE and Copying the parameter as a local variable will likely eliminate that possibility of parameter sniffing.
Careful, those are two very different possible solutions to a bad parameter...
"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 15, 2015 at 6:36 am
Viewing 15 posts - 6,091 through 6,105 (of 22,226 total)