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
|
Development:
SQL Server 7.x only
|
5/6/2009
|
Time_Master_tbl_ForcedParameterization
This Script is the Step 1 for creating a table in order to see the impact of Forced Parameterization
|
Development:
SQL Server 7.x only
|
5/6/2009
|
Permissions Scripts plus some......
Will give a listing of all permissions on database objects.
|
Administrative:
SQL Server 6.x and later
|
4/27/2009
|
dba3_sys_IndicesAudit
Audit indices ss2k5 and beyond only
|
Administrative:
SQL Server 2005 only
|
4/3/2009
|
dba3_DeleteTopByIncrements_demo
Requires TOP (variable) support of 2k5 & later - demo script
|
Administrative:
SQL Server 2000 and later
|
4/2/2009
|
dba3_fx_DateOnly
DateOnly function demo where date only portions of Dt variables are needed
|
Tuning:
SQL Server 7.x and later
|
3/31/2009
|
TupleDifferencesAndEquivalentsBetweenSetsDisambiguation
|
General SQL Script
|
12/5/2008
|
dba3_Monthly_DateTimeDemarcations
|
General SQL Script
|
12/4/2008
|
dba3_dbmail_Troubleshoot
|
General SQL Script
|
11/24/2008
|
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
|
Administrative:
SQL Server 2000 and later
|
11/24/2008
|
dba3_GrantLoginUserAccessInDb_DataReaderRoleForUserDatabases
|
General SQL Script
|
10/28/2008
|
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.
|
Development:
SQL Server 2005 only
|
10/22/2008
|
dba3_MemoryPressure_diagnostics
|
General SQL Script
|
10/17/2008
|
Resource Memory Available External
Use to help determine memory leaks and use by OS.
|
Tuning:
SQL Server 2005 only
|
9/13/2008
|
dba3_sp_RestoreDump_ConcurrentVersionInstall_2k8
|
General SQL Script
|
8/22/2008
|
dba3_DBMS_Reporting_ReportingConfiguration
|
General SQL Script
|
8/20/2008
|
dba3_sp_Generate_Select_NoLock_FQN_View_DDL
|
General SQL Script
|
8/20/2008
|
dba3_sp_Generate_Select_NoLock_FQN_View_DDL
|
General SQL Script
|
8/19/2008
|
dba3_Remote_DAC_ss2k5
|
General SQL Script
|
8/18/2008
|
dba3_Create_SpaceUsedDetail_2k5_AND_SpaceUsed_2k5_ForAllDatabases
|
General SQL Script
|
8/12/2008
|
dba3_FileGroup_Usage_Demo_2k5_WithObjectDistViews
|
General SQL Script
|
8/12/2008
|
dba3_DBMS_DataLogBackupDirectoryDatabaseMailProfile_Standards
|
General SQL Script
|
8/8/2008
|
dba3_ss2k58_ProductLevel_And_Version
|
Administrative:
SQL Server 2005 only
|
8/8/2008
|
dba3_Severity_NN_DBMS_Operator_Alert
|
General SQL Script
|
8/4/2008
|
SQL Agent Job History Graph
|
Administrative:
SQL Server 2000 and later
|
7/10/2008
|
dba3_NaturalAndLeftRightJoinDemo
demo from training exercise
|
General SQL Script
|
6/13/2008
|
dba3_NullTokenCountsForNullableColumns
updated for ss2k5 (Rownumber function)
|
General SQL Script
|
5/19/2008
|
dba3_dsquery_setspn
|
General SQL Script
|
5/8/2008
|
dba3_diskpart
|
General SQL Script
|
5/8/2008
|
dba3_LoadRaisErrorDemo
|
General SQL Script
|
4/30/2008
|
|
