Scripts

1. Audit a SQL Server Configuration
2. Filegroup Restore Script
3. Restoring User Databases to Different Environments
4. Conversion Functions
5. Current Memory Use By SQL Server
6. Date Management Functions
7. Report All Objects In The Database
8. Search for a String Within Objects
9. Calculate Time Elapsed While Executing Code
10. List Extended Properties For All User Tables
11. List Extended Properties For All Columns
12. Compare Column Definitions Between Two Tables
13. Generate Insert Statement for Table
14. Delete User Objects from a Database
15. Set Up Operators
16. Set Up Alerts
17. Get message text by specifying the error number
18. Error Handling with TSQL
19. Execute T-SQL in Parallel
20. File Activity
21. Find Detached Databases
22. Index Maintenance
23. Find Tables Without Primary Keys
24. Find Indexes Not In Use
25. Find Missing Indexes
26. Find Queries in the Plan Cache That Are Missing an Index
27. Current Memory Use By SQL Server
28. Queries Waiting For Memory
29. Queries in Procedure Cache
30. Queries with Index Scans Due to Implicit Conversions
31. Calculate Current Table Sizes
32. Count Rows in All Tables
33. Querying for Failed Jobs
34. Retrieve and Disable All Active Jobs
35. Order all Job Steps Alphabetically
36. How to retrieve the last ran clean DBCC CHECKDB for one database
37. How to retrieve the last ran clean DBCC CHECKDB for many databases
38. Count How Many Times a String Appears In Another String
39. Replace a Substring
40. Reverse Order of Characters in a String
41. Substring with Start and End Parameters
42. Trim Patterns of a String
43. Word Wrap a String
44. Find the procedure names that are being used in the reports
45. Find all the adhoc sql used in reports
46. List all users and thier roles in Reporting Server
47. List all the rendering types and thier counts used in reports like excel, pdf
48. Password Generation
49. Import/Export Scripts
50.