Notes on MS SQL Server. A lot of developers are taught to use database stored procedures, triggers and database constraints at every possible opportunity, and they cannot understand why an old dinosaur like me should choose to take an opposite view. Only know what you have been taught, whereas.

Effective Administration and Diagnostics for MS SQL Server. This is the site for utility MSSQLServerAuditor. The purpose of the utility is to make the complete audit of the running MS SQL server and provide the details analysis about the most important aspects of the MS SQL server.

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.