How can you append an identity column to a temporary table?
Do you know what are the properties of the relational tables?
What is lock escalation?
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
What do mean by xml datatype?
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are the advantages of using views. Why do we need views when we have SPs?
What will happen if a column containing char type data is changed to the nchar data type?
How to generate create table script on an existing table in ms sql server?
What is sql server database?
What are various ways to enhance the ssrs report?