Viewing 15 posts - 8,851 through 8,865 (of 22,224 total)
OldCursor (2/25/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 25, 2014 at 6:41 am
Nice article.
A couple of notes. You state that the plan is read from right to left. That's not completely true. The logical processing order of the plan is from left...
"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 6:39 am
That vendor needs to be burned at the stake.
And then we'll scatter the ashes at a cross-roads.
And then sow the ground with salt.
Although, I've seen scarier stuff generated by ORM...
"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:58 am
You have to restore with RECOVERY at the end of the log process too.
Looking at that, are they running a single log backup? Normally you'll see lots of log backups...
"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:55 am
Then you're stuck. You're trying to compare two different data types. SQL Server has to convert them in order to compare them. No choice there. To get index use assured,...
"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:52 am
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
Viewing 15 posts - 8,851 through 8,865 (of 22,224 total)