There are specific data types that don't work in keys, such as bits, text, and image, and the approximate numerics: float and real.

One thing that's cool to play with is...

It's amazing (and sad and disgusting!) how many problems a server reboot can fix. We rarely can say "this is what's wrong and this is how to fix it",...

Carl Federl (5/27/2008)

---

A few other suggested books are:

SQL for Smarties: Advanced SQL Programming

Author: Joe Celko

Publisher: Morgan Kaufmann Publishers

ISBN-13: 978-0123693792

http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/0123693799

The Data Modeling Handbook : A Best-Practice Approach to Building...

Yep, got Itzik's book on the list. I'm not too sure about the Celko's, though. I appreciate him from a theoretical level, but I think since my programmers...

Thanks, I came across his first book on Amazon while working on my list and added it. I'll look up the second and it'll probably also get added.

It's kind...

James Stover (5/23/2008)

---

If I had a dollar for every time I've heard the phrase "skills shortage"....

This is what they say: "We can't find any qualified applicants."

This is what I hear:...

Interesting problem, I look forward to hearing what your systems peoples find to resolve it.

Sorry that no one has replied to your message, maybe you got caught by the American holiday weekend.

There should be no problem having a varchar and int as your primary...

Ratpick (5/21/2008)

---

...My question is, how ofter should one changes jobs. I don't want to be changing jobs every year or two, but there is always a new challenge when changing...

Roaming profiles aren't bad if your user base is static, i.e. they stay at one computer most of the time, which is pretty much the norm for most sites. ...

If your network uses roaming profiles, you could easily exceed 400M in one profile. I had problems with this at a previous employer, some people would take forever to...

Knut Boehnert (5/16/2008)

---

...Then right now I am in a code heap documentation from someone else. While consistent the readability leaves much to ask for. It looks like the code was...

Once upon a time I had two copies of a wonderful book: The Complete Guide to Australian Profanity and Vulgarity. Wonderful...

If you look at how...

I think theft of backups or servers is the bigger risk (Peter Gabriel's web server was stolen from his ISP recently, who knows what was on it and lost), corruption...