Temporary tables in SQL Server
Indexes in sql server
Clustered and non-clustered indexes in sql server
Unique and Non Unique Indexes in sql server
Advantages and disadvantages of indexes in sql server
Views in sql server
Updatable views in sql server
Indexed views in sql server
View limitations in sql server
DML triggers in sql server
After update trigger in SQL Server
Instead of insert trigger
Instead of update triggers in sql server
Instead of delete triggers in sql server
Derived tables and common table expressions in sql server
CTE in SQL server
Updatable common table expressions in sql server
Recursive CTE in sql server
Error handling in sql server 2000
Transactions in sql server
Transactions in sql server and ACID Tests
Database normalization
Pivot in sql server 2008
Subqueries in sql
Correlated subquery in sql server
What to choose for performance SubQuery or Joins in SQL Server
Cursors in sql server
Replacing cursors using joins in sql server
List all tables in a sql server database using a query
Writing re runnable sql server scripts
Alter database table columns without dropping table in SQL server
Optional parameters in sql server stored procedures
Note: Optional parameters are very useful when we come across above scenarios in our application
Blogger Labels: Server,Interview,concepts,Part,Temporary,Indexes,Unique,Advantages,disadvantages,Views,Updatable,View,limitations,Instead,Recursive,Error,Transactions,ACID,Tests,Database,normalization,Pivot,Subqueries,performance,SubQuery,Joins,Cursors,List,scripts,Alter,columns,Optional,parameters,procedures,Note,scenarios
No comments:
Post a Comment