Hugo Kornelis (1/26/2015)

---

Raghavendra Mudugal (1/26/2015)

---

Thank you for the post, Steve, very interesting one.

Row filters in transactional publications can add significant overhead because the article filter clause is evaluated for each...

Thank you for the post, Steve, interesting one.

That "*" actually made me easier to select the correct choice. I used the below statement to understand the data and confirm that...

Thank you for the post, Steve, very interesting one.

Row filters in transactional publications can add significant overhead because the article filter clause is evaluated for each log row written for...

Thank you for the post, Steve, very good one. It was (EP)Z;

Thank you Steve, good one. Anyway, I selected NO.

But the trick or catch here is;

1. If those two queries are executed "only" considering the given data inserted into the table,...

Thank you for the post, Steve, nice one.

matthew.flower (1/20/2015)

---

The explanation script is definitely wrong - it defines the columns as being numeric(17,0) i.e. 17 digits long and then tries to insert a 19 digit number, which obviously...

Thank you for the post, Steve, good one.

(From the previous qtod on identity column and its datatype, i was sure that last choice was right,but somehow i ended up selecting...

Thank you Carlo, very good and interesting one.

(I actually do the same thing when data-fixing in the PROD, so it was easy for me to select proper choices except for...

Ed Wagner (1/16/2015)

---

I'm not sure he sleeps. ;-)...

Thank you for the post, good one.

(I knew in SQL2012, it is 15K; so I was "assuming" that it might be same in 2014 too and also at the same...

Thank you for the post, Carlo, good one.

(I tried this scenario in the previous qtod on the same subject and was sure..:cool:)

Thank you for the post, Steve, good one.

Generally Saying...

After recreating the table with ANSI_DEFAULTS OFF, when tried to insert the records, you will see the below...

Thank for the post, Steve, interesting one.

(Well, the score is exact 50-50 at this moment; the most common data type for identity column is INT, I am sure or trying...