You may want to check out the white paper for your upgrades.

Also some SQL 2008 R2 upgradfe info here, courtesy of Arron Bertrand. Some good points raised.

qh

I have created a VM Win2008R2 Ent server, with esxi however it keeps on requiring the activation key. I have read I need to install VMWare tools so it...

One of those I added to the Briefcase for reading later on.

So, two years later on, great article. 😀

qh

Can you get blocking in Access? Or doesn't one user stop all others...

One quick answer would be to create a load of VMs and do the testing from there, however if your prod instance(s) are physical there's a chance the results could...

Nice article Dave, one for the briefcase.

Given my current client you may find some of the replication errors I am facing quite familiar. 😉

qh

DennisPost (8/6/2014)

---

Go to SQLServerCentral.com/forums (Skip Google)

Post the question

Bump every 10 mins...

Koen Verbeeck (8/5/2014)

---

Deadlock is when two processes have acquired locks on two different object and before they can move on they need access to each others resources. They lock each...

Have some more. 😀

One thing I've noticed in 99.999% of the...

Yep, been there many times. Thankfully there are Eval/Developer/Express editions.

qh

Possibly for many Devs/DBAs/etc the phrase "Test & Check-In" is more apt (ie Source/Version Control).

You'd be surprised...

aochss (8/1/2014)

---

All,

A little off topic. A lot of the posts reference a CV instead of a resume. I assume the CV stands for curriculum vitae.

I...

Nice article, brought back memories of going to Uni in the mid 90's to study Computing yet knowing nothing of DOS and Windows (I was expected to learn this...

TEST-TEST-TEST!!! 😀

(Sorry for obvious-post-of-the-week, but OP did not mention if he had any test or Pre-prod systems/instances)

qh

You will need to perform a baseline on those four tables to find out how often they are updated. Without knowing what version of SQL Server you have, you could...