SQL SERVER – Line Number in SQL Server Management Studio(SSMS)
When we run a script in SQL Server we may face...
Varun R
SQL SERVER – How to find which SQL Server Version/Edition you are using?
You can use SELECT @@Version to find the...
Varun R
SQL SERVER – DISABLE/ENABLE ALL TRIGGERS IN A DATABASE
Recently I came across a situation to disable all...
Varun R
Database Performance Tuning –Basic Things to know
This feature is dedicated to Preethy kammath a...
Varun R
SQL SERVER – RESTORE VERIFYONLY – TO CHECK WHETHER DATABASE BACKUP CORRUPT OR NOT
Today is April 1st Fool’s day So today I am...
Varun R
SQL SERVER – BEWARE OF USING PREFIX “SP_” IN USER DEFINED STORED PROCEDURE
During the Analysis of a database, I found some...
Varun R