SQL Server Interview Questions
Questions Answers Views Company eMail

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



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


3 6853

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


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?


3 7571

What are the new features in SQL Server 2005?


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 ?


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?


4 8094

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is RMS migrations?


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


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


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


how to do partition in sqlserver


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


whats new about truncate in sql server 2008?


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?


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


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?


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.


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


ow to bring suspect mode datbase online from scratch


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


SQL Server Architecture ?