SQL Server Interview Questions
Questions Answers Views Company eMail

what is package and it uses and how can u call a package

Satyam,

851

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

TCS,

3 6853

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

820




how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

Accenture, IBM, Marlabs,

15 13945

how insert selected column only ?

Robert Half,

3 3242

when we use function instead of procedure? plz tell me the situation with ex?

IBM,

3 7571

What are the new features in SQL Server 2005?

Emphasis,

3 3757

What are the different types of backup avaible in SQL SErver

IBM, Emphasis,

6 5961




About Indexed Views? with example? plz reply...

2 5856

What is indexed views? plz explain with example?

2 2323

What is Covering Indexes? Plz explain with example

3 6487

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

831

what is Archive old data?

1 1708

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 3041

what is maximum size of temp db?

iSoft,

4 8094


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is RMS migrations?

922


Scalability, Availability, Integration with internet, etc.)?

1607


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

789


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

914


how to do partition in sqlserver

1279






wat wil hapn if we give the both read and deny read permission to user?

907


whats new about truncate in sql server 2008?

1281


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?

589


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

334


This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

1213


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.

627


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

1472


ow to bring suspect mode datbase online from scratch

661


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

3451


SQL Server Architecture ?

1101