Date Range
Date Range
Date Range
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.
Monday, July 2, 2012. Best Way to Delete multiple non unique records. DECLARE dublicate cursor CURSOR FAST FORWARD FOR.