SQL Server Interview Questions
Questions Answers Views Company eMail

wht is normalization?can u explain me in detail?


9 11623

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 7764

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?


1 3219

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,


How many index keys possible for a table

6 8095

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 55894

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

19 18768

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

Synechron, Leo Technologies, Mannar Company,

15 21677

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

2 8493

What are Magic Table?

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

34 56078

what are file groups?


3 6833

what is the cursor life span?

Evalueserve, HG,

5 9831

What is the difference between NOROW and LOCKROW?

Satyam, Accenture, Honeywell,


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?


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

IBM, Symphony,

28 15149

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


What is best institute to Learn DotNET And SQL in chennai?


Issues related in upgrading SQL Server 2000 to 2005 / 2008


optimization techinques


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


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


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


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


role of sql sever 2005 in database rather than any other database


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


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


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


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


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