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...

SQL GROUP BY Clause The GROUP BY clause is used to summarize data based on grouping criteria. For each group one column is returned in result set. Syntax SELECT expression1, expression2, … expressionN, aggregate function (aggregate expression) FROM Table...

SQL IN Operator You can specify multiple values with IN operator and it will return matching values from WHERE clause of a table. IN operator matches values in a list or subquery and returns the output. Syntax SELECT column1, column2,… columnN FROM TableName...

SQL AND & OR Operators SQL AND operator is used to filter the records by combining two boolean expressions and returns true when both boolean expressions are true whereas SQL OR operator returns true value when either the first condition or the second...