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

HCL,

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

IGT,

998




how can i store resumes in database?

HCL,

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?

APX,

1 5262

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

APX,

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

Google,

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.

iFlex,

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

3421


Issues related in upgrading SQL Server 2000 to 2005 / 2008

720


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

1351


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

4137


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

794






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

972


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

889


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

623


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

4581


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?

573


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

1450


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?

817


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

4790


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

812


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

2710