Tag Info

New answers tagged

0

I did something very similar, but not as a single script. I used migrations. I also described this in Version Control and your Database. And indeed, every step is a different script, and the application drives the upgrade (the migration). Every step is tested. Every change is an upgrade, be it DDL or DML, it matters not. There are DML changes like changing ...


0

Why are you looking for the best performing option but refuse to use a trigger? How do you plan to detect a "failed" status that is followed by a "success" status before the insert is verified? (Polling against a heavily used table just every 20sec and evaluating the latest insert only sounds a little odd...) I'd prefer an after insert trigger that would ...


0

CREATE TABLE TableA (TransactionID int, Time_stamp datetime, Status char(10)) GO --Create a non-clustered covering index --If `clustered index` already exists on `TransactionID` column than no need to add it to INCLUDE part CREATE NONCLUSTERED INDEX [IX_TableA_Time_stamp] ON [dbo].[TableA] ( [Time_stamp] ...



Top 50 recent answers are included