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?

1845

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

1 3838

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

TCS,

1 3822

What will you do If the low Performance occurs?

2 4318

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

4246

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

2 8384

how we can use a database with php.

HCL, IT Solution,

2 4302

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

1959

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

2 4996

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

2 4531

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

1 3427

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

1 5669

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

1 3831

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

HCL,

10 19050

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 12987

Un-Answered Questions { SQL Server }

what's sql server? : Sql server database administration

1053

What is clustered primary key?

1084

What is the latest version of microsoft sql server?

1117

What is a linked server in sql server?

1137

What is the purpose of sql profiler in sql server? : sql server database administration

1161

Do you have any idea about the tcl commands?

1016

What is the difference between having clause and where clause in sql server?

1170

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

2027

How to use user defined functions in expressions?

1153

Do you know the cursor optimization tips?

1039

How to create an index on a view?

1143

What are “lock” hints?

1106

What is transactional replication?

1023

What is change data capture (cdc) feature?

1124

How to delete duplicate rows in sql server?

1155

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