Category Archives: SQL Scripts

SQL Server Health Check HTML Report

SQL Server Health Check HTML Report is useful to quickly get the performance snapshot of a database instance. After going through the overall system parameters, except the minor issues we can clearly state that the both instances are optimally performing. Index maintenance and the database log file maintenance are the critical activities to be considered. Please make note that the HC report tool is not reporting the SQL code issues and its scope is restricted to the database system level performance. Continue reading

Posted in Performance Tuning, SQL Scripts, SQL Server DBA | Tagged , , , , , | 49 Comments

How to Script Login and User Permissions in SQL Server

How to Script Login and User Permissions in SQL Server Migrating login and user permissions to a new instance is one of the most common tasks for a SQL DBA. This post “How to Script Login and User Permissions in … Continue reading

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , | 46 Comments

Get the Next and Previous Row Value in SQL Server

Get the Next and Previous Row Value in SQL Server This post can help you to get the next and previous row Value in SQL Server using T-SQL. We had a requirement to get the previous row information and compare … Continue reading

Posted in Interview Q&A, SQL Development, SQL Scripts | Tagged , , , , , , , , , , | 2 Comments