If you see a need to go to CU8 for RTM, that would match R2 SP1 + CU1 for SP1.

I would prefer to just go to SP1 at this...

Ninja's_RGR'us (7/26/2011)

---

Good or bad surprised? What and how did you trace the...

See what happens when you rise the cost threshold for parallisme and be surprised, like I was.

Maybe check out the replies by Grant on another thread can get you started:

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

I did Grant wrong with this mentioning to read his reply :blush:

I'm sorry Grant :crying:

I should have...

Ah, partitioning involved .... Can you use Sliding window technique to offload ?

Problem will then be the data no longer resides in the partitioned table, pro = you can build...

removed duplicate :blink:

No. Not without removing the readonly state.

ALTER DATABASE [SSCTest] MODIFY FILEGROUP [FGUserData] READONLY ;

-- The filegroup property 'READONLY' has been set.

alter database SSCTest

MODIFY FILE ( NAME = SSCTest_Data2, FILENAME...

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit of...

As always it depends.

IMO best is to create a full database backup and restore that to your new sqlinstance.

You'll need to migrate the users yourself (sqlusers / windows groups or...

I wouldn't advise such approach, just because of the reasons mentioned by the previous replies.

Best is to have an alike approach on _all_ your instances so anyone helping out doesn't...

is/are the user accounts you tested actual database owner and is such database offline ?

Keep in mind MASTER may not be master :crazy:

What's the collation of the instance?

can you post @@version info ?

-- this may help to figure out the issue.

EXEC master..xp_logininfo @acctname =...

Can you also elaborate on the indexes and the stats for which you noticed the auto update ?

(ddl / stats columns ?)

hmm ... 08:30 ... now that really would be a coincidence, wouldn't it.

Are you sure that hasn't been an sp_updatestats or so that got launched (e.g. using sqlagent) ?

Did you...

Jeff Moden (7/23/2011)

---

....

My personal recommendation would be to use "Closed/Open" where the StartDateTime is inclusive and the EndDateTime is the first non-inclusive date. That way you can avoid the...