how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
1112what is the system function to get the current user's user id? : Sql server database administration
1071what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
1059what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
1032what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
998explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
1004tell me what is blocking and how would you troubleshoot it? : Sql server database administration
944what are constraints? Explain different types of constraints? : Sql server database administration
1049tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
1072
What are the database objects? : SQL Server Architecture
How to add the custom code in Report?
When is the use of update_statistics command?
How do I find query history in sql server?
Which is faster statement or preparedstatement?
how you can list all the tables in a database?
What will be the maximum number of index per table?
How to find tables without indexes?
What is the difference between join and inner join?
Explain different types of locks in sql server.
What is user-defined inline table-valued function?
how we use window authentication connection with sql server.?
what is a deadlock? : Sql server database administration
What are the methods used to protect against sql injection attack?
What is the beast way to write CTE in SQL Server ?