What are the types of user defined functions in sql server?
What is live lock and deadlock? what is Lock escalation?
Is truncate autocommit?
Does the unique constraint create an index?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Describe in brief system database.
What is compression - row-level and page-level compression?
Explain some stored procedure creating best practices or guidelines?
Explain Different types of Projects?
How the authentication mode can be changed?
What is the beast way to write CTE in SQL Server ?
What is the difference between resultset and resultsetmetadata?