This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2012-11-29 (first published: 2012-10-31)
1,963 reads
Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.
2012-11-27 (first published: 2012-10-18)
2,552 reads
This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.
2012-11-26 (first published: 2012-10-18)
3,932 reads
This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.
2012-11-23 (first published: 2012-10-17)
1,327 reads
This script will produce the top 10 wait state issues along with their descriptions.
2012-11-22 (first published: 2012-10-22)
1,780 reads
Backup up all databases based on sys.databases.
2012-11-21 (first published: 2012-10-02)
1,595 reads
Backup up all transaction logs based on sys.databases.
2012-11-16 (first published: 2012-10-02)
1,220 reads
Constructs a restore script for all databases on the server from backup history.
2012-11-12 (first published: 2012-09-26)
1,240 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,104 reads
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,954 reads