{ Published : June 28, 2018 // Post an Awesome Comment }
How to Get Size of All Tables in SQL Server
Sometime there is simple solution to a complex problem. Few days ago, I have to find each database table sizes (disk space used by every table) and number of rows for database optimization purpose. When we think about such kind of problem, we may think that could be difficult to find disk space...
Read More
{ Published : October 26, 2017 // Post an Awesome Comment }
During Data migration process I have to restore or drop databases. Sometime I face an error “SQL Server Cannot drop database <dbname> It is currently in use“. Few days ago, I faced the same problem. As you know,  It’s very expensive to restart SQL Services to kill database...
Read More
{ Published : October 25, 2017 // Post an Awesome Comment }
Last night, I was trying to publish a post “Drop Multiple Tables with Common Prefix (SQL Server)“. I faced 403 Forbidden error, every time I pressed Publish button. I tried to publish blank post but failed. I tried to update old post but same error occurred. I faced this error after...
Read More
{ Published : October 25, 2017 // Post an Awesome Comment }
Drop Multiple Tables with Common Prefix (SQL Server)
Few days ago, I was working on huge database and I have to remove 80+ database tables with prefix “Temp_” (tables were created during data migration process). After few minutes of working, I came across the best solution. I found a query  which drops database tables with given prefix...
Read More
{ Published : October 13, 2012 // Post an Awesome Comment }
How to Search on Google Efficiently
There are a lot of websites on the internet having very good and poor material. What happens when you got a problem and search for solution on google, some irrelevant search results comes and wasted your time. Here is some tips to search on google efficiently.  Boolean Whenever you search on...
Read More
{ Published : March 01, 2012 // Post an Awesome Comment }
Set up Windows based Web Server at Home in 5 mins
Want to Know How to Set up Windows based Web Server at Home in 5 mins?? Just Watch this...
Read More
{ Published : February 18, 2012 // Post an Awesome Comment }
How to Set Up Your Own Windows based Web Server at home
The Requirements to Set Up Web Server at Home are followingPC with Windows installed in it and any Web server installed (IIS, Apache etc) DSL connection with Modem/RouterRunning your own web server is easier than you may think and its cost effective way for you or your company to establish a...
Read More