Viewing 15 posts - 5,221 through 5,235 (of 22,224 total)
You need to be able to grant access to an account to the drive locations where the backup is going to go. That's why it should be a network account....
"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
January 18, 2016 at 8:33 am
I hope the move between servers is meant to be permanent, or that you took a backup, using the BACKUP DATABASE command before you did the move, because what 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
January 18, 2016 at 8:31 am
Yikes.
OK, well, the way to solve this would be using a recursive CTE and the OVER...ORDER BY clause... but thousands? No. It basically won't work. I'm think 3-5 or even...
"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
January 18, 2016 at 7:45 am
Is it always three values or is it any number of values?
"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
January 18, 2016 at 6:34 am
This is not a problem I've run into, but it seems that killing the process ngen.exe has helped a number of people solve this problem.
"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
January 18, 2016 at 6:22 am
So I assume it's keyed off the accountid, but what determines the order? if it's just ordinal, we might have a problem because you can't guarantee order without an ORDER...
"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
January 18, 2016 at 6:01 am
I'm with John, that makes perfect sense based on the data you're showing.
Side note, get in the habit of identifying the owner of every column in your queries, not just...
"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
January 18, 2016 at 5:15 am
I'm confused then.
As written, you can run the code you're showing, anywhere at all. It's basically hard coding values into a table variable. What does that have to do 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
January 18, 2016 at 4:44 am
By and large, if the data entry is variable in length, I use VARCHAR even though it might be more likely to fragment. That's why we do maintenance 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
January 18, 2016 at 3:10 am
I don't see either a WHILE loop or OPENQUERY in the code.
"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
January 18, 2016 at 2:26 am
rodjkidd (1/15/2016)
I...
"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
January 15, 2016 at 3:42 am
Not if they're dbo. You can't deny much to someone at that level. Instead you'd need to grant them individually each of the dbo level permissions, but not allow them...
"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
January 15, 2016 at 3:07 am
Ed Wagner (1/14/2016)
Alvin Ramard (1/14/2016)
SQLRNNR (1/14/2016)
Alvin Ramard (1/14/2016)
Anybody coming to Nashville's SQL Saturday this weekend?
I know a few people that are. Timing was bad for me. I am going to...
"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
January 14, 2016 at 1:37 pm
Ed Wagner (1/14/2016)
Phil Parkin (1/14/2016)
Grumpy DBA (1/14/2016)
"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
January 14, 2016 at 7:10 am
Grumpy DBA (1/14/2016)
"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
January 14, 2016 at 7:09 am
Viewing 15 posts - 5,221 through 5,235 (of 22,224 total)