Table of Contents

[BEST VIEWABLE IN GOOGLE CHROME]

Basic SQL Server Fundamentals

Normalization

Stored Procedures

View

Trigger

Cursor

Functions

Data type

Column

Constraints

Advanced SQL Server Fundamentals

Transaction

Index
Isolation Level

Full Text Search

Error Handling
Table Partitioning

Information_Schema

Performance, Maintenance & Administration

Performance Improvement

Backup

System Objects

DBCC

New Features of SQL Server 2005

SQL CLR

CTE (Common Table Expression)

TRY-CATCH

PIVOT and UNPIVOT

DMV (Dynamic Management View)

Database Snapshot

New functions (ROW_NUMBER, RANK, DENES_RANK)

New operands (INTERSECT, EXCEPT)

New Clause (OUTPUT, TABLESTAMP)

New DataType (XML)

New Tool (Data Tuning Advisor)

New Features of SQL Server 2008

Intellisense

CDC

Policy Based Management

Filtered Index

New DataType (HIERARCHYID, DATE)

Query Editor Regions

Table Valued Parameters

Filestream

New Features of SQL Server 2012

Sequence

Offset & Fetch

Miscellaneous

Delete Vs Truncate

Tricky Questions

T-SQL Queries

Loading Excel into 64-bit machine 

Connect SQL Server as administrator but not sysadmin

Business Intelligence

SSIS - overview & interview questions