**Dimension is a term in data management and data warehousing that refers to logical groupings of data such as geographical location, customer information, or product information.** **Slowly Changing Dimensions (SCDs) are dimensions that have data t...

**What are partitions and why use them?** To improve the scalability and manageability of large tables and tables that have varying access patterns. Typically, you create tables to store information about an entity, such as customers or sales, and ea...

**What is a Data Collector?** *The data collector is a component of SQL Server that collects different sets of data. Data collection either runs constantly or on a user-defined schedule. The data collector stores ...

SQL Server Quiz 2012 - Interview Questions - Recently I was contacted by one of my friends operating a large database that he was running out of Yogesh Kamble Answered 1 Years ago through Quizzes | 5 Points ***First we will discuss about Problem..*** When an extent is allocated to a table (or index, etc) it belongs to that table until you o drop the table o truncate the table When you delete t... SQL Server Quiz 2012 - Interview Questions - Using datetime functions inside SQL Server have always been a struggle and there are multiple option Yogesh Kamble Answered 1 Years ago through Quizzes | 5 Points **SYSDATETIME** *Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. SYSDATETIME is a nondeterministic function. Views and expressions that reference this function in a column ... SQL Server Quiz 2012 - Interview Questions - As part of performance tuning exercise our developer always suggested to use SET based operations Yogesh Kamble Answered 1 Years ago through Quizzes | 5 Points Common Table Expressions (CTE) SQL Server Quiz 2012 - Interview Questions - Every time when developer attempts to update the TableA the table is not updated but instead TableB Yogesh Kamble Answered 1 Years ago through Quizzes | 5 Points **Type of Triggers** - DML - DDL - Logon triggers Following is explanation about trigger types. * Types of DML Triggers * --------------------- *You can program the following types of DML Triggers:* **AFTER Triggers** AFTER t... Previous 1 | 2 | 3 | 4 Next Managed Windows Shared Hosting by OrcsWeb Copyright © Rivera Informatic Private Ltd.