Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion
2014-02-03 (first published: 2014-01-21)
1,290 reads
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
2,711 reads
This script will return databases that have no backup.
2014-01-30 (first published: 2012-10-07)
2,198 reads
Profile all of a table's columns using Transact-SQL.
2014-01-28 (first published: 2013-01-16)
2,281 reads
Scripts role membership, object-level permissions for all DB users.
2014-01-24 (first published: 2010-11-02)
27,251 reads
This SQL script will return basic information on each database on your server.
2014-01-21 (first published: 2013-12-28)
2,262 reads
One query to list space used and row counts of all tables
2014-01-17 (first published: 2014-01-03)
1,788 reads
A simple script for automation of additional secondary data files of tempdb.
2014-01-14 (first published: 2013-12-27)
2,427 reads
This script will check the full backup time taken by all the databases of an SQL Server instance.
2014-01-13 (first published: 2014-01-07)
1,376 reads
This Script will fetch database backup information from msdb and give the idea about full, diffrential and log backup.
2014-01-10 (first published: 2014-01-04)
1,419 reads