There are several books authored by Itzik Ben-Gan that are exceptionally good:

SQL Server 2008 T-SQL Fundamentals

Inside SQL Server 2008 T-SQL Querying

One of his SQL Server 2012 books is available now:

SQL...

the phrase "dub dub dub" is horrible...simply horrible.

Using "loose" instead of lose is lame too, but not as bad as dub dub dub.

What is the probability that a CEO who requires final approval of any travel booked in less than seven days, is not micro-managing in other ways?

My SO is working...

So sorry...I don't post much so am not sure where or why the text is dropping out. Here's a section with no formatting:

[definition of schema elements]

schema element :

table definition

view definition

domain...

let's see if this works:

schema element :

drop schema statement (p520)

Here is the link to Andy Warren's review of the first version of the book:

SQL Server 2000 Database Design

http://www.sqlservercentral.com/articles/Book+Reviews/reviewsqlserver2000databasedesign/370/

I was taught that a view is a virtual table...

There are three phases to database design:

Conceptual

Logical

Physical implementation

Conceptual and Logical design do not involve a specific RDBMS. A specific RDBMS has to be involved in physical implementation unless it's...

A friend used to serve poptarts to her family in the morning. She called it breakfast but I was sure she was joking, so I joined in the joke and...

The Head First series by O'Reilly is good. The books use a lot of visuals (not screen shots) and variability in presenting information. Granted, I slid into IT through the...

I am "home grown" ... some college, no degree, eight years working with SQL servers, 12 years in IT. I've gone back to school to finish my degree for these...

I have Sql Server 2000 Database Design by Louis Davidson, which is outstanding. He's upgraded it with several other authors:

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1195228530&sr=8-1

Brandie's job sounds like mine, sans the Access database upsizing [which I think would would enjoy].

We're upsizing our production sql servers to sql 2005 during this fiscal year, so...

I'm not at all surprised by the stories about Sprint's customer service. It's particularly ironic that Sprint unilaterally chose to end service with customers, when the penalties if customers decide...

Sometimes I feel guilty about it...but the margarita smooths the guilt.

Leslie

I walk down to the beach and look at the sun setting on the Pacific Ocean, order a pizza or some shrimp burritos, and then play a few hours of...