Paul White NZ (11/5/2010)

---

Wouldn't it be nice if MSFT put a bit more effort into their replies on Connect?

Just confirming the bug is nice...

Here's a nice WP from SQLCAT that highlights about high availability and mentions the major topics a SLA/DRP should have:

http://sqlcat.com/whitepapers/archive/2010/11/03/failure-is-not-an-option-zero-data-loss-and-high-availability.aspx

I received feedback from MS ....

...

The problem is that we were trying to apply a particular optimization that doesn't work with table variables. The bug has been fixed for the...

HTH 🙂

If you post the new sqlplans (and consumption times), I'm sure we'll take another look.

I cannot find the ref right now, but if I'm correct you should be able to - and must - take control over IO.

This is the critical point that makes...

Can you post the link again ? :blush:

never mind .... i did find it ... 😀 http://pulse.sqlserverpedia.com/awards/

Gianluca Sartori (11/3/2010)

---

I tend to use virtual machines to play with new things. At...

Brandie Tarvin (11/3/2010)

---

Just got me a Dev copy of R2 and am uninstalling the regular 2k8 eval copy from my laptop now. Gonna play, gonna play.

I'm debating on getting...

On most of our servers I use xcopy as a last step of the sqlagent job.

If you have robocopy I've heard it should perform better than xcopy.

next time, if you know this is a restored/attached db, I guess it will be easier to just run:

ALTER USER [username] WITH LOGIN = [loginname]

I use the same procedure sequence as Adiga.

Back in the days, with SQL7 we encountered a files server going offline during a backup, and that caused the server that hosted...

Did you map the user to the correct database ?

I suppose you have more than one userdb.

did you actually refresh the database in the object explorer ?

This is my Monday morning .... actually Tuesday, but yesterday was a holliday 😉

- Unless your db is case sensitive, remove all upper conversions !!

- If it is case sensitive,...

That's a known issue with this view gui.

So, don't use the create view window, but open a Query window, paste your code and type "create view yourschema.yourname as " on...