SQL Server Interview Questions
Questions Answers Views Company eMail

How much memory that we are using in Logshipping Concept?

1358

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

1 3091

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

TCS,

1 3089

What will you do If the low Performance occurs?

2 3311

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

3745

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

2 7352

how we can use a database with php.

HCL, IT Solution,

2 3225

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

1393

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

2 4051

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

2 3511

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

1 2637

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

1 4895

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

1 2989

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

HCL,

10 16396

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 10072


Un-Answered Questions { SQL Server }

Do you know what guidelines should be followed to help minimize deadlocks?

529


Does sql server 2016 have ssms?

502


What is normalization? What number of normalization shapes are there?

592


How real and float literal values are rounded?

576


What is the report builder?

106






Explain the difference between HTTP and HTTPS in database?

555


What are the requirements on sql server network connections?

514


what exactly sql injuction.how to overcome.....

2033


Explain the rules for designing files and file groups in sql server?

539


What is the difference between char and varchar2 datatype in sql?

532


How to delete a login name in ms sql server?

524


Name and describe few console utilities for ssrs?

249


Why use cursor in sql server?

538


What is the importance of a recovery model?

596


Explain user defined functions?

606