Category Archives: SQL Tips

Articles for SQL tips

Learn How to Recover Deleted Records from SQL Server 2014

Problem Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a lot of issues. To maintain the workflow they need to … Continue reading

Posted in DBA, SQL Tips | Tagged , | 31 Comments

Two Ways to Restore Database from MDF File in SQL Server

Ways to Restore Database from MDF File Introduction In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best and successful RDBMS … Continue reading

Posted in DBA, SQL Database Restoration, SQL Tips | 31 Comments

SQL Script to find all the triggers defined on a database or on a single table

SQL Script to find triggers in SQL Database Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] , trig.name as [Trigger Name] … Continue reading

Posted in SQL Advanced, SQL Tips, SQL Triggers | Tagged , | 30 Comments

Script to find the complete weeks within two given dates

Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script, I have used below dates … Continue reading

Posted in Interview Questions, SQL Basic, SQL Server, SQL Tips | Tagged , | 21 Comments

My Best Technical Sites and Blogs

Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the list of tech sites which I used to refer most of the times for learning technologies and finding the solutions … Continue reading

Posted in Miscellaneous, SQL Server, SQL Tips | Tagged | 6 Comments