Viewing 15 posts - 8,851 through 8,865 (of 22,219 total)
The one suggestion I can offer to cut the time is to just do a statistics update, not an index rebuild. You actually don't even have to do that. 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 25, 2014 at 4:51 am
Those type of questions are intentionally asked by good interviewers to test the depths of your knowledge. The first question is one of my favorites. I want to know what...
"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 25, 2014 at 4:47 am
To move only a sub-set of the data you'll have to build a manual process. SSIS is the obvious choice, but you could use straight T-SQL, PowerShell or any other...
"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 25, 2014 at 4:43 am
Lynn Pettis (2/25/2014)
Last night home. Start my journey back to Afghanistan Tuesday morning.
Best of luck!
"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 25, 2014 at 4:34 am
Just remember that those are suggestions. Don't blindly implement them. Always test them and validate 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
February 25, 2014 at 4:34 am
In terms of guidance, the detailed answer is to get my 2012 book on query tuning. The more general answer is to capture the wait statistics before and after 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
February 24, 2014 at 3:11 pm
Without seeing the code, the structure, the error messages, something other than vague descriptions, I'm hard pressed to suggest something meaningful. The nature of the problem, works fine with 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 24, 2014 at 4:10 am
If you're talking about Central Management Server, you can register the 2000 machines from the central machine, but you can't join the CMS from the 2000 machines.
"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 24, 2014 at 4:06 am
You can restore through the GUI or through T-SQL commands, but you'll have to get everything set correctly. If there are 10 data files that define this database, you need...
"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 22, 2014 at 3:07 am
yeah, the hardest part about row level security is that all access must go through a common path in order for it to work. As soon as you open up...
"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 21, 2014 at 9:55 am
Yes, you can break down the process, and probably should. But telling you how based on nothing other than "the process is big" is pretty hard.
"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 21, 2014 at 9:48 am
You sure can. Microsoft has good documentation on it here and here.
"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 21, 2014 at 4:41 am
SQL Injection
It's not a good thing. You are absolutely making it possible with that code. Please stop and tell all your friends.
"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 21, 2014 at 4:38 am
I'd say the current setup is OK. If anything, I wouldn't go with lots of full backups because you do pay for that with load on the system. Plus, as...
"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 21, 2014 at 4:31 am
No way in the world, at all, to avoid the log, so best practice is to find ways to deal with it. No other choice there. If you don't need...
"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 20, 2014 at 6:48 pm
Viewing 15 posts - 8,851 through 8,865 (of 22,219 total)