GSquared (8/14/2012)

---

You're not disagreeing with me. You're disagreeing with the original article we're discussing. All I did was quote/reference that. Please note the sentence I emphasized in...

sjerromeharris (8/16/2012)

---

I have been asked to provide another report very similar to the one above. Its on the same table so the structure is the same.

Whereas the first report...

GSquared (8/14/2012)

---

call.copse (8/14/2012)

---

GSquared (8/13/2012)

---

And even then, on simple queries, it has to assume no underlying database object will be changed without also recompiling, redeploying, etc., the code that accesses it.

If...

L' Eomot Inversé (8/14/2012)

---

Jeff Moden (8/13/2012)

---

Lynn Pettis (8/13/2012)

---

Jeff Moden (8/13/2012)

---

I consider CustomerID's and EmployeeID's that are generated simply by the likes of an IDENTITY column, to be a surrogate key...

Lowell (7/16/2012)

---

Brandie Tarvin (7/16/2012)

---

I thought that was Bird...

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

Might I humbly recommend including the actual execution plans from each? That would immediately tell where the problem lies.

mgee1038 (6/29/2012)

---

I need to use a value returned from a function in a where clause.

I get the code to compile ok but it runs forever.

Will you please look at this...

You might want to look at the final number in your string. It looks like your closing quote mark is in the wrong place. If that isn't the...

Hugo Kornelis (6/14/2012)

---

venoym (6/14/2012)

---

All of that above being said, The only thing I might be able to recommend is to add or alter the line to mention the possibility of...

Hugo Kornelis (6/14/2012)

---

venoym (6/14/2012)Then we are assuming that the author didn't intend to test us the default of the Primary Key?

From the description, emphasis mine. If you want a...

GilaMonster (6/14/2012)

---

The whole point of...

ronmoses (6/14/2012)

---

L' Eomot Inversé (6/14/2012)

---

Most of those errors were the same wrong answer, there appears to a widely distributed myth that any primary index is clustered unless it is declared...

Stefan Krzywicki (5/30/2012)

---

Revenant (5/30/2012)

---

Not quite --...

dwain.c (5/23/2012)

---

GilaMonster (5/23/2012)

---

dwain.c (5/22/2012)

---

Stefan Krzywicki (5/22/2012)

---

Many should format it all at...