Jeff Moden (12/16/2014)

---

Gosh. I can't believe that the Hierarchies On Steroids #1 article made it to the "Bacon" list on the Tribal Awards. I wouldn't mind winning that...

Jeff Moden (12/16/2014)

---

Steve Jones - SSC Editor (12/15/2014)

---

Jeff Moden (12/14/2014)

---

In the category of learning something new, I just did some testing on the differences between ONLINE and OFFLINE index rebuilds...

+1

for any warehouse / reporting...

Eric M Russell (12/16/2014)

---

Eirikur Eiriksson (12/16/2014)

...

There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is not null,...

gkramer 23701 (12/16/2014)

---

SSCrazy,

There is one main database but I'm not sure (yet) of some support databases will come along.

As you are suggesting in your reply - is there a way...

Eric M Russell (12/16/2014)

---

For columns containing a foreign key enforced with a constraint, you have no choice but to not use NULL, because the primary key can't contain a NULL....

Quick question, wouldn't it be enough to change the collation for that single database?

😎

Quick though, laurie-789651's solution is good but given the requirements of

The condition is first SP should check if same SRC is repeating if yes then do dedup on IP_ref...

Quick thought, under normal circumstances if a value can be unknown/undefined/missing then use NULL, as there would be no gain in a replacement value, only complications.

😎

In simple terms the...

Greeted by a waiter when walking into a restaurant, as SQL Server developer asks "Do you have a table". The waiter responds "in 10 minutes". Disappointed the SQL Server developer...

It doesn't create the table, it provides all the information about the result set needed to create the table

😎

Quick suggestion, on SQL Server 2008 and earlier you can use SET FMTONLY, on 2012 and later use sp_describe_first_result_set

😎

Consider this...

Maybe this blog[/url] might help

😎

Doesn't this look like one of out favourite "Kitchen" people (look at the query, db name is OrbeData_KithKitchens):-D

😎