What is a trigger and types of a trigger?
What do you understand by triggers?
how can u get last observation in an unknown dataset ?
What are the types of indexes?
What is resource governor?
How to get the query of a table in sql server?
What are distributed partitioned views?
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
What is the difference between dbcc indexdefrag and dbcc reindex?
Define DML and DCL statements?
How to check if stored procedure is running in sql server?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is msdb database? : SQL Server Architecture