Viewing 15 posts - 15,046 through 15,060 (of 22,211 total)
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...
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...
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...
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...
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...
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...
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...
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...
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...
May 10, 2010 at 8:07 am
GilaMonster (5/10/2010)
You need skilled people, not titles, to get the job done.
Here, here!
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...
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...
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...
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...
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.
May 10, 2010 at 6:44 am
Viewing 15 posts - 15,046 through 15,060 (of 22,211 total)