Viewing 15 posts - 15,061 through 15,075 (of 22,227 total)
Jeff Moden (5/10/2010)
dbowlin (5/10/2010)
The more tools you have in your toolbelt the better off you will be.
There is such a thing as carrying too many tools on your "toolbelt" 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
May 11, 2010 at 5:37 am
Several of those queries are loading data into temporary tables and then loading the same data into permanent tables. Why? Can't they just run the query to move the data...
"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 11, 2010 at 5:36 am
ankur.hooda (5/11/2010)
For backup and recovery stratergy,
Consider following
1) how heavily are your db updated--> helps to decide log file size
2) size of db
3)how much db size increase on daily --->basis helps...
"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 11, 2010 at 5:33 am
I'd dive in, but Gail's done a better job of keeping things clear than I would have.
The original post sounds like an issue around parameter sniffing and your issue sounds...
"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 11, 2010 at 5:29 am
kastros.george (5/10/2010)
option keepplan
or somthing like that
i think the problem is that sql server tries to generate an execution plan, aby trying to estimate row size and row count
Use...
"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:54 pm
It's hard to know for sure, but I'd check the default ANSI settings on your connections. If they're different that could affect how that procedure is processed.
My next guess...
"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:53 pm
I would suggest you get the execution plan for the query and take a look at it. You're probably getting a table/clustered index scan, or possibly and index scan, instead...
"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:49 pm
What you described is blocking. Deadlocks occur when two processes attempt to generate locks on resources that the other process has locks on, usually in opposite order, so session_id =1...
"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:36 pm
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
Viewing 15 posts - 15,061 through 15,075 (of 22,227 total)