SQL Server Interview Questions
Questions Answers Views Company eMail

What are different types of schemas?

523

What is a data collection table?

546

What is the largest component inside a field?

534


Un-Answered Questions { SQL Server }

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

865


What is a file group?

628


Why union all is faster than union?

511


How to get a list of all tables with "sys.tables" view in ms sql server?

556


How do you set a trace flag in sql server?

559






How do I view a trc file?

507


What is difference between count (*) and count column?

527


How will you decide the active and passive nodes?

643


What is GUID in sql server?

645


How will you add a dimension to cube? : sql server analysis services, ssas

558


your distribution database is full what will u do

1683


What part does database design plays a role in performance of an sql server-based application?

529


What are the different types of upgrades that can be performed in sql server?

695


Is it important for a database administrator to understand the operating system and file access?

519


What is sub-query in sql server?

676