NP, did it solve your problem??

Post the url here if you make a new thread for...

Just a guess... have you tried try... catch?

I'm guessin ghere because the error might be too severe to catch there. It also requires sql 2005 and this is a...

@SQLFRNDZ (8/1/2011)

---

GSquared (8/1/2011)

---

Regularly shrinking the database files is usually just a good way to slow the whole server down. It causes file fragmentation, locks during auto-growth, and a host...

John H Davis (8/1/2011)

---

GilaMonster (8/1/2011)

---

No its not, but SQL still has to track the run-time information through each one. The plans for the functions are still generated, they don't get...

Thank Jason, I...

Glad this is getting better.

Want to post the actual execution plan so we can get this under 1 sec? 8 sec for so little data seems really slow to...

No more details available unless I literally do it for you.

What have you tried in the last few hours and where are you getting stuck?

Depends on the command you use, but if you use update stats <table name> with full scan (or what ever sampling) they will be updated. AFAIK this will even...

It always depends on the system, but since you're just starting out it's a better plan to just leave...

You can add a new column either in the dataset or the query with a case statement and then use that to group on.

Sounds like the...

Reallllllly old broken down laptop or the new monster you just bought?

... pickup up my jaw off the floor and heading home 😉

Do you see the same behavior when running profiler with Showplan XML with stats profile?

GilaMonster (8/1/2011)

---

Yes, it does cause a query to run longer. To return an actual execution plan, SQL has to track things during query execution that it doesn't normally track. I've...

How / when did you update the stats?

If you ran sp_updatsats then it's possible that it skipped that table because it wasn't necessary to do the update

If you...