If you are used to working with Excel, you know that all you need is IFERROR() function to avoid any issues with dividing by 0. Also adding a blank to a number is not creating any issues in Excel. In SQL, however, its not that straight forward, you need to remember to differentiate between ISNULL()…
Category: SQL
SQL DB too large? Here is how to shrink it
Once in a while, SQL database and log files get cluttered with data that you don’t need that occupy your hard drive space. If you are in that situation and are running low on disc space, you need to periodically clean your log files and shrink your database There are few ways to do it,…