SQL Server Interview Questions
Questions Answers Views Company eMail

Can group by and orderby be used together?

782

Can group by be used without aggregate functions?

695

Does group by or order by come first?

732

Does group by sort data?

686

What is difference between group by and having?

729

How do I find the sql server database version?

703

How do I setup a local sql server database?

723

What is the purpose of forms?

710

What is field with example?

697

Should you normalize audio?

724

What is a domain constraint give an example?

808

What is the purpose of grouping data in a report?

744

What are the 10 characteristics of data quality?

699

How does normalization work?

709

What are the different types of queries?

1 1174


Un-Answered Questions { SQL Server }

Define constraints and give an example of their use?

765


How many database files are there in sql server 2000?what are they?

783


What command is used to rename the database?

710


How raid can influence database performance?

775


What does sql server mean?

713


What is difference between drop truncate and delete?

772


Explain the dirty pages?

768


Explain SSRS Architecture?

163


What is the dbcc command and why is it used?

777


Explain “not null constraint” in sql server?

745


What is a natural primary key?

704


How to loop through result set objects using odbc_fetch_row()?

683


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2418


Explain different types of collation sensitivity?

721


What is scd (slowly changing dimension)? : sql server analysis services, ssas

790