My worst conversion/import was from a database using a couple generic tables; most other tables were defined as data in the generic tables. This metadata style design had to...

Sql Server will always write to the log for the current transactions, otherwise it would not be a sql database. This is the foundation of a transactional database implementing...

Wow, lots of work to try to programatically figure out keys!

Thank heavens other companies don't use any constraints or unique indexes or normalization; they eventually provide customers to me.

Having done...

Excellent links! As I suspected, fragmentation does result in several more levels in the index tree that must be navigated. Also, I think my co-worker can get more...

Yes you will see a great improvement in performance by specifying UNIQUE for a CLUSTERED index. Back in sql 6.5 I saw a 4X improvement. Not sure if...

I think the OP should go with a calendar table. I did take it 90% of the way to show him how to manipulate dates. His implementation will...

DECLARE @days TABLE (dt date not null primary key);

DECLARE @dt date;

SET @dt = '20160101';

WHILE @dt < '20170101'

BEGIN

INSERT into @days VALUES (@dt);

SET @dt = DATEADD(DAY,1,@dt);

END

SELECT DATEPART(MONTH,dt) MonthNbr, DATEPART(week,dt) WeekNbr, MIN(dt) MinDT,...

Prediction is really hard, especially about the future!

I tried to explain customers will adapt and change how they use the app on a daily basis. Watching monthly growth trends...

I release my app to many different customers and each uses it differently; some attach huge files to each transaction while others don't. Doing a calculation on each table's...

Two disk channels is twice the pipes! If you're writing mostly to an SSD, you're idle on the second pipe.

I only run logs on SSDs since nothing gets changed...

If a database consists of mostly binary attachments, do not compress it when backing it up; it will take twice as long and you won't save any space.

To find out...

I've never experienced dropping two objects when trying to drop one.

My guess is that using something like the sp_MSforeachtable stored procedure would drop all matching objects if you don't specify...

I also use version numbering to control which script gets run next. To allow any script to run in any order would be pure insanity (a utopia that will...

In early versions of sql server one could think of the database as a container for tables and other objects. I'm guessing that changed with sql 2005 or 2008...

I could be wrong but I'm pretty sure there is no nesting of schemas...so there is no such thing as a sub-schema. And I think setting a default schema...