In case someone tries to imagine the horror of running queries against hundreds...

Jeff Moden (11/6/2007)

---

Come on, David... you just got done complaining about all of the extra terabytes of space it takes for covering indexes, yet you have the room for "careful...

I think I see the confusion. That article isn't a highly specific article about the objects called "documenting keys", it's a very broad article about migrating from one version of...

By the way, this back and forth over the use of "Over()" is kind of silly, when there are a ton of things I like about SQL Server 2005, that...

Jeff Moden (11/6/2007)

---

Yup... and what's really great about it is that the managers that used to wait hours for reports can now get them in just a couple of minutes.[/QUOTE]

We...

Jeff Moden (11/5/2007)

---

Because, in the presence of the index, which is also a part of T-SQL and optimization, the Inner Join is more than twice as fast as the Over....

That's pretty funny. Not even close to true, but funny.

Um, in case you're not aware, the two statements say basically the same thing. If by "liar",...

Sergiy (11/5/2007)

---

David, what did you prove?[/QUOTE]

That you were wrong. No big deal, as I've done it before, and I'll do it again (based on your "maths" skills, probably sooner rather...

Why don't you link to the article so we can see what it is you are talking about?

"Document key" being comprised of a pk and fk sounds either like something...

While they appear to do the same thing on the surface, they are two completely different beasts, and it could take pages to outline every single nuance. They don't even...

Keep in mind that while Carl's answers are correct, both terms are used in ambiguous manners quite frequently in the SQL world, especially "work table".

I've seen people refer to tables...

I was away for a while, but finally had a chance to log on, so time to clear up some misconceptions that seem to be out there.

Jeff Moden (10/22/2007)[

---

Ya know......

Sergiy (10/22/2007)

---

You are the one who pointed that it was Clustered Index Scan, not Table Scan as I said.[/QUOTE]

No, I pointed out that it was one, 1, uno, einz, a...

Jeff Moden (10/22/2007)Funny thing, though... to me (I could be wrong), if you want shear speed without much thought about tuning, it looks like the Inner Join is the winner...

What would you like to know? If you would like some help on...