Viewing 15 posts - 13,306 through 13,320 (of 22,219 total)
SKYBVI (2/11/2011)
@ gail..Then wats the alternative?
Regards,
Sushant
There is no alternative out of the box. If you need to track data changes you must create mechanisms for doing 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
February 11, 2011 at 6:06 am
But, the default trace doesn't track data changes. If you don't already have something auditing your database, a third party tool, or a server-side trace, there's no way to find...
"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
February 11, 2011 at 5:22 am
If you restore the file group, it restores everything in that file group. That means that all objects, all data, are reset back to what they were 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
February 11, 2011 at 4:17 am
If you have another drive with space available you can try to add a file there in order to get enough space to attempt to resolve the issue, whatever 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
February 11, 2011 at 4:05 am
sturner (2/10/2011)
1. requirements document
2. design specification (here is where you define database objects)
3. test plan document
4. development
5. test
6. beta release
7. final release
Everything follows step 1. some...
"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
February 10, 2011 at 6:51 pm
ramksharma91 (2/10/2011)
"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
February 10, 2011 at 6:49 pm
Have you looked into SQL Agent? That's how I schedule most stuff on SQL Server instances.
"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
February 10, 2011 at 6:39 pm
It's also possible, even though the plan changed, that you ran into resource contention or blocking or something else entirely.
Without lots more detail, it's hard to know. Based on everything...
"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
February 10, 2011 at 6:32 pm
But, almost forgot this, that assumes no compression. If you're using compression, all bets are off on making that estimate.
"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
February 10, 2011 at 6:29 pm
The backup consists of the actual space used in the data and log files (not the space allocated) plus a bit of room for meta data and some more 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
February 10, 2011 at 6:27 pm
I think it's possible that might lead to multiple plans (sort of, actually you're likely to see multiple plans for the different strings, but a single plan for the proc),...
"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
February 10, 2011 at 6:02 pm
Congrats Brandie. That's really wonderful. Well done.
"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
February 10, 2011 at 11:23 am
Brandie Tarvin (2/10/2011)
Ninja's_RGR'us (2/10/2011)
kasaranenikiran-725528 (2/10/2011)
"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
February 10, 2011 at 6:33 am
Ninja's_RGR'us (2/10/2011)
kasaranenikiran-725528 (2/10/2011)
"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
February 10, 2011 at 5:36 am
As soon as you need to start taking direct control over what is running within Maintenance Plans, you've just out-grown them. This is actually kind of a great moment. Now...
"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
February 9, 2011 at 5:06 pm
Viewing 15 posts - 13,306 through 13,320 (of 22,219 total)