Normalization in SQL on October 31, 2011 1NF 2NF 3NF Form +0 Normalization 1NF 2NF 3NF Form Normalization
SQL WITH (NO LOCK) Statements on October 31, 2011 faster query LOCK sql query + with no lock faster query LOCK sql query with no lock
Important Questions on SQL Server on October 24, 2011 2nd Highest Salary Delete Duplicate Records Imp Query + SQL 2nd Highest Salary Delete Duplicate Records Imp Query SQL
SQL Transaction and Indexes on October 24, 2011 Clustured Commit Index Non clustured Rollback + SQL Transaction Clustured Commit Index Non clustured Rollback SQL Transaction
Know SQL CURSOR on October 23, 2011 Create Curosr DECLARE Cursor SQL Commands + SQL Cursor Create Curosr DECLARE Cursor SQL Commands SQL Cursor