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?

1848

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

1 3842

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

TCS,

1 3828

What will you do If the low Performance occurs?

2 4324

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

4250

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

2 8386

how we can use a database with php.

HCL, IT Solution,

2 4304

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

1961

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

2 5005

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 5673

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

1 3834

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

HCL,

10 19064

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 13014

Un-Answered Questions { SQL Server }

How to insert stored procedure result into temporary table?

1068

How to convert a unicode strings to non-unicode strings?

1161

What is shared lock?

949

How the authentication mode can be changed?

1176

what are user defined datatypes? : Sql server database administration

1018

What is the standby server?

1003

Tell me what is sql profiler?

1087

Explain what is log shipping?

1199

What is local temp table?

1026

What is a user-defined function in the sql server and what is its advantage?

1143

How do I view a trc file?

981

What happens on checkpoint?

1074

What is tablesample?

1183

how many triggers you can have on a table? : Sql server database administration

1023

How many replicas are maintained for each SQL Azure database?

144

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