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

What are the tool windows in sql server management studio? : sql server management studio

1121

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1029

Why does sql studio use a single registered database repository? : sql server management studio

1036

What's new in sql management studio for sql server? : sql server management studio

1118

What do I need to start working with sql studio? : sql server management studio

1158

Can I work with several databases simultaneously? : sql server management studio

1029

What is ems sql management studio? : sql server management studio

1163

How can I create a new template for import ? : sql server management studio

1113

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1087

What is the purpose of object explorer and its features? : sql server management studio

1272

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

1132

What are the benefits and tasks of object explorer? : sql server management studio

1250

Can I save my report as html, excel or word? : sql server management studio

1008

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1184

To which devices can a backup be created and where should these devices be located? : sql server management studio

1101

Un-Answered Questions { SQL Server }

What is the significance of null value and why should we avoid permitting null values?

1032

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1027

Does hive support indexing?

999

Which trace flags are enabled in sql server?

1071

What is constraints and its types?

997

How is foreign key related to primary key?

1010

Explain the architecture of ms sql reporting service?

969

What is rtm version in sql server?

1101

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

2009

How to create a simple stored procedure in ms sql server?

1085

What is a field name?

1017

What are the advantages of user defined function?

1041

How to create database with physical files specified in ms sql server?

1034

How do database indexes work?

1055

What triggers long term care?

1085

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