If reporting, or tracking/trending then denormalized is supposed to be the best bet for performance.

If an application like and Order Fullfilment system then it is poor and each insert may...

Yes, that field would more logically read Creator or Author rather than Owner. Has no relationship to how you login to SQL Server just how you are logged into the...

Because you could. Ordinal position does apparently access faster than Column Name becuase ADO had to find the column based name versus being told exactly where to look. Even thou there...

Yes, you will have to build a report to format the layout like you want but if you have access to the RS Console go into an existing report and...

My understanding had nothing to do with * being better with performance it was in case of change the impact it may have.

Example I use * on my audit triggers...

No there are no issues at all. You can even setup email delivery, and store historical snapshots in case you need to retrieve any past runs.

Or to save your brain a lot of work if you have Reporting Services installed you can get RS to do this much easier for you thru Subscriptions. I have...

It increases slightly mostly because of the messages produced by

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

themselves. Looks like it adds a little more than a mintue to each run.

Also...

That is an option as well I just found with ours the Deleted column gave better performance on these items plus I had them available for recovery for that just...

And if you have a lot of space but not equal keep in mind these backups can be compressed easily. You can setup a compressed folder and store the backups...

Who if you look is the series editor on the T-SQL Querying and Programming books metioned. I like Kalen's stuff and Ken's but there are lot's of books out there,...

Been a while but I believe you have to have File and Print Sharing on before the install will work. Can't remember if this was the message thou.

Do spluge for the highest L1/L2 cache (on-chip) you can get. But depending on how old your quad singles are there are plenty of other factors that will mean better...

Yes but you have to be carefull of bulk inserts and such. As well your log file will be a big issue as it grows and has to be retained...

You have to be carefull with sp_removedbreplication as tat remove is from the database on and does not remove the refernce to subscriptions and publications in the ditributions database. You...