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?

1741

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

1 3699

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

TCS,

1 3670

What will you do If the low Performance occurs?

2 4111

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

4152

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

2 8192

how we can use a database with php.

HCL, IT Solution,

2 4106

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

1850

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

2 4799

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

2 4308

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

1 3268

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

1 5525

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

1 3631

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

HCL,

10 18549

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 12436

Un-Answered Questions { SQL Server }

Explain primary key and foreign key constraints?

972

Explain about temporary stored procedure?

946

How to check if a table is being used in sql server?

912

Explain what is the difference between a local and a global temporary table?

947

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1067

Can we create clustered index on composite key?

991

What is the default value of an integer data type in sql server 2005?

917

What is temporary table in sql server? Why we use temp table?

913

When would you use the stored procedures or functions?

955

What is a partition key?

899

How to return the top 5 rows from a select query in ms sql server?

1084

explain different types of backups avaialabe in sql server? : Sql server database administration

934

Tell me extended events in sql server 2008?

954

What is an example of a primary key?

922

What is the default Port No on which SQL Server listens?

1080

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