What are functions3 7029
how to get the automatic backup of the database in the sql server4 32177
Which command using Query Analyzer will give you the version of SQL server and operating system?3 12607
What is the STUFF function and how does it differ from the REPLACE function?2 17637
What is the purpose of UPDATE STATISTICS?2 10470
What is de-normalization and when do you do it?3 5780
Explain some DBCC commands?6 14872
What is the purpose of using COLLATE in a query?1 16698
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is the maximum size of sql server database?
Tell me what is difference between view and materialized view?
What is data modification?
what is the difference between Tabular and Matrix report?
What is database replication? What are the different types of replication you can set up in sql server?
Explain boyce and codd normal form(bcnf)?
How do users use Report Builder with SQL Server data sources?
What is user-defined scalar function?
What are the different types of cursor?
Is the log file is a part of file group?
How can you swap values between two rows in a table using single- SQL statement?
What are the advantages of passing name-value pairs as parameters?
Tell me in brief how sql server enhances scalability of the database system?
How do I find query history in sql server?