SQL Server Interview Questions
Questions Answers Views Company eMail

What is a job?

3 3341

What are primary keys and foreign keys?

3 3006

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 7972




If a stored procedure is taking a table data type, how it looks?

1 4727

How m-m relationships are implemented?

2 5936

How do you know which index a table is using?

4 8776

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 5493

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 6502




How can you get @@error and @@rowcount at the same time?

9 16082

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 7845

What are the type of joins? When do we use Outer and Self joins?

3 7515

Which virtual table does a trigger use?

TCS,

8 17968

How do you measure the performance of a stored procedure?

Infosys,

3 12701

Questions regarding Raiseerror?

1 5075

Questions on identity?

Infosys,

2 4452


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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.

1677


where the connection string store in the database

858


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

877


If a stored procedure is taking a table data type, how it looks?

4727


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

1006






What is Lock table in SQL?

311


ow to bring suspect mode datbase online from scratch

724


How can we call UDF(User Define Function) using C# code in ASP.net ?

4760


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?

1081


role of sql sever 2005 in database rather than any other database

907


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

744


Tell about MOM Tool(Microsoft Operator Manager)?

719


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

656


How do you Implement SSIS Packages in your Project?

869


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1529