SQL Server Interview Questions
Questions Answers Views Company eMail

If there is failure during updation of certain rows, what will be the state?

2 8525

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 6546

how to dispaly a particular row details from a given table

2 3903

What is a transaction and what are ACID properties?

3 4869

Explain different isolation levels?

4 7684

What's the maximum size of a row?

4 7781

Explain Active/Active and Active/Passive cluster configurations?

1 3140

Explain the architecture of SQL Server?

HP, Oracle, ABC,

2 33790

What is lock escalation?

1 5434

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 13017

Explain the storage models of OLAP?

1 5653

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?



What are constraints? Explain different types of constraints?

Wipro, Polaris, Kendriya Vidyalaya(Kvs), Emsang,

26 118553

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 7988

what operator performs pattern matching?

2 8804

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?


last function used in MS Access to convert sql what function will use in sql


Scalability, Availability, Integration with internet, etc.)?


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


on line cluster can we make if yes tell me the procedure


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


What is Lock table in SQL?


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


If the job running very slow what is the action you do


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


Delete duplicate rows without using rowid.


If we delete pack Spec what will be the status of pack Body ?


what are the Prerequisites for Replication?