Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

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

Satyam,

1228

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 7740

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

1249

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 17257

how insert selected column only ?

Robert Half,

3 4181

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

IBM,

3 8660

What are the new features in SQL Server 2005?

Emphasis,

3 4655

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 7035

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

2 6606

What is indexed views? plz explain with example?

2 2913

What is Covering Indexes? Plz explain with example

3 7625

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

1209

what is Archive old data?

1 2328

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 3669

what is maximum size of temp db?

iSoft,

4 9244







Un-Answered Questions { SQL Server }

Explain active/passive and active/active cluster configurations?

213


How do triggers work?

170


How do I start sql server agent automatically?

181


What is usually the first word in a sql query?

240


What is the difference between writing data to mirrored drives versus raid5 drives

190






What are cursors and when they are useful?

231


What number aggregate functions are accessible there in sql?

203


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3023


What is default constraint in ms sql server?

199


How do you create an execution plan?

165


What is auditing in sql server?

173


What are the reporting services components?

41


What are sql azure firewall rules?

34


What is difference between count (*) and count column?

157


How to add a new dsn with the odbc driver for sql server?

195