Thank you Ravi-ji, Interesting one. 🙂

(Though I selected the wrong answer, assuming that bulk import is on huge data and dropping indexes will improve the import process... and was considering...

Lynn Pettis (9/10/2012)

Just a note, I try to write all my code as if the database was case sensitive. If a table is named ZipCode, then that is how...

Hugo Kornelis (9/10/2012)

---

Raghavendra Mudugal (9/10/2012)

---

Hugo Kornelis (9/10/2012)

---

Good question - though I am waiting for the first person to claim that "error, error" should also be considered correct because they executed...

Hugo Kornelis (9/10/2012)

---

Good question - though I am waiting for the first person to claim that "error, error" should also be considered correct because they executed the code on a...

Simply Nice. 🙂

(as the either way the implicit conversion is allowed, it will work if the data in the col is numbers, but one of the row contains the chars...

+1

Awesome. 🙂 thank you Kenneth.

1. it will insert 1 record - FROM INSERT INTO

2. it will insert 1 record - But the count in table is 2 - from INSERT..SELECT

3....

Thank you, Bitbucket. This question is very nice.

Initially I picked 6 and then changed to 5, thinking of the S in A has 6 unique value and then R in...

Yes, from the previous post it has been proved that...

L' Eomot Inversé (9/5/2012)

---

Nice question.

Raghavendra Mudugal (9/5/2012)

---

same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I...

Thank you. Nice.

(same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between...

Awesome, good question, thank you. 🙂

Good question. Thank you.

I has selected "simple talk..." before but I had a doubt and made a quick search in my email for the words and selected the 3 opt...

Thank you Lokesh-ji, Nice question.

(So simple and yet it keeps us thinking..., to be honest I selected E,E and then seeing 2nd one's datatype as varchar, but the ISDATE...

Good question, thank you Lokesh-ji.

Initially I checked the cb-3 box where it stores the poor query details - considering the trace tables from the server-wide catalog tables, but later I...