I second this post. Not only it is not "wise" to use SSN as the primary key for a table, but it is also not good from the performance,...

Just out of curiosity, what prompted your companies to move up from standard to enterprie edition?

I am trying to convince a major client (3000+ users, very data-intensive business)...

I get this problem all the time. Have no idea what the cause is, but once I generate a SELECT code for the table and cut and paste the...

Michael,

Is there any particular reason why you opt to use nchar/nvarchar and datetime data types?

Does your data allow to use char/varchar/smalldatetime instead? If yes, you can easily reduce the...