Viewing 15 posts - 13,336 through 13,350 (of 39,919 total)
Probably a more efficient way, but this is the idea:
; WITH MyCTE (acc_no, c_name, cnt)
AS
( SELECT acc_no
, c_name
...
August 20, 2012 at 7:50 am
You can use SQLCompare to do this. Limit the filters to indexes.
August 20, 2012 at 7:37 am
GSquared (8/20/2012)
There's always a trade-off between convenience of use and security, and "the cloud" swings heavily towards the "super duper hyper convenient" end of that spectrum.
Yep, and it's unfortunate that...
August 20, 2012 at 7:37 am
Doctor Who 2 (8/20/2012)
August 20, 2012 at 7:34 am
Jeff Stratford (8/20/2012)
August 20, 2012 at 7:32 am
Raoul Bastendorff (8/20/2012)
Ah Steve... You have not looked at any other European countries. You may find that some are even more generous. And some companies even add more to that.
I...
August 20, 2012 at 7:31 am
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
Viewing 15 posts - 13,336 through 13,350 (of 39,919 total)