Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

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

Jade Software,

6 7838

What is the difference between windows authentication and sql server authentication

HCL,

7 20662

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,

1600

how can i store resumes in database?

HCL,

3 8344

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

Tanla Solutions, TS,

5 13758

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

IBM, Tanla Solutions,

6 19528

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 6349

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

APX,

6 12384

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 8403

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 11700

i want table name basis on column name.

5 6204

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 6401

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

1 6725

How to create logins using windows Authentication mode?

2 3348

write the query for taking database restore in sql?

2 4275


Un-Answered Questions { SQL Server }

What is identity?

392


How many levels of sp nesting is possible?

426


Can I save my report as html, excel or word? : sql server management studio

398


Where can you find the error log information? : sql server database administration

422


What is tcl in sql server?

515






Which is the best place or learning center for MS SQL?????In Bangladesh?????

1443


tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

428


What is the Disadvantage of indexed sequential file.

453


What is an execution plan? When would you use it?

429


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

1318


What are the advantages of using stored procedures?

381


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

432


List down some advantages of sql stored procedure?

396


How to define the name and server for a new dsn?

394


What is normalization and its types?

354