So as a summary to conclude this case for me.

to run through the data it goes between 20 and 30 seconds (maxdop 1 is going abit faster).

i also rewrote the...

result in the attachment

Ninja's_RGR'us (1/4/2012)

---

Marco V (1/4/2012)

---

Dave Ballantyne (1/4/2012)

---

Ninja's_RGR'us (1/4/2012)

---

How would this go in anything less...

Dave Ballantyne (1/4/2012)

---

Ninja's_RGR'us (1/4/2012)

---

How would this go in anything less than 6 minutes...

Oke thanks for the feedback sofar.

Some answers:

Seriously what end user would actually look at 53 M rows??????????????????????????

I have no idea, they run some kind of trend analyse on the...

Hmm cool, i dunno been awhile ago i played arround with it. Correct me if iam wrong but i believed it was SQL 2008 R2 only.

and you could centralise policies...

Evil Kraig F (12/7/2011)

---

matthew.peters (12/7/2011)

---

Here is the query and I have attached the plan. I assumed a like operator required a index scan? Anyway any help would be appreciated, I...

http://blogs.msdn.com/b/qingsongyao/archive/2009/04/10/sql-server-and-utf-8-encoding-1-true-or-false.aspx

check esspecially the first and second comment on the blog

and make sure that account has rights to the folder you backup youre db to

John Mitchell-245523 (12/16/2011)

---

What, even though there were 0 users fixed?...

if you now check the properties of the user on the database it will have his login mapped now

and should be working.

Only SQL logins will be not be mapped to...

EXEC sp_change_users_login 'Auto_Fix', 'user'

Thats correct same here sales could...

abit weird question but i think you are looking for this:

how to create logins:

http://msdn.microsoft.com/en-us/library/ms189751.aspx

how to map logins to a user

http://msdn.microsoft.com/en-us/library/ms174378.aspx

to get an overall idea.

what is the overal size of the database and transaction log?

what are the autogrow values of the files?

what is the free space of the database and...