Viewing 15 posts - 8,896 through 8,910 (of 22,224 total)
Sorry, based on such a general and vague set of information, I can't even begin to guess where the issues may be.
Look at the execution plan to understand how it's...
"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 17, 2014 at 9:14 am
arrjay (2/17/2014)
Grant Fritchey (2/17/2014)
Also, using table locking hints is pretty severe in terms of blocking off access to the system. Are you sure you need 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 17, 2014 at 9:01 am
Luis Cazares (2/17/2014)
"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 17, 2014 at 8:30 am
I'm going to take a guess and assume that you're not talking about my session called "Best Practices for Database Deployment" because I get into a lot of what you're...
"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 17, 2014 at 7:41 am
Track down a local user group and attend their meetings. There are also SQL Server events in the UK that are free. There are SQL Saturday events and SQL Relay...
"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 17, 2014 at 7:35 am
Yeah, I'd make sure that you're using WITH MOVE. It could just be that it's overwriting the files... which would only be possible if the database is offline.
"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 17, 2014 at 7:33 am
I think Jason's approach is better, but you could just disable the login from a SQL Agent job and then have another at the scheduled interval to disable the login....
"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 17, 2014 at 7:30 am
It really depends on how and where those 70 columns are coming from. You say it's a query to a linked server, are you joining a bunch of other tables,...
"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 17, 2014 at 7:29 am
You're taking out locks on both queueitem and handrule. It could be that the differences in order between those locks and the ones needed by the index rebuild could 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
February 17, 2014 at 7:26 am
You can disable logins. As far as a certain amount of time, I don't think there's a disable for a time period, but you could set up two jobs, 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
February 17, 2014 at 3:51 am
And for anyone who searches up your question in the future and wants to know how you solved it, what was 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 17, 2014 at 3:49 am
No. You shouldn't hit any performance hits while doing it, but, the bigger concern for me is that between setting it to single user mode and continuing on with 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 16, 2014 at 9:29 am
The details are going to vary for your environment, but here's roughly how we used to do it:
1. Get a copy of the production backup
2. Restore it to a test...
"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 16, 2014 at 9:27 am
It means you have more than one BEGIN statement and only one COMMIT or END statements. You need to have matching pairs for the query to work correctly.
"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 15, 2014 at 4:13 am
TheGreenShepherd (2/14/2014)
"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 15, 2014 at 4:08 am
Viewing 15 posts - 8,896 through 8,910 (of 22,224 total)