ORACLE AND MSSQLSERVER

What are CUBE & ROLLUP in T-SQL? CUBE & ROLLUP are the grouping sets used in conjunction with GROUP BY clause to generate summarized aggregations. These are mainly used for Report Generation and Data Audits

What are types of XML indexes in SQL Server? Microsoft SQL Server supports different types of XML indexes. An XML index is different than a relational index. There are basically TWO types of XML Indexes viz., Primary XML Indexes and Secondary XML indexes....

What are limitations of IDENTITY Column? IDENTITY column can be used as a surrogate key. This column values cannot be updated once generated (automatically or manually). As we have possibility to duplicate these values within a table we may require to...

How you can load large data in SQL Server? IMPORT and EXPORT Wizard, BULK INSERT and BCP are the possible options. We need to set the RECOVERY MODEL to BULKLOGGED before we perform such activities.

When to use COALESCE() & ISNULL() Functions? The NULLability of result expression is different for ISNULL and COALESCE. ISNULL return value is always considered NOT NULLable (assuming the return value is a non-nullable one) whereas COALESCE is not. So...

What are Dynamic Queries in T-SQL? Dynamic T-SQL Queries are those queries designed on the fly / at run time using Variables or using CTE or other sources. We use SP_EXECUTESQL Stored Procedure or EXECUTE function to execute such queries.

What is Left Anti Semi Join Operator? The Left Anti Semi Join operator returns the result set for each row from the first (top) input when there is no matching row in the second (bottom) input. If no join predicate exists in the Argument column, each...

What are Editions of SQL Server 2012 OS System requirements depend on the Version and Edition you are using. Enterprise and Datacenter Editions require Windows Server 2003 SP2 or Windows Server 2008 for complete features support. Core Server Editions...

What is an alias? When you want to give a short name or different name to a table its called alias and you can use that alias on behalf of table name or can use with column name in where clause or join clause etc.

SQL ORDER BY Clause ORDER BY clause is used to sort the data in ascending or descending order, in SQL Server bydefault data will not be inserted in any order even if you have an index. Syntax: SELECT expressions FROM tables WHERE conditions ORDER BY expression...