masoudk1990 (1/13/2015)

---

I know how to copy and paste data from one table to another table with INSERT and SELECT query.

I just want to know is it possible to do this...

ElKapy (1/12/2015)

---

Hello there,

I have a some SSIS-Stored-Packages. Running these jobs via "Run package", works fine, inluding logging.

Running the packages by Job, however, works also fine, except the Logging!

Looking in the...

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...

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...

Lynn Pettis (1/12/2015)

---

Brandie Tarvin (1/12/2015)

---

Lynn Pettis (1/12/2015)

---

Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on...

The Redneck DBA (1/12/2015)

---

Brandie Tarvin (1/12/2015)

---

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...

Lynn Pettis (1/12/2015)

---

Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on the clustered index? ...

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...

GilaMonster (1/12/2015)

---

There could also be some effects from the write latency if the log file on the mirror is slow.

When you have synchronous mirroring, the minimum duration for a transaction...

No. We cannot...

Thank you, Gail.

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...

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...

My original manager moved to a different team. Then I was handed off to...

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...