Grant Fritchey (11/30/2012)

---

And the indexes have to be selective enough to be useful for a seek or you'll get scans. Same things apply to non-clustered indexes too.

For lots more detail...

rwm972 (11/30/2012)

---

Hi All,

I'm trying to bulk insert a pipe-delimited file with <CR><LF> as a row terminator. The problem is some fields may contain <CR><LF>. So, I've asked the client to...

Eugene Elutin (11/30/2012)

---

I am not be surprised when good skilled T-SQLers come up with stupid answers on paper...

Jeff Moden (11/30/2012)

---

ScottPletcher (11/30/2012)

---

Jeff Moden (11/29/2012)

---

That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single query". It's...

The middle one. You're listing all the actual scores each...

(Deleted, duplicate)

Eugene Elutin (11/30/2012)

---

Looks a bit illogical to me...

I can see why...

PiMané (11/30/2012)

---

ScottPletcher (11/29/2012)

---

PiMané (11/29/2012)

---

ScottPletcher (11/29/2012)

---

When you create the nonclustered index on c2, explicitly specify c1 as a key after that.

Then define the FK on (c2, c1) and you should be...

Jeff Moden (11/29/2012)

---

That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single query". It's sometimes amazing what...

PiMané (11/29/2012)

---

if the...

FYI, I think you can touch-up the original function to get rid of the variable and the COUNT(DISTINCT):

alter function AreEqual (@t as GenericTable readonly)

returns bit

as

begin

return (

select...

I use this q as extra credit for my students when I teach a SQL class.

It came up in real life.

This is not for an initial...

No. SQL does not normally track that a row has changed.

SQL will add columns that might be used to determine that when you specify certain things for a...

When you create the nonclustered index on c2, explicitly specify c1 as a key after that.

Then define the FK on (c2, c1) and you should be covered.

You've got potential for serious issues on tempdb and log files especially::

Tempdb should never be RAID6 because of its high write activity. Btw, same for log drives, for the...