Viewing 15 posts - 7,711 through 7,725 (of 22,219 total)
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
The only way I know of that you could currently do this would be to build it yourself. Whether you use SSIS or not is something of a discussion point,...
"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 15, 2014 at 10:25 am
I can't find the blog post at the moment, but Brad McGehee wrote up a great assessment comparing the benefits of index reorganization with the costs of index reorganization 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 15, 2014 at 10:22 am
I'm pretty sure there's no way to check that. You might look at the system health extended events session. It has a rolling log of certain events, but I'm pretty...
"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 15, 2014 at 10:12 am
murnilim9 (7/14/2014)
btw how do we find out which stored proc 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
July 15, 2014 at 1:11 am
GilaMonster (7/14/2014)
rodjkidd (7/14/2014)
Sadly I have no costume for Friday 🙁I'm still working on mine. Dunno how Steampunk it is though. Limited by the requirement it be easy to pack.
I checked...
"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 15, 2014 at 1:02 am
Viewing 15 posts - 7,711 through 7,725 (of 22,219 total)