What are functions3 6824
how to get the automatic backup of the database in the sql server4 32014
Which command using Query Analyzer will give you the version of SQL server and operating system?3 12465
What is the STUFF function and how does it differ from the REPLACE function?2 17470
What is the purpose of UPDATE STATISTICS?2 10366
What is de-normalization and when do you do it?3 5670
Explain some DBCC commands?6 14623
What is the purpose of using COLLATE in a query?1 16600
What is the maximum rows in sql server table?
How to create an index on an existing table in ms sql server?
What are the built in functions in sql server?
What are the drawbacks of reporting in ssrs?
How do you migrate data from mssql server to azure?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Write a code to select distinct records without using the DISTINCT keyword.
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
Can the “if update (colname)” statement be used in a delete trigger?
What is the maximum size per database for sql server express?
how we use window authentication connection with sql server.?
Difference between rowid and rownum in SQL?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How is sql used in sql server?
What were the latest updates to SQL Azure service?