SQL Server Interview Questions
Questions Answers Views Company eMail

How much memory that we are using in Logshipping Concept?

775

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

1 2065

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

TCS,

1 2172




What will you do If the low Performance occurs?

2 2175

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

2947

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

2 6088

how we can use a database with php.

HCL, IT Solution,

2 2020

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

772




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

2 2916

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

2 2223

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

1 1711

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

1 3759

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

1 1990

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

HCL,

10 12361

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 6144


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

ow to bring suspect mode datbase online from scratch

759


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

452


SQL Server Architecture ?

1206


what are the critical issues you have resloved in your company

904


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

875






New concepts of sql server 2005 use in your project.

1303


Issues related in upgrading SQL Server 2000 to 2005 / 2008

855


What is RMS migrations?

1035


If a stored procedure is taking a table data type, how it looks?

4791


on line cluster can we make if yes tell me the procedure

911


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

2947


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

771


How you trouble shoot when any job fails

774


wat wil hapn if we give the both read and deny read permission to user?

1031


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

894