Do you have replication turned on?

Update stats with fullscan if possbile.

If stats are out of data the plan will be wrong (especially for that case).

Could also be parameter sniffing.

Yup, but as soon as you do this then you're screwed.

create table #Temp (t int)

create table #Temp1 (t1 int, fails int)

insert into #Temp values (1)

insert into #Temp1 values (1)

Select *...

GilaMonster (4/16/2011)

---

Yup, that's pretty much what I was thinking about.

Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do what...

Also make sure to have the month number in the dataset so you can sort by that column.

Brandie Tarvin (4/18/2011)

---

Duncan Pryde (4/18/2011)

---

No problem. Let me know if you need...

Use try .... catch.

EXEC xp_cmdshell 'md c:\whatever' --, nooutput --optional

Revenant (4/15/2011)

---

Ninja's_RGR'us (4/12/2011)

---

I love MS & all since I'm earning my living because of them. BUT I work with ms Dynamics Nav and EVERY SINGLE FREAKING USER needs to...

samsql (4/12/2011)

---

Thankz perry but it does not delete the data from all the tables....

Perry will there be any issue if i truncate the tables.... as i dnt have any space...

Just keep in mind that you lose a very valuable piece of information if you clear that history.

I use that to figure out when I'll get autogrowth, when I'll run...

Brandie Tarvin (4/15/2011)

---

Ninja's_RGR'us (4/15/2011)

---

Thanks David, amazing description of what "might" be going on under the covers. Certainly makes a lot of sens and demonstrate how muc work is actually...

Thanks David, amazing description of what "might" be going on under the covers. Certainly makes a lot of sens and demonstrate how much work is actually involved.

That also answer...

Thanks, fortunately they don't.

The code's been...

jremmc (4/14/2011)

---

Great article! (Unfortunately when I tried to rate the article I only got one star highlighted and then the system grabbed it, which is why I usually bypass ratings...