How to encrypt a big list of sp’s at once
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn’t be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I’ll like to know if there is a way [...]

Answer Question   |  November 18, 2009  7:52 PM
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization

optimization of stored procedures in sqlserver
is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh

Answer Question   |  February 10, 2011  6:15 AM
SQL Server stored procedures, Stored Procedures, Stored Procedures Optimization