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?

1792

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

1 3766

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

TCS,

1 3757

What will you do If the low Performance occurs?

2 4213

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

4204

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

2 8289

how we can use a database with php.

HCL, IT Solution,

2 4213

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

1905

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

2 4905

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

2 4426

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

1 3352

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

1 5597

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

1 3735

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

HCL,

10 18827

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 12742

Un-Answered Questions { SQL Server }

How to find the second highest salary of an employee?

1179

What are the steps to process a single select statement?

942

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1064

What is a hint?

993

What is the simplest way to create a new database in ms sql server?

1010

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

1905

What is 5nf in normalization form?

992

How do you handle datasets larger than 50 gb?

162

Why Master database is required?

1141

How to round a numeric value to a specific precision?

1074

What are the requirements on sql server network connections?

993

What are sql server procedures?

979

How to connect of datebase with sql express.?

1104

what is a mixed extent? : Sql server administration

1102

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145

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