SQL Server Interview Questions
Questions Answers Views Company eMail

What is awe?

572

When columns are added to existing tables, what do they initially contain?

630

What is the order by used for?

625

What is a transactions?

606

What is row_number()?

585

What stored by the master?

547

What is 'write-ahead log' in sql server 2000 ?

629

What is bcp? When does it used?

552

Which are new data types introduced in sql server 2008?

605

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

642

What are the basic functions for master, msdb, model, tempdb and resource databases?

557

What is the purpose of the master database?

603

Does server sql treat char as a variable-length or fixed-length column?

589

Does sql server 2000 full-text search support clustering?

510

What is filtered index?

655


Un-Answered Questions { SQL Server }

Explain the categories of stored procedure?

520


Explain how you can configure a running aggregate in SSRS?

111


What is the purpose of grouping data in a report?

547


can you implement data mining in SSRS?

113


what purpose does the model database serve? : Sql server database administration

506






What are the advantages dts has over bcp?

535


What is normalization? What number of normalization shapes are there?

610


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

590


What are the built in functions in sql server?

491


Does a specific recovery model need to be used for a replicated database? : sql server replication

536


why would you call update statistics? : Sql server database administration

577


Can you create a logon trigger in sql server 2005 express edition?

576


What is the purpose of the model database?

602


What is the use of partition by in sql server?

516


What is the standby server?

522