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,

1552

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 8686

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

 1630

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 21456

how insert selected column only ?

Robert Half,

3 5306

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

IBM,

3 9787

What are the new features in SQL Server 2005?

Emphasis,

3 5567

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 8329

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

 2 7251

What is indexed views? plz explain with example?

 2 3603

What is Covering Indexes? Plz explain with example

 3 8589

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

 1565

what is Archive old data?

 1 2929

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 4625

what is maximum size of temp db?

iSoft,

4 10413

Un-Answered Questions { SQL Server }

What are “lost updates”?

605

What is @@error in sql?

616

How to scale out a federation by Sql statement?

92

What happens when converting big values to numeric data types?

561

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

530




What is user defined datatypes and when you should go for them?

571

what are the different types of replication you can set up in sql server? : Sql server database administration

506

How to create user defined functions with parameters?

628

How to filter records of table in SQL SERVER?

588

what is the maximum size of a row? : Sql server database administration

524

What is difference between cte and view?

515

How many types of the database links?

592

What is always encrypted?

512

How to create an inline table-valued function?

527

How to verify a user name with sqlcmd tool?

576

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