Viewing 15 posts - 15,061 through 15,075 (of 22,219 total)
It's hard to say why you'd see to plans on the same machine, but I'd have to assume it probably had something to do with statistics or possibly ANSI settings...
"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
May 10, 2010 at 12:32 pm
Robert Frasca (5/10/2010)
Grant Fritchey (5/10/2010)
GilaMonster (5/10/2010)
I'm probably not going to get a chance to look at this, got a lot of work this week. Maybe Grant feels like a challenge.
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
May 10, 2010 at 8:07 am
GilaMonster (5/10/2010)
You need skilled people, not titles, to get the job done.
Here, 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
May 10, 2010 at 7:56 am
GilaMonster (5/10/2010)
I'm probably not going to get a chance to look at this, got a lot of work this week. Maybe Grant feels like a challenge.
I don't have access 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
May 10, 2010 at 7:53 am
Abrar Ahmad_ (5/10/2010)
Grant Fritchey (5/10/2010)
Sorry, but there is no rule or formula that can be derived here. There are too many variables.
Fine, but what my past experience suggests me 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
May 10, 2010 at 7:16 am
MeltonDBA (5/10/2010)
WOW!!! They actually have Interview questions too:w00t:Something new to reply to post for those looking for SQL interview questions.
Or the next time someone asks for interview answers so they...
"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
May 10, 2010 at 6:57 am
Sorry, I'm not going to be decisive. There are way too many shades of gray between having a full-fledged dedicated set of full-time database developers, and simply having some vague...
"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
May 10, 2010 at 6:49 am
OK. That was really weird. I think that was serious. Or if it was meant to be funny, it was really sad.
"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
May 10, 2010 at 6:44 am
And in 2005/2008, it's pretty easy to see the changes from the default trace. In Management Studio, right click on the server name, in Object Explorer, and select, Reports, Standard...
"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
May 10, 2010 at 6:43 am
I'd say a basic backup and recovery plan should cover you well. Schedule a full backup on a regular basis. Most of our db's are less than 100gb, so we...
"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
May 10, 2010 at 6:37 am
You'll get a much better response on new questions if you post them to the group at large. The only respondants you'll see here are those that are already subscribing...
"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
May 10, 2010 at 6:02 am
avanch-990710 (5/7/2010)
--Object reference not set 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
May 7, 2010 at 12:31 pm
There is no hard and fast formula as in "You MUST use it here, you MAY NOT use it there." It's a case by case basis.
However, one general rule 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
May 7, 2010 at 9:25 am
jacroberts (5/7/2010)
Grant Fritchey (5/7/2010)
"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
May 7, 2010 at 8:59 am
Nadrek (5/7/2010)
Are the backups sharing any of the same spindles (EMC Raidgroups) as 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
May 7, 2010 at 8:58 am
Viewing 15 posts - 15,061 through 15,075 (of 22,219 total)