Hyperthreading off on the 20 cpu one?

That's as good as I can offer in that department. !

Same physical machine?

What SP are you on? This was a bug in the RTM version of 2008.

Did you try with OPTION RECOMPILE? That should be enough to use...

Basically, take a schema lock and bump the schema version.

Build a copy of the index. Keep it in sync with the dml in the base table.

Once done swap in...

Wow, I need to find myself a busy bank...

ssc.com

http://www.sqlservercentral.com/Forums/FindPost1176448.aspx

Type this in google => site:sqlservercentral.com lowell html mail

Hit google to search this site. Lowelll posted his sample a few times.

I'd start with, is there more code here?

1 sec for this is extreme.

- Lawn mower

- Shovel Snow

- Dishwasher

- Bus Boy

- Cook (so to say)

- Garbage man for big objects

- Rubber plant to make the rubber isolation for cars & trucks.

- Back to...

Or someone else should if the first one is not available for any reason whatsoever.

Anyone knows this? Permissions to read sql log files?

http://www.sqlservercentral.com/Forums/Topic1205472-1550-1.aspx

+1

This SHOULD be done app side unless you have absolutely no front end that can do it for you.

I've just coded something like this and it's a effing PITA. ...

Hi, I'd like to upgrade from Coach.

Sir, that's insane.



I know!

20 000, 20K!

Evil Kraig F (11/14/2011)

---

Sean Lange (11/14/2011)

---

And a good reminder that we can all use a refresher on from time to time.

As others have said, let me know if I cross...

SSRS + subscriptions could work if you have enterprise.

If not send an html e-mail and use code to calculate the correct headers for the code and you'll be 100% on...