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 6218

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

2 15763

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

7 13289

Difference between Cluster and Non-cluster index?

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

32 123856

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

2 6944

Explain DBMS, RDBMS?

6 19488

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

TetraSoft, Wipro,

3 17750

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 14058

Explain couple pf features of SQL server

2 4024

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


Explain fundamentals of Data ware housing & OLAP?

2 5609

Explain the new features of SQL server 2000?

1 4556

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


Explain sp_configure commands, set commands?

3 9263

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


2 13503

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


how to take backup bcp out for a column in table in sql server?


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that


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


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


what is checksum in sql server.........???


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


how can you attach more than 20 ldf files in sql server


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


Does any body please help me what question's have asked for SSRS in the interview?


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


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?