What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are the two modes of authentication in sql server?
What is live lock and deadlock? what is Lock escalation?
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
What is the difference between referencing and joining?
What is the default fill factor value?
What is stretch database in sql server?
How to find tables without indexes?
What is the difference between for auto and for nested?
What is a trigger? Why we need it?
Find top Nth employee from each department in terms of salary?
How to find the list of fixed hard drive and free space on server?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .