If you create a new domain account for testing, can you use that and get it to start?

This sounds like it might be some strange permissions error, so I'm looking...

You can set clients to ask for encrypted connections. The server with a cert can allow this, while still allowing unencrypted connections from some clients.

http://msdn.microsoft.com/en-us/library/ms189067%28v=SQL.105%29.aspx

You need a table that localises the words. AFAIK, SQL Server doesn't understand "years" or "ans"

I'd second Grant's note.

You can do some calculations on throughput you're using now, based on counters. You might gain confidence on the IO throughput you need.

However the other issue is...

Probably a more efficient way, but this is the idea:

; WITH MyCTE (acc_no, c_name, cnt)

AS

( SELECT acc_no

, c_name

...

You can use SQLCompare to do this. Limit the filters to indexes.

Yep, and it's unfortunate that...

Doctor Who 2 (8/20/2012)

---

I hear you, Steve, but WOW, this is hard to do. I have almost 200 hours of vacation, but trying to get the time is difficult....

Jeff Stratford (8/20/2012)

---

As yet another Brit. I have in the past not taken holiday leave or virtually any holiday throughout the year due to work pressures. It can almost...

I...

bitbucket-25253 (8/19/2012)

QODs using images instead of easily cut and paste text have now been excluded from being published, I would propose to the powers that be that those submitted QODs...

If you are going to do AlwaysOn, then 5 is the recommended number of machines, but you could get by with 4 (or 4VMs).

You could go to 6 as a...

StephenNL (8/18/2012)

---

Hello,

I have tried Red Gate SQL Compare and SQL Data Compare but without any success.

Also: The DTS "Import data" to a database did not work properly, either.

However should data...

My demo VMs for SQL Server 2008 and SQL Server 2012 are set at 1MB RAM and a 40GB disk.

Works fine. Almost any laptop will run SQL Server dev edition.

+1

Whether using script or the GUI, use norecovery.

You can bring the databases online...