What should be the fill factor for indexes created on tables? : sql server database administration
1184What is the meaning of lock escalation and why/how to stop this? : sql server database administration
1084What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
1082What are the difference between primary key and unique key? : sql server database administration
994Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
1104How will you monitor replication latency in transactional replication? : sql server replication
1213
What are different types of join?
How to get all stored procedures in sql server?
How would you choose between a clustered and a non-clustered index?
What is primary key and example?
Explain about nested stored procedure?
What is a primary index?
What is trigger explain with program?
What is temporary table in sql server? Why we use temp table?
Explain about system database?
What is a result set object returned by odbc_exec()?
what authentication modes does sql server support? : Sql server database administration
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is page in sql server?
Write a SQL query to delete a table?
How to rename an existing column with sql server management studio?