Viewing 15 posts - 11,071 through 11,085 (of 22,224 total)
That's a weak question. I'd want to know what the interviewer meant by that, whether they were looking for error levels or what? They must have something particular in mind.
"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
April 19, 2012 at 3:30 am
GilaMonster (4/18/2012)
DataAnalyst110 (4/18/2012)
if not exists (select * from master.dbo.syslogins where loginname = N'GalacticReporting')
BEGIN
declare @logindb nvarchar(132), @loginlang nvarchar(132)...
"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
April 18, 2012 at 8:46 am
george sibbald (4/18/2012)
but it basically reinforced the 'only reorganise at low fragmentation' advice generally given?
Basically, but it was largely that the benefits were so small at various data ranges (he...
"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
April 18, 2012 at 8:36 am
george sibbald (4/18/2012)
Grant Fritchey (4/18/2012)
"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
April 18, 2012 at 8:25 am
I don't think those are standard terms. I suspect they are either in-house terms or terms for a specific product.
"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
April 18, 2012 at 8:07 am
I would be very careful about using reorganize as a mechanism for performance enhancements. I've seen tests run by Brad McGehee and it's only of marginal use within a very...
"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
April 18, 2012 at 7:46 am
Informational, bad ones, and really bad ones.
Can you narrow down what it is that you're looking for? There are all sorts of possible errors, so knowing more about what 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
April 18, 2012 at 7:39 am
Your best bet is write a script that will do all the databases. You can use sp_foreachdb, which is just a cursor, to run a command on all databases.
Alternatively, 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
April 18, 2012 at 6:27 am
I'd get a look at the execution plan. If the query is against millions of rows without an index, likely it's creating a hash table in order to do 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
April 18, 2012 at 6:24 am
WayneS (4/16/2012)
Brandie Tarvin (4/16/2012)
1) What does sp_kleenex do and...
"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
April 17, 2012 at 4:34 am
Thanks to both. Glad to hear it's useful.
"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
April 17, 2012 at 4:29 am
Jeff Moden (4/13/2012)
capn.hector (4/13/2012)
"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
April 14, 2012 at 5:32 am
zojan (4/13/2012)
Sean Lange (4/13/2012)
jzoran (4/13/2012)
"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
April 14, 2012 at 5:27 am
Evil Kraig F (4/12/2012)
Koen Verbeeck (4/12/2012)
GilaMonster (4/12/2012)
"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
April 13, 2012 at 10:19 am
pallavi.unde (4/12/2012)
Can you please tell me what query execution plan does actually to help us in performance tuning? How it could i use?
Execution plans show you the decisions made...
"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
April 13, 2012 at 10:18 am
Viewing 15 posts - 11,071 through 11,085 (of 22,224 total)