Advantages and disadvantages of stored procedures.
Answers were Sorted based on User's Feedback
what exactly sql injuction.how to overcome.....
What is split brain scenario in DB mirroring?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is filtered index?
What is auditing in sql server?
What are different type of Collation Sensitivity?
What is normalization? What number of normalization shapes are there?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Give the query of getting last two records from the table in SQL SERVER?
0 Answers Petranics Solutions,
Why do we use functions?
What is the sql profiler?