SQL Server Interview Questions
Questions Answers Views Company eMail

wht is normalization?can u explain me in detail?

TCS,

9 11782

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 7848

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 3259




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

Oracle, IntraLogic,

1224

How many index keys possible for a table

6 8165

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

Infosys, TCS, DELL, Siemens, i Tech,

9 56092

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 18993

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

Synechron, Leo Technologies, Mannar Company,

15 21907




what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 8563

What are Magic Table?

3i Infotech, NIIT, Evalueserve, Digiweb, PL,

34 56463

what are file groups?

Evalueserve,

3 6890

what is the cursor life span?

Evalueserve, HG,

5 9906

What is the difference between NOROW and LOCKROW?

Satyam, Accenture, Honeywell,

1406

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1125

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

IBM, Symphony,

28 15404


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

873


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

393


plss anybody specify tha constrian management system in dbms

897


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1428


your distribution database is full what will u do

1041






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

960


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.

756


how can u get last observation in an unknown dataset ?

1252


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

917


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

1192


how to overcome kernel isssues

541


1 01 101 01010

839


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1122


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1768


How to restore performance issues and how to check?

924