Your statement, " I suspect that you'll end up clustering by client_id anyway to meet the needs of partitioning" is something I need to look in to.  Are you saying...

Hi Scott, thanks for the reply.

I'm almost positive I had my clustered indexes designed as you suggest ages ago, but that was before I realized that, for whatever reason, it...

Database developers would be wise to stop thinking in terms of end users directly accessing data just as .NET developers (or any other high level platform/language)don't assume a user might...

Absolutely....we use INT and sometimes BIGINT.  Who really knows what this maximum big int limit is:  9,223,372,036,854,775,807

I think that's 9.2 Google  🙂

Great point.  We standardize all table names and keys, also.  This helps with joins and other database programming not to mention helping the other guys who are creating applications that...

Not a bad article but no mention of multi-column natural keys?  in my experience, every database I've worked with that uses natural keys ends up with some tables having to...

I began to post the table and index here...but found the culprit.  The query was ran from a stored procedure.  Someone decided to make the proc parameters NVARCHAR while the...

Yeah, I can see that as an argument for multiple files - but also...the more files the better the chance one becomes corrupted.  Considering we do a daily full and...

Thank you for the replies.  I think SSMS used to show a bunch of DIFFs with only the last one checked, but that may have been long ago.  Choosing the...

We load a lot of files to a very large, read-heavy, database.  We create a FULL backup at the time the first file of the day is loaded and then...