GilaMonster (8/19/2015)

---

Please post the execution plan. A picture doesn't have all the properties needed.

It's worth noting that a scan doesn't have to be the entire table, and that's probably what's...

GilaMonster (8/19/2015)

---

Don't use the Profiler GUI against a production server. It can and will cause problems, up to and including crashing the server (I've done it). Statistics profile is a...

Hi Kevin

thanks for your reply.

I didn't say that though. I said I had corrected the plan so it now does an efficient B-Tree seek on the offending table so it...

SORRY misposted this

Have reposted under SQL 2012 - General

Please reply there

Apologies

Lynn Pettis (3/5/2015)

---

Won't handle the typical "yes, but ..." or "no, but ..." answers you get from kids and politicians when asked a simple question that can be answered with...

Jeff Moden (3/5/2015)

---

Heh... "It...

I have been trying to work out whether this thread is useful to me in a business context.

But is it a straight yes or no?

😉

Good luck!

Best Regards

Tim

I now do this kind of thing quite a lot now. We started using Azure extensively and are now back to managed hosting.

I moved a 30GB database from Azure to...

Neat trick!

Thanks Paul - very useful - 5 stars

Erland, Jeff, your replies are as always much appreciated.

I now have confidence that I know how this all hangs together.

Shame in a way though. Table variables always compile as one...

Thanks for the reply Scott.

I think you are probably right, although I was hoping we we wrong! I'd like to be able to use this construct to return two small...

Mike, Lowell and Ed,

Thanks very much for your feedback. I accidentally unchecked the option to notify me of replies and assumed I hadn't got any!

Your different viewpoints and advice are...

mkolek99 (6/10/2013)

---

They released directCache (http://www.fusionio.com/data-sheets/directcache/) not so long ago. I see a lot of potential for that product given the overall effectiveness of transparent caching for accelerating a...