LOL!

The DateAdd Year part gets you the first day of the delivery year. If you subtract 1900 from the year, and add that to 1/1/1900, you get 1 Jan...

Since I don't have an...

Okay. I couldn't stop myself. Had to try it.

create table dbo.[Table] (

[Identity] int identity primary key,

[Column] varchar(100),

[*] int,

constraint [ForeignKey] foreign key ([*]) references dbo.[Table]([Identity]));

go

create index [Index] on dbo.[Table]([Column])

include...

Maybe I have the volume on my speakers turned down to far, but I haven't noticed anyone's avatars making any noises at all... (cuz I'm a blonde, yeah yeah yeah!)...

Do an online search for "SARGABLE" with regard to indexes and where clauses. There are some very good articles on the subject. I believe the coalesce will prevent...

Are there FKs that connect those tables? It seems like the delete might cause those to come into play, if they are there.

I can't tell from your post whether you have a question on what I wrote, or whether you're just making a general statement.

Horizontal partition is applicable for rows. ...

The frequency and all that will depend on your backup and recovery needs.

So long as your full backups are going onto tape or something of that sort, overwriting the old...

I wouldn't use a DDL trigger for this. I'd have a backup job that looks for what databases I have and backs them up. Set it up once...

Steve, we're actually agreeing on all points.

Judging by the price/capacity curve on SSDs over the last 10 years, I think viability for SMBs is probably 2-3 years off as a...

Option should definitely exist. Is it possible you don't have the necessary security rights to access it?

What edition of SQL Server are you using? Express? Standard? Enterprise? Workgroup?

I'm sure this technology will continue to evolve, and eventually we'll have 1TB sized flash memory drives that live in our servers, and possibly even laptops or phones. That's quite...