SQL Server Interview Questions
Questions Answers Views Company eMail

wat is the main diff between sql server 2000and sql server 2005

Jade Software,

6 5764

What is the difference between windows authentication and sql server authentication


7 17189

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



how can i store resumes in database?


3 6698

how many joins we can write if at all we have n no of tables

Tanla Solutions, TS,

5 11657

what is the order of execution of where,having,group by in select stement

IBM, Tanla Solutions,

6 15475

What is the difference between SSAS 2000 and SSAS 2005?


1 5262

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.


6 9698

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 5208

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3


15 7453

i want table name basis on column name.

5 4398

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.


3 5072

In clustered and non clustered indexes which one is faster while executing a query ?

1 5885

How to create logins using windows Authentication mode?

2 2288

write the query for taking database restore in sql?

2 3033

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

how many no of arguments can be passed in procedures and functions


Issues related in upgrading SQL Server 2000 to 2005 / 2008


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


Why we need to use secondry database file? though, we can do same work using primary database file also.


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


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


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?


How do use Having,Group by,Group function in SQL?


How can we call UDF(User Define Function) using C# code in ASP.net ?


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?


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


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


what is the Ticketing tool used in Wipro technologies at Bangalore...???


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


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