Thought as much 🙁

Thanks Gila

Perry Whittle (1/27/2014)

---

bugg (1/27/2014)

---

Thanks Perry.

Last question , the mirroring is set up in Safe Mode with no witness so if I pause mirroring will the principal still be able...

Thanks Perry.

Last question , the mirroring is set up in Safe Mode with no witness so if I pause mirroring will the principal still be able have read and...

I know this an old thread but I'm going to exactly what has been described here.

My question is though if I have logs backing up ever 20-30 mins or so...

twin.devil (12/31/2013)

---

this would not hurt only if this store procedure is executed independently. if you are using this store procedure in side a store procedure then it could hurt u.

its...

http://sqlblog.com/blogs/linchi_shea/archive/2007/10/05/performance-impact-the-potential-cost-of-read-committed-snapshot.aspx

Also with rollback immediate option this will rollback any open transactions before starting which I definitely wont do.

These are comments by Kendra from Brent Ozar's site, which make me twitchy...

Thanks for the input guys.

I think i will introduce READPAST on 1 or 2 of the queries and run them in parallel with the existing ones and see what...

I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime soon.

Also I...

Hi Barry

Thanks for that list, this is going to be a one off job to migrate some data, so still toying with using SQLCLR to do this.

Cheers

D

Thanks Barry, thats pretty awesome. Is there anywhere I can a full list of characters its not just Greek specific.

D

Bhuvnesh (10/17/2013)

---

One thing i can say here is .. it will be protective approach.

create a new column with new...

Lynn Pettis (10/17/2013)

---

bugg (10/17/2013)

---

Lynn Pettis (10/17/2013)

---

Not sure, but this may just be a metadata change to the column. Looking at the numeric data type since your precision is not changing,...

Lynn Pettis (10/17/2013)

---

Not sure, but this may just be a metadata change to the column. Looking at the numeric data type since your precision is not changing, the number of...

Cool 🙂

Will that work between 2 different versions of SQL?