SQL Server Interview Questions
Questions Answers Views Company eMail

Can group by and orderby be used together?

559

Can group by be used without aggregate functions?

444

Does group by or order by come first?

517

Does group by sort data?

491

What is difference between group by and having?

533

How do I find the sql server database version?

498

How do I setup a local sql server database?

508

What is the purpose of forms?

464

What is field with example?

488

Should you normalize audio?

503

What is a domain constraint give an example?

536

What is the purpose of grouping data in a report?

507

What are the 10 characteristics of data quality?

505

How does normalization work?

477

What are the different types of queries?

1 826


Un-Answered Questions { SQL Server }

What are types of storage modes? : sql server analysis services, ssas

553


What is pivot and unpivot?

600


Explain the flow of creating a cube? : sql server analysis services, ssas

595


What are filegroups in sql server?

547


How to download and install microsoft .net framework version 2.0?

524






What is a transact-sql statement batch in ms sql server?

473


Can we write ddl in trigger?

470


Explain following error properties?

530


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

649


What is data modeling and Reterminal integrity?

1451


Why should one not prefix user stored procedures with ‘sp_’?

569


Write the syntax for stuff function in an sql server?

510


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1181


What do you understand by physical_only option in dbcc checkdb?

552


Can you explain powershell included in sql server 2008?

483