SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 8231

What are functions

3 6410

how to get the automatic backup of the database in the sql server

4 31675




What command do we use to rename a db?

5 8410

What are the four main query statements?

Wipro,

7 14907

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 12127

What is the STUFF function and how does it differ from the REPLACE function?

2 17046

What is SQL server agent?

HCL, SAP Labs,

2 6151




What is the purpose of UPDATE STATISTICS?

2 9974

What is de-normalization and when do you do it?

3 5456

Difference between Function and Stored Procedure?

C1 India,

9 14694

What is data integrity? Explain constraints?

Thinksoft,

1 21877

Explain some DBCC commands?

6 14010

What are tasks?

Wipro,

3 8204

What is the purpose of using COLLATE in a query?

1 16216


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?

8830


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?

1349


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

1573


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?

879


How you trouble shoot when any job fails

795






whats the maximum size of view state??

1043


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1037


what are the critical issues you have resloved in your company

919


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

965


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.

1781


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1366


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

865


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

952


application server is slow what may be the problem

1166


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?)

797