1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

Satyam,

1604

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 8777

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

 1667

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,

16 21957

how insert selected column only ?

Robert Half,

3 5421

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

IBM,

3 9929

What are the new features in SQL Server 2005?

Emphasis,

3 5670

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 8498

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

 2 7336

What is indexed views? plz explain with example?

 2 3685

What is Covering Indexes? Plz explain with example

 3 8695

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

 1608

what is Archive old data?

 1 3002

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 4717

what is maximum size of temp db?

iSoft,

4 10527

Un-Answered Questions { SQL Server }

What is the primary use of the model database?

661

What is the web service used for reporting services?

100

What is the difference between a unique key and primary key?

534

What is normalization? Describe its different types.

623

What is resource governor in sql server?

592




On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

680

What is the full meaning of dml?

558

Explain what is it unwise to create wide clustered index keys?

569

how would you store your query in an SSRS report or a Database server?

122

How to maintain a fill factor in existing indexes?

556

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

508

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

576

How to generate random numbers with the rand() function in ms sql server?

599

Can we perform backup restore operation on tempdb? : sql server database administration

618

How to connect to a sql server using odbc_connect()?

647

For More Un-Answered { SQL Server } Questions Click Here