Browse by Tags

All Tags » drop   (RSS)
Lighter side of a TSQL query :: Wedding Style
09 August 08 09:45 AM | SQL Master | 2 Comments   
Writing a better TSQL query will get you better performance, in terms of system & life-style too. Here is the email I received from my BIL, too get a lighter side of blending a TSQL query as Stored Procedure (from а BrideGroom) .... guess what would Read More...
How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?
20 May 08 01:12 AM | SQL Master | 2 Comments   
It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways Read More...
TSQL script for deleting backups older than 1 day
10 September 07 02:34 AM | SQL Master | 2 Comments   
Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get Read More...