ALTER TABLE [onetable] SWITCH TO [anothertable] There are many challenges with gigantic tables and modifying their schema is one of those that could make many operational DBAs cry. I had to go through a schema change where I have to make data type and identity changes to one of the largest transactional table in the … Continue reading “Switch” Huge Non Partitioned Tables in Seconds
I am going to put together a list of command line interface (CLI) commands that has helped me over the years in troubleshooting SQL Server virtual/physical machines, especially when we bring in a new SQL VMs in our existing environment and want to make sure that it works and connected to every necessary part of … Continue reading 5 CLI Commands, Sr DBA should know!
Up until now, I had never written a blog and never, if I’m honest, had the desire to put myself out. For me, blogs were time consuming hobby which being a database guy I could never afford due to late night works and always disturbed weekend routines, I although, always felt that I had always … Continue reading Something anything