What should be the fill factor for indexes created on tables? : sql server database administration
1138What is the meaning of lock escalation and why/how to stop this? : sql server database administration
1037What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
1015What are the difference between primary key and unique key? : sql server database administration
941Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
1043How will you monitor replication latency in transactional replication? : sql server replication
1143
What are the components of dbms?
Explain primary key and foreign key constraints?
What is the largest component inside a field?
Are resultset updatable?
Do you know what are the steps to process a single select statement?
How to create stored procedures with parameters in ms sql server?
What is create command?
Can a table be moved to different filegroup?
Will sql server 2005 allow you to reduce the size of a column?
What is filtered index?
What is indexing in sql server with example?
What is inner join in sql server joins?
What is cursors?
How to enter date and time literals in ms sql server?
What does set rowcount do?