What are the dis_advantages of stored procedures, triggers,
indexes?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  


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

0 Answers  


How do you trace the traffic hitting a sql server?

0 Answers  


List the types of recovery model available in sql server?

0 Answers  


What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  






Why are you getting errors when creating a new odbc dsn?

0 Answers  


What do you do in data exploration

0 Answers   EXL,


Explain how does the report manager work in ssrs?

0 Answers  


Difference between primary key and clustered index?

0 Answers  


How to execute function in stored procedure sql server?

0 Answers  


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

0 Answers  


What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  


Categories