SQL Server Interview Questions
Questions Answers Views Company eMail

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

Satyam,

932

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 6983

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

886




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 14373

how insert selected column only ?

Robert Half,

3 3372

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

IBM,

3 7794

What are the new features in SQL Server 2005?

Emphasis,

3 3845

What are the different types of backup avaible in SQL SErver

IBM, Emphasis,

6 6104




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

2 5980

What is indexed views? plz explain with example?

2 2418

What is Covering Indexes? Plz explain with example

3 6677

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

892

what is Archive old data?

1 1821

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 3155

what is maximum size of temp db?

iSoft,

4 8275


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

710


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1316


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?

979


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

899


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

886






can any body tell me how to know the password of current user in sql server

947


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

3558


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1621


How to convert a table data in XML format in sql server?

1440


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

974


application server is slow what may be the problem

1114


Tell about MOM Tool(Microsoft Operator Manager)?

719


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

973


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

698


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.

1289