Matt Miller (12/19/2008)

---

Grant Fritchey (12/19/2008)

---

jcrawf02 (12/19/2008)

---

My sister-in-law is...

A LAMBIC!!!!!

DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.

Belgians... They get a couple of things right (double, triple, & saison (very right)) and then...

Since we've alredy deviated from movies, I'd also like to add Berserkers. They make Terminators look like wee small girls.

Another reason I dislike the things.

Single line table valued UDF's do resolve out more like views and are part of the execution plan, for what it's worth.

Chris Morris (12/19/2008)

---

Grant Fritchey (12/19/2008)

---

Nothing wrong with both beer and a good scotch. Preferably some incredibly hoppy IPA or ESB and some Scapa.... mmmm... Oh, look at the time. The...

I honestly couldn't tell you. I've installed both to my laptop, also running XP. I've installed 2000, 2005 and 2008 to my desktop with no issues, problems, erorrs, or extra...

jcrawf02 (12/19/2008)

---

My sister-in-law is crazy about that stuff....

Jason Miller (12/19/2008)

---

It was Scotty talking into the mouse of Mac while trying to get transparent aluminum in our times. My first thought was, why not regular aluminum?

The Holodeck?...

Multi-line table valued functions are notorious performance pigs. They have not statistics so anything more than a few rows will perform pretty poorly. For more information, check out Gail's blog:...

If you can't partition, you could try simulating it. Use a view, that you'll need to rebuild regularly, and split the data up into multiple physical tables, seperated by day,...

Or at least post the execution plan.

Assuming you give 2008 a different instance name, no you don't need to uninstall 2005. They run side-by-side just fine. Not that I'd run them side-by-side on a production server.

Do you have traceflag 1222 and/or 1204 enabled? That will output the deadlock graph to the error log when the deadlocks occur. It will specify exactly where the deadlock is...

I think the one thing you're missing is, by and large, you don't need to worry about lock management. SQL Server manages locks for you. You do need to understand...

It really depends on what you mean by "auto"

There is the startup proc, and there can be only one. You can also set up triggers to respond to ddl or...