Deleting Files using SQL CLR
Written by: Mr.ML
I don’t know if I mentioned this or not but I have a SQL 2005 instance that has over 260 databases. A few weeks back, I wrote a store procedure to backup all the databases every Sunday. Nothing wrong with the stored procedure except that the entire run time took around 8hours. That’s 8 hours of the system being hammered while users are querying against the database and ongoing bulk insert from some monitoring system that no one seem to have documentation about. Not only that, this is...