what is package and it uses and how can u call a package1228
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
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)?15 17257
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 example3 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, Rupesh3 3669
Explain active/passive and active/active cluster configurations?
How do triggers work?
How do I start sql server agent automatically?
What is usually the first word in a sql query?
What is the difference between writing data to mirrored drives versus raid5 drives
What are cursors and when they are useful?
What number aggregate functions are accessible there in sql?
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.
What is default constraint in ms sql server?
How do you create an execution plan?
What is auditing in sql server?
What are the reporting services components?
What are sql azure firewall rules?
What is difference between count (*) and count column?
How to add a new dsn with the odbc driver for sql server?