Tips, tricks, best practices & knowledge
When we have the db backup of a large (or small) sql db, in the form a of a script file, it is not possible to restore the db using the SMMS (Sql Server Management Studio). It shows there is Read More
We may come across the situations that to send mails from SQL server automatically or manually in-order to retrieve some status or information. For that we can setup the database mailing feature of sql and all through sql query itself. Read More
For any High volume db operated websites that contains millions of data, that also in binary formats too, it’s common that the transaction log files (.ldf files) will grow at an incredible rate without our notice and at some stage Read More