SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 8191

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

5 6167

how to dispaly a particular row details from a given table

2 3648

What is a transaction and what are ACID properties?

3 4623

Explain different isolation levels?

4 7271

What's the maximum size of a row?

4 7418

Explain Active/Active and Active/Passive cluster configurations?

1 2920

Explain the architecture of SQL Server?

HP, Oracle, ABC,

2 32935

What is lock escalation?

1 5213

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

9 12481

Explain the storage models of OLAP?

1 5182

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 115340

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

2 7583

what operator performs pattern matching?

2 8310

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


what is the Ticketing tool used in Wipro technologies at Bangalore...???


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60


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


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


What is the query optimization statistics?


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?


Why we need to use secondry database file? though, we can do same work using primary database file also.


If user is owning any SQL Objects, can we drop that user


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


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


How do you Implement SSIS Packages in your Project?


how many no of arguments can be passed in procedures and functions


What are the dis_advantages of stored procedures, triggers, indexes?


Does any body please help me what question's have asked for SSRS in the interview?