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


SQL Server Interview Questions
Questions Answers Views Company eMail

What are pessimistic lock and optimistic lock?

 650

What is table constraint?

 639

What is sqlcmd?

 629

Explain activity monitors

 705

What is after dml trigger?

 662

What is dirty read?

 709

What is temporary table in sql server? Why we use temp table?

 599

what is spatial nonclustered index

 616

Explain system functions or built-in functions? What are different types of system functions?

 655

What is standby servers? Explain types of standby servers.

 594

What is self contained sub query?

 646

What is a scheduled job or what is a scheduled task?

 618

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

 618

What is clustered index

 647

Disadvantages of the indexes?

 656

Un-Answered Questions { SQL Server }

What is difference between views and stored procedures?

604

What is the current limitation of the size of SQL Azure DB?

112

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1634

What is factless fact table? : sql server analysis services, ssas

657

What is fill factor and pad index?

649




What is the full form of ddl?

588

Explain log shipping and mention its advantages.

691

What do I need to start working with sql studio? : sql server management studio

687

What is mean by candidate key?

638

What are the new scripting capabilities of ssms? : sql server management studio

636

Show Practically Sql Server Views are updatable?

694

Explain what is dbcc?

675

whats the maximum size of view state??

1814

What is a non equi join?

641

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

627

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