File Recovery

How to Copy the Schemas & Statistics of Multiple Databases without Data via TSQL

With the service pack 2 of SQL Server 2014, you can create a copy of a user database without the actual data. i.e., you would be creating just the schema and statistics of your source database. In this article, we will learn how to quickly create clone of multiple user databases A copy needed for investigation: To find the root cause of a performance problem, you might need a copy of your existing database. In such cases, you can use the following query to create copies of multiple SQL Server...

Read more »

A Comparative Analysis of Using MS Access for Data Analysis over MS Excel

This article provides a comparative analysis of Using MS Access for Data Analysis over MS Excel. MS Access and Excel are often compared because of their similar pronunciation and usage. Both these Microsoft applications are used majorly for storing particular type of data; however, Access is a database management software, whereas Excel is a spreadsheet based software which offers extended data analysis tools to the users.  Access is obviously better for managing and storing tons of...

Read more »

What to Do on Stuck “Repairing disk errors” Issue in Windows 10?

As the latest Windows system, Windows 10 does offer many excellent surprises. But it also brings out several problems, such as stuck "Repairing disk errors. This might take over an hour to complete” on booting. If you are facing this issue, you can refer to this article to get rid of it. Aside from “Scanning and repairing drive” issue that has introduced in my article – "6 Solutions to Stuck “Scanning and repairing drive” Issue in Windows 10", lots of users also complained a lot...

Read more »