SQL Server Interview Questions
Questions Answers Views Company eMail

wht is normalization?can u explain me in detail?

TCS,

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?

HP,

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,

1193

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?

Evalueserve,

3 6833

what is the cursor life span?

Evalueserve, HG,

5 9831

What is the difference between NOROW and LOCKROW?

Satyam, Accenture, Honeywell,

1361

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?

1094

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 .

892


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

1024


Issues related in upgrading SQL Server 2000 to 2005 / 2008

837


optimization techinques

1412


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.

2731






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

983


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.

407


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

884


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

924


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

3583


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

1539


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

1210


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?

997


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.

1302


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

902