Monthly Archives: February 2010

Delete All Procedures from a database in SQL Server

Sometime we need to delete the all the stored procedures in particular database .For this use the below script to generate to drop the all the store procedures. After execute this query it will gives script for drop store procedures with … Continue reading

Posted in Articles | Tagged , , , | Leave a comment

SQL best practices for better performance

In general while developing the queries the required result will retrieve from query.  But the performance will be down after some days in production server due to data .In the scenario we have optimize the queries. So  while developing the … Continue reading

Posted in Articles | Tagged , , | 1 Comment