SQL Tip – An alternative way to page results

SQL Tip – An alternative way to page results

An alternative way to page results using OFFSET AND FETCH. Database used in this example is Adventure Works for SQL Server 2014. You can download the database here. This stored procedure will return paged results from the HumanResources.Employee table. This stored...
Windows 7, Fix Read-Only Drive.

Windows 7, Fix Read-Only Drive.

A couple of week ago I had an issue with the secondary drive on my local workstation. The whole drive all of a sudden was set to read-only. I’m not exactly sure how it happened. It could be due to a group policy or Windows update. I Googled and suggestions are: Take...