1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

How many triggers are possible per table?

 720

What is the maximum number of index per table?

 659

How to recompile stored procedure at run time?

 642

What are the different types of stored procedures?

 658

What is difference between rollback immediate and with no_wait during alter database?

 672

What is merge statement?

 699

Explain throw statement in sql server 2008?

 656

What is nonclustered index on computed columns?

 645

Explain some stored procedure creating best practices or guidelines?

 596

Explain try...catch with sql server?

 675

What are sp_configure commands and set commands?

 636

What is the ‘fillfactor’?

 640

What is read uncmmited?

 678

What is an sql server agent?

 627

What is the difference between for trigger and after trigger?

 629

Un-Answered Questions { SQL Server }

What is code near application topology?

218

How to provide column names in insert statements in ms sql server?

712

What are the 2 types of classifications of constraints in the sql server?

664

What are the disadvantages of merge replication?

870

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

642




What is the largest component inside a field?

626

How is sql used in sql server?

584

What is a covering index?

629

Tell about MOM Tool(Microsoft Operator Manager)?

1497

What is RAID? What are the different types of RAID configurations?

698

Differentiate between a primary key and a unique key.

698

How to execute the cursor queries with "open" statements?

701

in the physical file layout, where should the transaction log be stored in relation to the data file?

625

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

627

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

721

For More Un-Answered { SQL Server } Questions Click Here