Viewing 15 posts - 13,321 through 13,335 (of 39,898 total)
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...
August 20, 2012 at 7:23 am
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...
August 18, 2012 at 12:43 pm
StephenNL (8/18/2012)
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...
August 18, 2012 at 12:28 pm
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.
August 18, 2012 at 12:26 pm
GilaMonster (8/18/2012)
Do the restore WITH NORECOVERY. The only options allowed when upgrading are WITH RECOVERY or WITH NORECOVERY.
+1
Whether using script or the GUI, use norecovery.
You can bring the databases online...
August 18, 2012 at 12:25 pm
Make sure you copy and don't move the files. Easy to make this mistake and have things fail.
Right click, drag, and copy.
August 18, 2012 at 12:24 pm
Sean Lange (8/17/2012)
Reminds me of a joke.
Do you know the difference between an optimist and a pessimist?
Experience. 😛
Unfortunately it's not a joke often enough. Too often we find...
August 17, 2012 at 12:09 pm
I would agree with the above statement, grow it yourself. I tend to grow for 3-4 months, maybe 6, but check it regularly. 12GB is small, so you could do...
August 17, 2012 at 10:34 am
Lynn Pettis (8/16/2012)
Discipline in writing good code doesn't come from the language, it comes from having the proper training and mentoring. I am sure that there are C &...
August 16, 2012 at 10:23 am
sturner (8/16/2012)
August 16, 2012 at 10:18 am
Alex Gay (8/16/2012)
I wouldn't...
August 16, 2012 at 10:17 am
Mike Austin-398977 (8/15/2012)
By your reasoning, all of us should be required to take a course in transmission repair before we're allowed to drive a car.
Not quite a good...
August 16, 2012 at 10:05 am
BlackHawk-17 (8/15/2012)
Steve Jones - SSC Editor (8/15/2012)[hrWhy? Once the instance is up and running, the service account is almost never needed? What's the administrative overhead?
If there is separation of duties...
August 16, 2012 at 10:02 am
Adam Seniuk (8/10/2012)
I like the idea but managing a service account for every server is a nightmare for my environments.
Why? Once the instance is up and running, the service...
August 15, 2012 at 6:44 pm
Mike Palecek (8/10/2012)
August 15, 2012 at 6:43 pm
Viewing 15 posts - 13,321 through 13,335 (of 39,898 total)