Viewing 15 posts - 3,631 through 3,645 (of 22,224 total)
Can you use Agent? You could run a PowerShell script to remove it that way.
"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
August 25, 2017 at 11:04 am
I'm with HanShi. If it's the exact same version and edition, the only maintenance that's really necessary after a restore is a CHECKDB. There's not going to be anything else...
"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
August 25, 2017 at 6:46 am
Considering the amount of mixed technology you're dealing with, I don't have a simple solution for you. The one thing I can add to the conversation, I would absolutely do...
"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
August 25, 2017 at 6:42 am
"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
August 24, 2017 at 9:05 am
"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
August 24, 2017 at 9:03 am
"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
August 24, 2017 at 6:07 am
JohnDoe564 - Thursday, August 24, 2017 5:29 AMThanks a lot man... really appreciated!
Her name is Gail.
She just likes Star Wars (although...
"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
August 24, 2017 at 5:52 am
Pretty much this, DATEADD, on the columns in your predicate is going to lead to table scans which will absolutely lead to poor performance overall. You'd be better off with...
"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
August 23, 2017 at 3:35 pm
Depends on where the backups are stored really. If you're backing up to your production server, copy then restore, always (and stop backing up directly to the production server). If...
"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
August 23, 2017 at 12:38 pm
Pretty sure you already know the answer.
The email service on SQL Server was only ever really intended to act as an alerting mechanism for issues on 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
August 23, 2017 at 12:33 pm
I'd go straight to PowerShell for this. You can run the query, output it to a result set. Use the result set to delete the files. Way too simple. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 22, 2017 at 12:19 pm
"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
August 22, 2017 at 9:04 am
How many records would you expect to be returned by this: where uid=@uid
Is it one (or a few) or large numbers? The query itself as posted is very simple....
"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
August 22, 2017 at 5:32 am
Flat out, they're asking for crazy stuff. Even if you can find some type of solution to deliver what's being asked for, it's going to be a Rube Goldberg style...
"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
August 22, 2017 at 5:21 am
... I bring this up because I’ve recently heard several people 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
August 21, 2017 at 8:17 am
Viewing 15 posts - 3,631 through 3,645 (of 22,224 total)