Viewing 15 posts - 12,541 through 12,555 (of 22,224 total)
If you're trying to isolate it for a restore or some other operation, set it to restricted user and use the ROLLBACK IMMEDIATE command. It will immediately cause all connections...
"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, 2011 at 6:19 am
Yes, some of the counters are available from Dynamic Management Objects.
Take a look at sys.dm_os_performance_counters.
"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, 2011 at 5:17 am
It's possible that you're hitting resource contention when running both these processes at the same time. I'm assuming users are also accessing the system? You may want to separate 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 18, 2011 at 5:15 am
There is no table where this information is stored, but you can look at the default trace to see if the information is available there. It would only not be...
"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, 2011 at 5:12 am
And if the constraint is not valid, the optimizer won't use it for simplification, eliminating tables from joins when it can because it knows the data will be available 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 18, 2011 at 5:01 am
In general, except for data, most of the time the flow of structural changes is not from production down to a dev or test environment, but the other way, 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
May 18, 2011 at 4:59 am
You could create a table with the list of distinct database names and then run a query against that to provide a list of files for the backup. That's 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 18, 2011 at 4:56 am
The information is available, but it's not collected in a month-to-month fashion. You have to make that collection yourself. I'm assuming you don't have monitoring set up. I'd start there.
"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, 2011 at 4:47 am
Steve Jones - SSC Editor (5/17/2011)
Grant Fritchey (5/17/2011)
True, but this one time, I'm taking the supposed high road. I've posted that I have sessions. I'm done. Vote or not. I'm...
"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, 2011 at 10:09 am
Ninja's_RGR'us (5/17/2011)
Here's another option...
Excellent! I didn't want to bring it up, but this is a perfect solution, and one that uses very few disk resources to give you a perfect...
"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, 2011 at 7:30 am
Anjan Wahwar (5/17/2011)
Grant Fritchey (5/17/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
May 17, 2011 at 7:28 am
Jeff Moden (5/17/2011)
Grant Fritchey (5/16/2011)
Jack Corbett (5/16/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
May 17, 2011 at 7:27 am
buferis12 (5/17/2011)
ahh thats bad 🙁 SO reverse engineering wouldn't help too? Btw, yeah there is things called stored procedures in that db.
There you go. You can't possibly know what's going...
"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, 2011 at 5:24 am
Without a transaction, a rollback of a delete statement requires you to have already stored the data elsewhere. If you really need complete recovery and you're working within DTS, why...
"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, 2011 at 5:12 am
Not a problem. Nice to have met you.
"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, 2011 at 5:03 pm
Viewing 15 posts - 12,541 through 12,555 (of 22,224 total)