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

How much memory that we are using in Logshipping Concept?

1783

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 3760

If we shrink the Databse and Files, how much size is decreased?

TCS,

1 3755

What will you do If the low Performance occurs?

2 4209

Explain Capacity planning to create a database? and how to monitor it?

4199

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 8280

how we can use a database with php.

HCL, IT Solution,

2 4204

How retrieve field names from the table in SQL through JAVA code?

1904

what is the maximum size of a row in sql server 2000 and 2005

2 4900

what is bit data type? and what are the information that can be stored inside a bit column?

2 4413

what are default? Is there a column to which a default cant be bound?

1 3346

what purpose does OPENXML clause have in sql server stored procedure?

1 5593

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 3727

Can store procedure call by user define function in SQL server?

HCL,

10 18808

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

Infosys,

8 12711

Un-Answered Questions { SQL Server }

Does the order of columns in update statements matter?

911

How do I start sql server?

966

Tell me what is use of except clause? How it differs from not in clause?

959

What are the main differences between #temp tables and @table variables and which one is preferred?

1079

What are the requirements for sql server 2016?

880

What is named calculation? : sql server analysis services, ssas

972

What happens when converting big values to integers?

995

What is the difference between functions and stored procedures?

1155

How do I find information about the install locations for the various instances running on a computer?

1075

What is a synonym for manipulation?

987

How to generate create view script on an existing view?

984

Explain ms sql server reporting services vs crystal reports?

910

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1081

What does dml stand for?

944

Difference between DELETE and TRUNCATE?

1047

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