{ Published : June 28, 2018 // Post an Awesome Comment }
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 }
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 }
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 }
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 }
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