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...

afaik, updates will only work if you target a single tables columns.

Workaround ?

Prepare your action

Perform the update targeting single tables

If you need that in transaction scope, just use begin...

SQL2005 std comes as well in 32 bit as 64 bit.

std vs ent edtn,... have a look at

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

Best thing to do at this moment is to post both execution plan.

In SSMS activate 'show actual execution plan' in your query toolbar.

Then execute the query.

Select the execution plan tab,...