Search SSWUG.ORG:

SCRIPT LIBRARY

Script
Scripts - Partial data binding of huge data to a GridView in an optimized way.
Scripts - Partial data binding of huge data to a GridView in an optimized way.

Content:
Testing:
SQL Server 2008
Audit Trigger Generation
Use this script to Generate Audit Triggers for tables in your database

Content:
Development:
SQL Server 7.x and later
Full Compress Backup of All User Databases
This T-SQL script is full compress backup of all user databases

Content:
Administrative:
SQL Server 2008
Calculating Uptime when support window isn't 24/7
In some corporates there are permissible down time windows, i.e. in the evenings or weekends or both. And then public holidays need to be factored in as well. You want to work out the number of work seconds between two dates and then use this as your total to divide your actual uptime into.

Content:
Administrative:
SQL Server 7.x and later
View Database growth over time
This script uses the backup size as an indication of the real amount of space used by a database. A database with a 1GB mdf that only has 10MB of data is in fact only 100MB in size. This db may grow by 100MB per month. If the mdf size is used, no growth will be observed for 10 months.

Content:
Administrative:
SQL Server 7.x and later
View any new databases created on multiple servers
This Powershell script uses the native Provider that comes standard with SQL 2008. From one function I can see any new (created in the last 30 days, for example) databases that are created on any server and the database size. Great for capacity planning and billing!

Content:
Administrative:
SQL Server 7.x and later
Kill the users before the automatic restore
works on 7, 2000, 2005, 2008

Content:
Administrative:
SQL Server 7.x and later
Analyzing SQL Agent Job and Job Step History in SQL Server
--Analyzing SQL Agent Job and Job Step History in SQL Server -- Written By: Atif Shehzad MSSqlTips.com Have not tested yet...ejm

Content:
Monitoring:
SQL Server 2000 and later
Data_Time_Master_Table
This Script is step 2 to see the Impact of Forced Parameterization this will populate the data in time master table which was created in Step 1

Content:
Development:
SQL Server 7.x only
Time_Master_tbl_ForcedParameterization
This Script is the Step 1 for creating a table in order to see the impact of Forced Parameterization

Content:
Development:
SQL Server 7.x only
Permissions Scripts plus some......
Will give a listing of all permissions on database objects.

Content:
Administrative:
SQL Server 6.x and later
dba3_sys_IndicesAudit
Audit indices ss2k5 and beyond only

Content:
Administrative:
SQL Server 2005 only
dba3_DeleteTopByIncrements_demo
Requires TOP (variable) support of 2k5 & later - demo script

Content:
Administrative:
SQL Server 2000 and later
dba3_fx_DateOnly
DateOnly function demo where date only portions of Dt variables are needed

Content:
Tuning:
SQL Server 7.x and later
TupleDifferencesAndEquivalentsBetweenSetsDisambiguation


Content:
General SQL Script
dba3_Monthly_DateTimeDemarcations


Content:
General SQL Script
dba3_dbmail_Troubleshoot


Content:
General SQL Script
Removal of User Login from ALL databases and SQL Server
Need to remove a login\user from SQL server and all databases? This script will look for the id in all the databases and generate a script to remove it from all databases and SQL server. Input - it the login\user name. Output - Copy/Paste/Execute

Content:
Administrative:
SQL Server 2000 and later
dba3_GrantLoginUserAccessInDb_DataReaderRoleForUserDatabases


Content:
General SQL Script
RANK(), PARTITION, and CTE Demo
A demonstration piece of code allowing you to see how to use RANK(), PARTITION, and CTE's to solve a business need.

Content:
Development:
SQL Server 2005 only
dba3_MemoryPressure_diagnostics


Content:
General SQL Script
Resource Memory Available External
Use to help determine memory leaks and use by OS.

Content:
Tuning:
SQL Server 2005 only
dba3_sp_RestoreDump_ConcurrentVersionInstall_2k8


Content:
General SQL Script
dba3_DBMS_Reporting_ReportingConfiguration


Content:
General SQL Script
dba3_sp_Generate_Select_NoLock_FQN_View_DDL


Content:
General SQL Script
dba3_sp_Generate_Select_NoLock_FQN_View_DDL


Content:
General SQL Script
dba3_Remote_DAC_ss2k5


Content:
General SQL Script
dba3_Create_SpaceUsedDetail_2k5_AND_SpaceUsed_2k5_ForAllDatabases


Content:
General SQL Script
dba3_FileGroup_Usage_Demo_2k5_WithObjectDistViews


Content:
General SQL Script
dba3_DBMS_DataLogBackupDirectoryDatabaseMailProfile_Standards


Content:
General SQL Script
12345678910...