SQL Server Interview Questions
Questions Answers Views Company eMail

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 6056

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 15295

How do you find the number of rows in a table?

7 12905




Difference between Cluster and Non-cluster index?

Accenture, eClinicalWorks, HCL, Satyam, Oracle, Yardi, Agility e-Services, Infosys,

32 122342

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 6683

Explain DBMS, RDBMS?

6 19229

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

TetraSoft, Wipro,

3 17169

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 13728




Explain couple pf features of SQL server

2 3844

Scalability, Availability, Integration with internet, etc.)?

1608

Explain fundamentals of Data ware housing & OLAP?

2 5462

Explain the new features of SQL server 2000?

1 4438

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

854

Explain sp_configure commands, set commands?

3 8900

What is the basic functions for master, msdb, tempdb databases?

CSC,

2 13216


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

813


1 01 101 01010

711


Delete duplicate rows without using rowid.

156


Working with TLogs

662


If the job running very slow what is the action you do

687






Issues related in upgrading SQL Server 2000 to 2005 / 2008

740


What is the difference between online clustering and Offline clustering?

1197


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

826


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1472


How to convert a table data in XML format in sql server?

1369


which backup strategy you are following at ur company

963


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1118


Why do you want to join software field as you have done your BE in Electronics?

996


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

672


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

2742