Wednesday, 18 January 2012. Explain PRIMARY KEY constraint in SQL Server. Is used to uniquely identify the records in a table. It should not contain NULL values. Each table should have a PRIMARY KEY. Each table can have only one PRIMARY KEY. Supplier ID int NOT NULL PRIMARY KEY,. This Query creates PRIMARY KEY on the Supplier ID column in suppliers table.

Tuesday, April 21, 2009. What is Difference between ER Modeling and Dimensional Modeling? What is Difference between ER Modeling and Dimensional Modeling? This Question was asked in Sql Server Interview Question and Answers. Differences between star and snowflake schema? Differences between star and snowflake schema? This Question was asked in Sql Server Interview Question and Answers. What Snow Flake Schema? What Snow Flake Schema? What is a Star Schema? What is conform.

Monday, July 2, 2012. Best Way to Delete multiple non unique records. DECLARE dublicate cursor CURSOR FAST FORWARD FOR.

With Tool That Created its Own Identity in. Download MS SQL Server Recovery Tool. MS SQL Server is Important For Managing Organization Database. Recover MS SQL Server Database After Severe Corruption. Get Experience of MS SQL Server Database Recovery. Updated Features of SQL Recovery Tool. Speed to repair corrupt MDF file has improved to a high extent. MDF database in bulk did not take more than few minutes in recovery.

Master your setup, master yourself. Thursday, January 10, 2013. Non-set-based operations, usually T-SQL cursors. Poor execution plans, usually caused by parameter sniffing. Frequent recompilation of execution plans. Improper configuration of the database log. Excessive use or improper configuration of tempdb. Thursday, April 26, 2012. Recovering SQL Server Database From Suspect Mode.