Viewing 15 posts - 2,986 through 3,000 (of 9,725 total)
You also need to be careful if you are inserting into a column that already has the identity property set. Check out the SET IDENTITY_INSERT statement in Books Online.
But if...
January 13, 2015 at 6:32 am
Wow. I haven't posted to The Thread since last year... Anyway, hello again everyone.
Me updates... I'm hoping to convince my bosses to pay for PASS this year since I...
January 13, 2015 at 6:17 am
Lynn Pettis (1/12/2015)
Brandie Tarvin (1/12/2015)
Lynn Pettis (1/12/2015)
January 12, 2015 at 11:24 am
The Redneck DBA (1/12/2015)
Brandie Tarvin (1/12/2015)
January 12, 2015 at 11:17 am
Lynn Pettis (1/12/2015)
January 12, 2015 at 10:48 am
And the verdict is in. It was the mirroring after all. Specifically, it was synchronous mode. When I set it to asnychronous, it only took 2 and 1/2 hours to...
January 12, 2015 at 9:07 am
GilaMonster (1/12/2015)
When you have synchronous mirroring, the minimum duration for a transaction...
January 12, 2015 at 6:52 am
george sibbald (1/12/2015)
Brandie, just to confirm, you have enterprise edition to enable the use of asynchronous? If you can tolerate some data loss, would log-shipping be an alternative?
No. We cannot...
January 12, 2015 at 6:42 am
GilaMonster (1/12/2015)
No.
Thank you, Gail.
January 12, 2015 at 6:08 am
I can find all sorts of references about switching the safety mode in the GUI, but I only found one reference to using t-sql and it refers to the PARTNER...
January 12, 2015 at 5:38 am
Ah, I forgot about that little part of it. And of course the person who set it up did set it up as synchronous instead of asynchronous.
This is going to...
January 12, 2015 at 5:25 am
Jeff Moden (1/9/2015)
Brandie Tarvin (1/9/2015)
I've been through 5 managers...BWAAAA-HAAAAA-HAAAA!!!! You must be tough on managers! :-D:-P
My original manager moved to a different team. Then I was handed off to...
January 9, 2015 at 12:53 pm
It depends on the permissions being added, I suppose.
I use AD groups too, then add them to fixed database roles for the most part. But if you are using...
January 9, 2015 at 12:47 pm
Chris Wooding (1/9/2015)
January 9, 2015 at 12:35 pm
Greg Edwards-268690 (12/19/2014)
jasona.work (12/19/2014)
Brandie Tarvin (12/19/2014)
So basically instead of creating multiple physical processors like memory makers create sticks of RAM, some...
December 19, 2014 at 7:15 am
Viewing 15 posts - 2,986 through 3,000 (of 9,725 total)