Viewing 15 posts - 7,711 through 7,725 (of 22,224 total)
I actually had to support a policy management system at an insurance company and had to deal with latest versions similar to this. Largely you've already got good solutions from...
"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
July 17, 2014 at 1:25 am
Deadlocks are usually caused by a combination of poor performance and problematic coding choices. Not being able to see your structures, code or the output of the deadlock graph, all...
"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
July 17, 2014 at 1:20 am
murnilim9 (7/16/2014)
Jeff Moden (7/16/2014)
murnilim9 (7/16/2014)
Btw I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and...
"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
July 17, 2014 at 1:14 am
Threadizens!
Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.
"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
July 17, 2014 at 1:10 am
Could be that you've enabled Enterprise settings on the databases and that's being detected.
I wouldn't recommend doing an in-place downgrade of this type anyway. May just be my paranoia shining...
"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
July 17, 2014 at 1:07 am
Have a nightly process run from SQL Agent to make the checks to see if something is coming up in the next 48 hours, or whatever, and send an email...
"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
July 17, 2014 at 1:05 am
You can't have a second set of transaction log backups. That will absolutely break things. But you can set up full backups as Gail outlines.
"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
July 16, 2014 at 7:39 am
Sure, but how do you determine if there has been a change? If you always update a datetime column, maybe you can just check for updates since the last one....
"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
July 16, 2014 at 7:15 am
You can also look to extended events as a way to capture this sort of behavior, filtering to ensure you're only capturing queries against the table and only those queries...
"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
July 16, 2014 at 5:07 am
That's a giant topic and it's kind of hard to give you too much guidance in a forum post. Yes, most tables should have at least a clustered index. 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
July 16, 2014 at 5:04 am
manujaidka (7/16/2014)
Grant,There are 113443 rows in this table and all rows are distinct rows but, I ma confused why optimizer estimated 68412.4 rows than 68412??
Thank you..
Don't just look at 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
July 16, 2014 at 4:33 am
What about the histogram in the statistics. How many rows would fall within the range you specified within the histogram?
"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
July 16, 2014 at 2:23 am
As said above, you'll have to restore to a new database and then retrieve the data from there. You don't want to restore over your production systems since they'll 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
July 16, 2014 at 2:20 am
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
"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
July 16, 2014 at 2:15 am
The Dixie Flatline (7/15/2014)
Sometimes I think MVPs are a real pain in the ***. Present company excepted.
Yes they are. And speaking for this present company, I am too.
"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
July 16, 2014 at 2:04 am
Viewing 15 posts - 7,711 through 7,725 (of 22,224 total)