evald (12/14/2010)

---

GilaMonster (12/14/2010)

This is clearly documented. From Books Online:

When ORDER BY is used in the definition of a view, inline function, derived table, or subquery, the clause is used only...

Makes sense.

This actually begs the question of why the number of columns in a table is so volatile that this matters in the first place.

In most cases, the properties of an...

Yep.

110 people? Have you tried having IT create an e-mail group? Or have you thought about posting data to an RSS feed?

Yes, the...

Use "select *" if you really want all the columns.

The second method is clever (but could do with some improvements), but "clever" and "should be used in a production environment"...

A missing image file? Not sure that "frighten" is the right word for that...

mishaluba (12/14/2010)

---

Thank you for the responses, but I was thinking more along the lines of slowly-chaning dimension, rather then audit/logging. In one of the earlier comments Jeff Storm showed...

How'd you end up with the task? Are you the DBA, or did you just get suckered with the usual, "you're good with computers, you figure it out", kind...

Stefan Krzywicki (12/14/2010)

---

WayneS (12/14/2010)

---

Stefan Krzywicki (12/14/2010)

---

Wow. I was having problems with an older query taking too long, so I made what I thought was a little switch to begin making...

I'm also not sure how "Order By" would apply to a delete statement, unless you are deleting "delete top 10 from MyTable order by MyDateColumn" or something like that.

Deletes are...

Brandie Tarvin (12/14/2010)

---

Days like this, I wonder why I even talk to you people. All that gutter-talk coming out of your mouths... My mom would wash all your mouths out...

LutzM (12/14/2010)

---

With an iMat Michael Flatley surely would...

Trust me, I am WAY below the gutter.

Marianas Trench is uphill from where...