Category Archives: SQL Server

– if you want to bring in 12th month of a million rows, you could create table beside 1-11th month then index it then ‘merge’ it into the 1-11th month using partition and no import needed, its immediate – table … Continue reading →

Options: Shows all instances and gives you a change to even rename the default:   Oh Boy: Turns out this is simply a bad username password….  

Patch night caused an ugly hard restart on the server. Things looked OK on startup, after a brief time of being in recovery mode. But for some reason it had some issues with RedGate Compare. Acting on this odd piece … Continue reading →