SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 7851

Without Using Cursors , How to Select the Selected row??

CarrizalSoft Technologies, Wipro,

3 9124

How many index can be created for single table

CarrizalSoft Technologies, Verizon,

4 18520

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

1963

what exactly sql injuction.how to overcome.....

CTS, IBM,

2542

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 4963

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

CarrizalSoft Technologies,

1 6997

How cand Optimize SQL Server Stored Procedures

1 5144

How many types of system privileges are there, Can we add or delete privileges?

2 7757

What is Online Index Rebuild Operation?

1 3734

What are the limitation of the Online Index Rebuild Operation?

1 3670

What Are Three Rules to Use UNION IN SQL SERVER

1 6469

How to create Clustered Primary Key to table?

2 4948

Write a SQL Query to find first Week Day of month?

2 12864

How to find 6th highest salary from Employee table ?

10 24072

Un-Answered Questions { SQL Server }

What is rank function?

1029

Explain the difference between HTTP and HTTPS in database?

1031

Tell me what are the essential components of sql server service broker?

941

What are the types of database recovery models?

1123

What are the general features of sql server management studio? : sql server management studio

1076

How to delete duplicate rows?

997

Which is the latest version of sql server and when it is released?

1112

How many levels of sp nesting are possible?

1024

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1208

Do you know what are the differences between lost updates and uncommitted dependencies?

1081

Explain what is “asynchronous” communication in sql server service broker?

917

Explain system views?

1086

How to select all columns of all rows from a table with a select statement in ms sql server?

1114

Why main is user defined function?

1010

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

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