SQL SERVER – RESTORE VERIFYONLY – TO CHECK WHETHER DATABASE BACKUP CORRUPT OR NOT Today is April 1st Fool’s day So today I am... 1 Apr1 Apr Varun R
SQL SERVER – BEWARE OF USING PREFIX “SP_” IN USER DEFINED STORED PROCEDURE During the Analysis of a database, I found some... 31 Mar31 Mar Varun R
SQL SERVER – HOW TO DISABLE SAVING CHANGES NOT PERMITTED In SQL Server 2008 , While you creating a table... 10 Mar10 Mar Varun R
SQL SERVER – RollingBalanceProblem-No Cursors,No loop Yesterday I came across a situation, while... 4 Mar8 Feb Varun R
SQL SERVER – INDEX SEEK AND INDEX SCAN During the examination of SQL Server execution... 17 Feb Varun R