Yes, a good one to highlight importance of a second thought.

Thanks!

Mormons

GilaMonster (11/1/2011)

---

Revenant (11/1/2011)

---

jared-709193 (11/1/2011)

---

. . . Isn't it interesting how Microsoft developers can't design an application that effectively uses their own database engine? I would even accept one that followed...

There is no absolute answer to what is "the best." Dropping indexes may speed an INSERT-based load; however, if the load is done by MERGE (for example, to handle...

jared-709193 (11/1/2011)

---

. . . Isn't it interesting how Microsoft developers can't design an application that effectively uses their own database engine? I would even accept one that followed at least...

SalesOrderDetailId makes each row unique.

Can you please explain what are the duplicates you want to eliminate?

Great -- it forced me to re-read collation rules.

Challenge

I have my monk robe ready. I will not get much work done this afternoon, but hey, Halloween is only once a year!

of perfection

Hmm... I blew this one. However, MSDN does not support that "Also, sp_fulltext_database cannot (and should not) be used to enable/disable full-text search."

Cf. description of sp_fulltext_database at http://technet.microsoft.com/en-us/library/cc721269(SQL.100).aspx#_Toc202506258.

Seems funny that...

On apps that contain sensitive enterprise data it common (at least where I am) to have a "DMZ server" ("demilitarized zone") which also acts as a decoy server for the...

SQLRNNR (10/27/2011)

---

Ha - I...

Big Sis, methinks

I like questions that force me to "take a road less traveled." -- thanks!