| Check if objects support point-in-time recovery (SS7.0 only) |
SQL Server 7.x only |
Read More |
| Create Database for point-in-time recovery (SS7.0 only) |
SQL Server 7.x only |
Read More |
| Drop all indices and statistics (script) |
SQL Server 7.x only |
Read More |
| sp_rename_logical_filename.sql |
SQL Server 7.x only |
Read More |
| dba3_Shrinking_MsSqlServer7_0_Logs_demo |
SQL Server 7.x only |
Read More |
| Shrink a Log File |
SQL Server 7.x only |
Read More |
| Search A Databases SP's for Specific Information |
SQL Server 7.x and later |
Read More |
| Backup and GZip Databases |
SQL Server 7.x and later |
Read More |
| Set all Stored Procedures in a DB to recompile on next use |
SQL Server 7.x and later |
Read More |
| Removing IDENTITY column property |
SQL Server 7.x and later |
Read More |
| TSQL File Size Check and Alert |
SQL Server 7.x and later |
Read More |
| Cardinality of columns |
SQL Server 7.x and later |
Read More |
| Using SQL DML to Script HTML Markup |
SQL Server 7.x and later |
Read More |
| JDC - Copy Roles for One User and Grant to another User |
SQL Server 7.x and later |
Read More |
| admin db - can SQL Agebt job be safely started |
SQL Server 7.x and later |
Read More |
| Collect Free Disk Space |
SQL Server 7.x and later |
Read More |
| Collect Table Sizes |
SQL Server 7.x and later |
Read More |
| Create a DB Size Trending report |
SQL Server 7.x and later |
Read More |
| Person's Current Age, Birthdate to Age |
SQL Server 7.x and later |
Read More |
| Stored Procedure Return Variable |
SQL Server 7.x and later |
Read More |
| UDF: fn_LastMomentOfDay |
SQL Server 7.x and later |
Read More |
| UDF: fn_FirstMomentOfDay |
SQL Server 7.x and later |
Read More |
| dba3_DBCC_Ind_IndexDefrag |
SQL Server 7.x and later |
Read More |
| dba3_DB_MostRecentDumps_IDT_demo |
SQL Server 7.x and later |
Read More |
| dba3_DB_MostRecentDumps_IDT_demo |
SQL Server 7.x and later |
Read More |
| spTableToVbClass |
SQL Server 7.x and later |
Read More |
| search syscomments for 'word' references in objects |
SQL Server 7.x and later |
Read More |
| dba3_DynamicSql_Demo |
SQL Server 7.x and later |
Read More |
| URL Encoder |
SQL Server 7.x and later |
Read More |
| URL Decoder |
SQL Server 7.x and later |
Read More |
| List Database ID |
SQL Server 7.x and later |
Read More |
| Rebuild Indexes On All Databases |
SQL Server 7.x and later |
Read More |
| CheckErrorLog |
SQL Server 7.x and later |
Read More |
| email check constraint |
SQL Server 7.x and later |
Read More |
| Article - sput_ReorganizeDB |
SQL Server 7.x and later |
Read More |
| Article - Maintenance Create Schema |
SQL Server 7.x and later |
Read More |
| Split a string based on delimiter character |
SQL Server 7.x and later |
Read More |
| Auto CRUD Procedure Generator Script |
SQL Server 7.x and later |
Read More |
| list_userTablePermissions |
SQL Server 7.x and later |
Read More |
| Flag only the duplicate Rows |
SQL Server 7.x and later |
Read More |
| stringparsing methods and variants |
SQL Server 7.x and later |
Read More |
| dba3_regReadregWrite |
SQL Server 7.x and later |
Read More |
| dba3_FileGroup_Names_of_DB_Objects_demo |
SQL Server 7.x and later |
Read More |
| dba3_ResultSet_of_Objects_NotOwnedBy_dbo_demo |
SQL Server 7.x and later |
Read More |
| Wscript / VBScript to create file directory of tables views and stored procedures for a server |
SQL Server 7.x and later |
Read More |
| Object listing by name |
SQL Server 7.x and later |
Read More |
| dba3_Login_User_Role_SecurityProcedures |
SQL Server 7.x and later |
Read More |
| dba3_View_Stats_Object_Stats_Date_Information_demo |
SQL Server 7.x and later |
Read More |
| dba3_Identity_Value_RollBack_Skipping_demo |
SQL Server 7.x and later |
Read More |
| dba3_ResultSet_of_Objects_and_dboos_demo |
SQL Server 7.x and later |
Read More |
| script to return non-SA owners of objects |
SQL Server 7.x and later |
Read More |
| DataAsInsCommand |
SQL Server 7.x and later |
Read More |
| ExportToExcel |
SQL Server 7.x and later |
Read More |
| ExportToWord |
SQL Server 7.x and later |
Read More |
| defragment_indexes |
SQL Server 7.x and later |
Read More |
| RebuildAllIndexes |
SQL Server 7.x and later |
Read More |
| CheckAllTables |
SQL Server 7.x and later |
Read More |
| ForEachUserTable |
SQL Server 7.x and later |
Read More |
| sp_lock2 |
SQL Server 7.x and later |
Read More |
| replace_substring |
SQL Server 7.x and later |
Read More |
| ChangeAllObjOwner |
SQL Server 7.x and later |
Read More |
| GetObjCreatedBeforeDate |
SQL Server 7.x and later |
Read More |
| SetTbColValues |
SQL Server 7.x and later |
Read More |
| GenerateScript |
SQL Server 7.x and later |
Read More |
| GetTbColList |
SQL Server 7.x and later |
Read More |
| GetTbColValues |
SQL Server 7.x and later |
Read More |
| GetSPTrigValues |
SQL Server 7.x and later |
Read More |
| GetAlltblRowsSize |
SQL Server 7.x and later |
Read More |
| GetObjNameList |
SQL Server 7.x and later |
Read More |
| GetObjCreateDate |
SQL Server 7.x and later |
Read More |
| convert_ident_to_guid.sql |
SQL Server 7.x and later |
Read More |
| get_week_ending.sql |
SQL Server 7.x and later |
Read More |
| alter_list_of_tables.sql |
SQL Server 7.x and later |
Read More |
| get_table_rowcounts.sql |
SQL Server 7.x and later |
Read More |
| sync_dbids.sql |
SQL Server 7.x and later |
Read More |
| cmdshell_dtsrun.sql |
SQL Server 7.x and later |
Read More |
| Determine when the last backup occurred |
SQL Server 7.x and later |
Read More |
| fnJulianToGregorian |
SQL Server 7.x and later |
Read More |
| check_schema_differences.sql |
SQL Server 7.x and later |
Read More |
| Foriegn Key Sequence Report |
SQL Server 7.x and later |
Read More |
| CommonDateTimeConversionStyleSamples.sql |
SQL Server 7.x and later |
Read More |
| dba3_Column_And_Table_Constraints_And_ColumnDefaults.sql |
SQL Server 7.x and later |
Read More |
| dba3_Add_Column_To_Existing_Table_With_Default_demo |
SQL Server 7.x and later |
Read More |
| Identity reset (reseed) |
SQL Server 7.x and later |
Read More |
| dba3_DBCC_ShrinkFile_Demo.sql |
SQL Server 7.x and later |
Read More |
| dba3_ArabicCollations_demo |
SQL Server 7.x and later |
Read More |
| sp_quick_count |
SQL Server 7.x and later |
Read More |
| Rename SQL servername to Net servername |
SQL Server 7.x and later |
Read More |
| Change owner to DBO on all objects |
SQL Server 7.x and later |
Read More |
| sp_SQL_Up_Time |
SQL Server 7.x and later |
Read More |
| sp_SQL_Server_Version |
SQL Server 7.x and later |
Read More |
| change dbowner to sa on all db's |
SQL Server 7.x and later |
Read More |
| sp_reindex_below |
SQL Server 7.x and later |
Read More |
| sp_find_columns |
SQL Server 7.x and later |
Read More |
| sp_my_renamedb |
SQL Server 7.x and later |
Read More |
| osp_check_backups |
SQL Server 7.x and later |
Read More |
| Windows script to copy script to multiple servers |
SQL Server 7.x and later |
Read More |
| Trigger: checkForJobFail |
SQL Server 7.x and later |
Read More |
| Job and Alerts for Severe Errors 20-25 |
SQL Server 7.x and later |
Read More |
| sp_MY_sqlmaint_dbcc |
SQL Server 7.x and later |
Read More |
| sp_MY_sqlmaint_rndx |
SQL Server 7.x and later |
Read More |
| sp_MY_sqlmaint_stat |
SQL Server 7.x and later |
Read More |
| sp_MY_sqlmaint |
SQL Server 7.x and later |
Read More |
| sp_MY_backup |
SQL Server 7.x and later |
Read More |
| monitor DB blocking |
SQL Server 7.x and later |
Read More |
| dba3_DataLength_And_TableColumnWidth_Demo |
SQL Server 7.x and later |
Read More |
| dba3_BeforeAndAfterRecordCounts_Demo |
SQL Server 7.x and later |
Read More |
| dba3_Alter_DataBase_ToSecureDbForAdministrativeUse_Demo |
SQL Server 7.x and later |
Read More |
| dba3_Using_xp_sqlagent_proxy_account_Demo |
SQL Server 7.x and later |
Read More |
| dba3_fn_SimpleParseString_Demo |
SQL Server 7.x and later |
Read More |
| dba3_view_UsingACaseStatement_Demo |
SQL Server 7.x and later |
Read More |
| Last Day of a Month |
SQL Server 7.x and later |
Read More |
| properCase & whitespace trimmer sp version |
SQL Server 7.x and later |
Read More |
| Generate Autofixlogins |
SQL Server 7.x and later |
Read More |
| dba3_REBUILD_LOG |
SQL Server 7.x and later |
Read More |
| dba3_MS_ScriptsToTransferLoginsAndPasswords |
SQL Server 7.x and later |
Read More |
| dba3_HowToUse_DynamicSql_ToSelectASpecificColumn_Demo |
SQL Server 7.x and later |
Read More |
| patCount - how to count # of occurences of a single char or pattern |
SQL Server 7.x and later |
Read More |
| Audit - Database Details |
SQL Server 7.x and later |
Read More |
| Audit - Which tables have Primary Keys |
SQL Server 7.x and later |
Read More |
| Audit - Which tables have an index |
SQL Server 7.x and later |
Read More |
| Audit - Which tables have a clustering index |
SQL Server 7.x and later |
Read More |
| Force Shrink of Database Log File |
SQL Server 7.x and later |
Read More |
| Genearete Grants |
SQL Server 7.x and later |
Read More |
| Find out space used in all db's (oneliner) |
SQL Server 7.x and later |
Read More |
| getNextID - roll your own table based id-counter |
SQL Server 7.x and later |
Read More |
| How to treat an IP-string as integers ( ipString2Int ) |
SQL Server 7.x and later |
Read More |
| List PK presence in all tables (ANSI INFORMATION_SCHEMA version) |
SQL Server 7.x and later |
Read More |
| dba3_ImplicitConversionIssues_Demo |
SQL Server 7.x and later |
Read More |
| SQL Litespeed Backup Script |
SQL Server 7.x and later |
Read More |
| dba3_Using_If_and_Exists_forRowExistanceTesting_Demo |
SQL Server 7.x and later |
Read More |
| dba3_sp_TableIdentityColumns_WithIdentCurrent_Article |
SQL Server 7.x and later |
Read More |
| dba3_sp_TableIdentityColumns_Article |
SQL Server 7.x and later |
Read More |
| dba3_sp_TableIdentityColumnMetaData_Article |
SQL Server 7.x and later |
Read More |
| Show index information for all tables in a database |
SQL Server 7.x and later |
Read More |
| dba3_SingleProd_For_EachFamily_For_GivenType_CorrSubQry_Demo |
SQL Server 7.x and later |
Read More |
| dba3_SqlServerDBInfoDocumentor_Demo |
SQL Server 7.x and later |
Read More |
| dba3_SelectAssimilatingDataForEachDayInDateSpan_Demo |
SQL Server 7.x and later |
Read More |
| sp__defrag.sql |
SQL Server 7.x and later |
Read More |
| sp_reindex.sql |
SQL Server 7.x and later |
Read More |
| sp__dbcc.sql |
SQL Server 7.x and later |
Read More |
| sp__updatestats.sql |
SQL Server 7.x and later |
Read More |
| sp__loaddata.sql |
SQL Server 7.x and later |
Read More |
| find_fkeys.sql |
SQL Server 7.x and later |
Read More |
| find_defaults.sql |
SQL Server 7.x and later |
Read More |
| sp__agedata.sql |
SQL Server 7.x and later |
Read More |
| sp__noprimarykeys.sql |
SQL Server 7.x and later |
Read More |
| enable / reenable FK constraint behaviour demo |
SQL Server 7.x and later |
Read More |
| findColumns |
SQL Server 7.x and later |
Read More |
| How to change / alter tempdb |
SQL Server 7.x and later |
Read More |
| Generate bcp out script |
SQL Server 7.x and later |
Read More |
| How to select n random rows |
SQL Server 7.x and later |
Read More |
| Audit Trail Creator |
SQL Server 7.x and later |
Read More |
| DB Scripter |
SQL Server 7.x and later |
Read More |
| Script _Out_Data |
SQL Server 7.x and later |
Read More |
| View all settings for all databases on a server |
SQL Server 7.x and later |
Read More |
| View input buffers for all SPIDs |
SQL Server 7.x and later |
Read More |
| CheckAllTables - dbcc on all tables |
SQL Server 7.x and later |
Read More |
| Snipped to convert hex to INT |
SQL Server 7.x and later |
Read More |
| sp_RemoveInvalidUsers |
SQL Server 7.x and later |
Read More |
| sp_ShowInformation |
SQL Server 7.x and later |
Read More |
| sp_export_to_excel |
SQL Server 7.x and later |
Read More |
| sp_GetAlltblRowsSize |
SQL Server 7.x and later |
Read More |
| sp_GetObjCreateDate |
SQL Server 7.x and later |
Read More |
| GetSpTrigValues |
SQL Server 7.x and later |
Read More |
| GetTbColList |
SQL Server 7.x and later |
Read More |
| GetTbColValues |
SQL Server 7.x and later |
Read More |
| index-property |
SQL Server 7.x and later |
Read More |
| Reduce Transaction log |
SQL Server 7.x and later |
Read More |
| Check free space on drive |
SQL Server 7.x and later |
Read More |
| dfrag SQL |
SQL Server 7.x and later |
Read More |
| Rowcounts |
SQL Server 7.x and later |
Read More |
| Estimate Disk Space |
SQL Server 7.x and later |
Read More |
| GetTableSize |
SQL Server 7.x and later |
Read More |
| Check Free Space on Server |
SQL Server 7.x and later |
Read More |
| Move logins |
SQL Server 7.x and later |
Read More |
| Check Last Backup Date |
SQL Server 7.x and later |
Read More |
| Calculate total rows and disk space |
SQL Server 7.x and later |
Read More |
| View Active dbprocs |
SQL Server 7.x and later |
Read More |
| Automate sp_helpfile execution |
SQL Server 7.x and later |
Read More |
| dba3_GetDateFrom_Year_WeekOfYear_DayOfWeek_Demo |
SQL Server 7.x and later |
Read More |
| unixtime to readable date/time |
SQL Server 7.x and later |
Read More |
| instpubs.sql |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0105_DocumentTestAndValidate_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0100_DocumentTestAndValidate_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0090_unImplement_Materialized_View_Invoices_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0080_Implement_Materialized_View_Invoices_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0075_Materialized_Object_Refresh_Process_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0070_Materialized_Object_Refresh_Process_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0060_Alter_Invoices_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0050_Materialized_View_Invoices_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0040_Materialized_Object_Invoices_Article |
SQL Server 7.x and later |
Read More |
| dba3_NorthWind_0030_Invoices_Original_Article |
SQL Server 7.x and later |
Read More |
| showallpk |
SQL Server 7.x and later |
Read More |
| sp_show_huge_tables |
SQL Server 7.x and later |
Read More |
| Send SMTP mail with CDONTS |
SQL Server 7.x and later |
Read More |
| sp_random |
SQL Server 7.x and later |
Read More |
| RebuildAllIndexes |
SQL Server 7.x and later |
Read More |
| Space estimation script |
SQL Server 6.x only |
Read More |
| check_table_index_frag.sql |
SQL Server 6.x only |
Read More |
| defrag -- another way |
SQL Server 6.x and later |
Read More |
| dba3_BCP_Out_And_In_Demo |
SQL Server 6.x and later |
Read More |
| How to strip selected chars from a string (numerics or alpha) |
SQL Server 6.x and later |
Read More |
| dba3_DOB_InYearsAndMonths_demo |
SQL Server 6.x and later |
Read More |
| dba3_DateTimePrecision_Article |
SQL Server 6.x and later |
Read More |
| dba3_SmallDateTimePrecision_Article |
SQL Server 6.x and later |
Read More |
| dba3_MonthName_For_TinyInt_demo |
SQL Server 6.x and later |
Read More |
| dba3_Grouping_Data_Occurances_demo |
SQL Server 6.x and later |
Read More |
| pr_lookattablenulls |
SQL Server 6.x and later |
Read More |
| dba3_read_DirectoryFileNames_demo |
SQL Server 6.x and later |
Read More |
| dba3_SpecifyRandNumberSize_via_Power |
SQL Server 6.x and later |
Read More |
| dba3_Article_NullsPlainAndSimple |
SQL Server 6.x and later |
Read More |
| NEXT_DAY |
SQL Server 6.x and later |
Read More |
| dba3_TriggerDemo_SystemUser_HostName_GetDate_Audit |
SQL Server 6.x and later |
Read More |
| dba3_Using_Exists_AndOtherMethodsforObjectExistanceTesting_Demo |
SQL Server 6.x and later |
Read More |
| sp__backup.sql |
SQL Server 6.x and later |
Read More |
| sp__scramblepassword.sql |
SQL Server 6.x and later |
Read More |
| dba3_CreateViewFromTwoDifferentDatabasesOnSameServer_Demo |
SQL Server 6.x and later |
Read More |
| T-SQL SSN validator (for swedish personnummer) |
SQL Server 6.x and later |
Read More |
| T-SQL SSN control digit calculator (for swedish personnummer) |
SQL Server 6.x and later |
Read More |
| How to use LIKE and wildcard ranges |
SQL Server 6.x and later |
Read More |
| Q&D rowcounter for all user tables in current db |
SQL Server 6.x and later |
Read More |
| Save / append logfile (ASCII) |
SQL Server 6.x and later |
Read More |
| RAID comparison table |
SQL Server 6.x and later |
Read More |
| How to find months start and enddates (T-SQL) |
SQL Server 6.x and later |
Read More |
| Determine current age |
SQL Server 6.x and later |
Read More |
| drop_keys.sql |
SQL Server 6.x and later |
Read More |
| admin db - list tables on server with no data |
SQL Server 6.x and later |
Read More |
| sp_paddecimal |
SQL Server 6.x and later |
Read More |
| dba3_BcpOut_tsql_XP_CmdShell_Demo |
SQL Server 6.x and later |
Read More |
| dba3_BcpOut_(Temp_Tables)_tsql_XP_CmdShell_Demo |
SQL Server 6.x and later |
Read More |
| dba3_hr_Set_SuperSets_Article |
SQL Server 6.x and later |
Read More |
| dba3_hr_Set_SubSets_Article |
SQL Server 6.x and later |
Read More |
| dba3_Create_Maps_Sets_Article |
SQL Server 6.x and later |
Read More |
| dba3_UseFullyQualifiedObjectNames_ToCallStoredProcedures_InOtherDbs_Demo |
SQL Server 6.x and later |
Read More |
| dba3_DeadLock_Connection_Demo_ay |
SQL Server 6.x and later |
Read More |
| dba3_DeadLock_Connection_Demo_son |
SQL Server 6.x and later |
Read More |
| Convert date string to DCOM compatible datetime result. |
SQL Server 6.x and later |
Read More |
| How to set low/high groupings by size parameter |
SQL Server 6.x and later |
Read More |
| getWeekDay |
SQL Server 6.x and later |
Read More |
| Calculating Yesterday Today and Tomorrow |
SQL Server 6.x and later |
Read More |
| dba3_LeftRightAndFullJoin_Demo |
SQL Server 6.x and later |
Read More |
| dba3_0To20ComputedTimeOnlyValueAndFullDateTimeOffset_demo |
SQL Server 6.x and later |
Read More |
| dba3_ConditionalInsertNvarcharDataIntoNumericColumns_demo |
SQL Server 6.x and later |
Read More |
| dba3_Beginners_InsertFromAnotherTable_Demo |
SQL Server 6.x and later |
Read More |
| dba3_DateTime_vs_DefaultLoginLanguage_vs_Set_DateFormat |
SQL Server 6.x and later |
Read More |
| dba3_prc_BusinessDaysInRangeByIteration_Article |
SQL Server 6.x and later |
Read More |
| dba3_SecondsToDaysHoursMinutes_demo |
SQL Server 6.x and later |
Read More |
| Start-End Weekdays |
SQL Server 6.x and later |
Read More |
| dba3_ValueInsertionScripts_demo |
SQL Server 4.2 and later |
Read More |
| dba3_prc_BusinessDaysInRangeByComputation_Article |
SQL Server 4.2 and later |
Read More |
| dba3_prc_DaysWeeksYearsInRange_Article |
SQL Server 4.2 and later |
Read More |
| dba3_prc_MonthBeginAndEndDateTime_Article |
SQL Server 4.2 and later |
Read More |
| dba3_modulus_Article |
SQL Server 4.2 and later |
Read More |
| dba3_prc_IsLeapYear_Article |
SQL Server 4.2 and later |
Read More |
| Create Entity Attribute Values |
SQL Server 4.2 and later |
Read More |
| dba3_IndexTuning_IndexUsage |
SQL Server 4.2 and later |
Read More |
| dba3_SelectInToNewTable_Demo |
SQL Server 4.2 and later |
Read More |
| LAST_DAY |
SQL Server 4.2 and later |
Read More |
| Initcap |
SQL Server 4.2 and later |
Read More |
| RPAD |
SQL Server 4.2 and later |
Read More |
| TRANSLATE |
SQL Server 4.2 and later |
Read More |
| INSTR Function |
SQL Server 4.2 and later |
Read More |
| LPAD Function |
SQL Server 4.2 and later |
Read More |
| fnLTRIM (LTRIM Extension) |
SQL Server 4.2 and later |
Read More |
| fnRTRIM (RTRIM Extension) |
SQL Server 4.2 and later |
Read More |
| dba3_FindingDuplicateAndPartialDuplicateRows_demo |
SQL Server 4.2 and later |
Read More |
| SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization |
SQL Server 2005 only |
Read More |
| 2005 Online Index Rebuild using DMV |
SQL Server 2005 only |
Read More |
| 2005 Database Monitor RDL for Management Studio |
SQL Server 2005 only |
Read More |
| 2005 Blocking Locks RDL for Management Studio |
SQL Server 2005 only |
Read More |
| AutomaticMechanismsCanBeSurprising.sql |
SQL Server 2005 only |
Read More |
| dba3_sys_ProceduresInDBMSCacheViewScript |
SQL Server 2005 only |
Read More |
| dba3_TablesWithNoPrimaryKeys |
SQL Server 2005 only |
Read More |
| dba3_TablePurgeScriptGenerator |
SQL Server 2005 only |
Read More |
| dba3_AttachCreateMsSqlSystemResourceDatabaseCopy |
SQL Server 2005 only |
Read More |
| dba3_ss2k5_ProductLevel_And_Version |
SQL Server 2005 only |
Read More |
| dba3_Create_SpaceUsedDetail_2k5_AND_SpaceUsed_2k5_ForAllDatabases |
SQL Server 2005 only |
Read More |
| dba3_Remote_DAC_ss2k5 |
SQL Server 2005 only |
Read More |
| dba3_sp_RestoreDump_ConcurrentVersionInstall_2k8 |
SQL Server 2005 only |
Read More |
| dba3_TryCatchErrorHandling_demo |
SQL Server 2005 only |
Read More |
| List of all open connections on SQL 2005 SERVER |
SQL Server 2005 only |
Read More |
| List all Active Sessions on a SQL Server 2005 BOX |
SQL Server 2005 only |
Read More |
| Multiple CTE In side a Single View |
SQL Server 2005 only |
Read More |
| Parent Child recursive Query |
SQL Server 2005 only |
Read More |
| Database Snapshot SP |
SQL Server 2005 only |
Read More |
| dba3_LOGSHIPPING_TABLE_CONTENTS |
SQL Server 2000 only |
Read More |
| dba3_move_SqlServer2K_TempDB_demo |
SQL Server 2000 only |
Read More |
| sp_helpjobschedules |
SQL Server 2000 only |
Read More |
| Force SQL Error Log Switch |
SQL Server 2000 only |
Read More |
| Table Size Listing |
SQL Server 2000 only |
Read More |
| sp_scripttable |
SQL Server 2000 only |
Read More |
| Find Constraints That Were Not Added "With Check" |
SQL Server 2000 only |
Read More |
| DBFilesWithLowFreeSpace |
SQL Server 2000 only |
Read More |
| sample_transpose |
SQL Server 2000 only |
Read More |
| DeleteLoginsWithNoUser |
SQL Server 2000 only |
Read More |
| Audit - User DB Roles by Database |
SQL Server 2000 only |
Read More |
| fn_TablifyString |
SQL Server 2000 only |
Read More |
| fn_TablifyString2 |
SQL Server 2000 only |
Read More |
| fn_LowerCaseCount |
SQL Server 2000 only |
Read More |
| fn_UpperCaseCount |
SQL Server 2000 only |
Read More |
| fn_NumCount |
SQL Server 2000 only |
Read More |
| fn_BracketedWords |
SQL Server 2000 only |
Read More |
| Generate Scripts to Disable and Enable Constraints |
SQL Server 2000 only |
Read More |
| Recompile an entire database |
SQL Server 2000 only |
Read More |
| FindBlocking |
SQL Server 2000 only |
Read More |
| CheckNewDBStructure |
SQL Server 2000 only |
Read More |
| UDF Remove leading Chars, I.E '00200P03" Removes leading 0's only |
SQL Server 2000 only |
Read More |
| List Primary Keys for all tables within a DB |
SQL Server 2000 only |
Read More |
| Show requested table schema |
SQL Server 2000 only |
Read More |
| sp_DisplayDBTriggers |
SQL Server 2000 only |
Read More |
| Database Manager |
SQL Server 2000 only |
Read More |
| Trace from Script (basic) |
SQL Server 2000 only |
Read More |
| admin db - Index (fragmentation) Maintenance for Log Shipping |
SQL Server 2000 only |
Read More |
| Rename Database Without Shutting Down |
SQL Server 2000 only |
Read More |
| dba3_view_sp_spaceused_data |
SQL Server 2000 only |
Read More |
| Disk Space checker |
SQL Server 2000 only |
Read More |
| admin db - Heavy Duty LiteSpeed Log Shipping |
SQL Server 2000 only |
Read More |
| Run a job from all existing SQL Agent Alerts |
SQL Server 2000 only |
Read More |
| admin db - Free Space Monitoring Tool stored procedures and job |
SQL Server 2000 only |
Read More |
| admin db - Track Procedures In Use on a SQL Server |
SQL Server 2000 only |
Read More |
| admin dts - Free Space Monitoring Tool ActiveX Script Task |
SQL Server 2000 only |
Read More |
| admin db - create linked servers with standard config |
SQL Server 2000 only |
Read More |
| admin db - force users out of a database |
SQL Server 2000 only |
Read More |
| admin db - identify and track tables with no clustered indexes |
SQL Server 2000 only |
Read More |
| admin db - automated block monitoring and tracking |
SQL Server 2000 only |
Read More |
| admin db - number of objects on server monitor of tracking |
SQL Server 2000 only |
Read More |
| admin db - index (fragmentation) maintenance |
SQL Server 2000 only |
Read More |
| admin db - identify largest tables on the server |
SQL Server 2000 only |
Read More |
| admin db - automated log disk space management |
SQL Server 2000 only |
Read More |
| admin db - find user objects where they don't belong |
SQL Server 2000 only |
Read More |
| admin script - show all fixed database role members |
SQL Server 2000 only |
Read More |
| admin script - move log files to a different drive |
SQL Server 2000 only |
Read More |
| admin db - table function to get Agent job status |
SQL Server 2000 only |
Read More |
| admin db - add identity primary keys to legacy tables |
SQL Server 2000 only |
Read More |
| admin db - meaningful Agent job notification |
SQL Server 2000 only |
Read More |
| admin script - change the SID of a login without loss of security settings |
SQL Server 2000 only |
Read More |
| admin db - sp_monitor history and historical performance report |
SQL Server 2000 only |
Read More |
| admin dts - Backup Primary Restore Warm spare (SQLLitespeed or native) |
SQL Server 2000 only |
Read More |
| admin dts - Copy procedures from Database A to Database B |
SQL Server 2000 only |
Read More |
| admin db - current activity quick and clean |
SQL Server 2000 only |
Read More |
| List Jobs Time, Duration, Date |
SQL Server 2000 only |
Read More |
| Parse separated string values into a temp table |
SQL Server 2000 and later |
Read More |
| dba3_fn_ParseAndCommaFormatNumerics_Demo |
SQL Server 2000 and later |
Read More |
| dba3_FirstLastTriggerOrderInformationIsIn_SysObjects_Status_Demo |
SQL Server 2000 and later |
Read More |
| dba3_fn_TableIdentityColumns_WithIdentCurrent_Article |
SQL Server 2000 and later |
Read More |
| dba3_fn_TableIdentityColumns_Article |
SQL Server 2000 and later |
Read More |
| fn_properCase function & whitespace trimmer |
SQL Server 2000 and later |
Read More |
| fn_listfind() - find ordinal position of text in a delimited list |
SQL Server 2000 and later |
Read More |
| fn_listlen() - get the number of elements in a delimited list |
SQL Server 2000 and later |
Read More |
| fn_listgetat() - get text from a delimited list |
SQL Server 2000 and later |
Read More |
| Find the Nth Occurrence of a Character in a String |
SQL Server 2000 and later |
Read More |
| dba3_UserRoleBased_FlowControl_ResultSetControl_Demo |
SQL Server 2000 and later |
Read More |
| dba3_test_IS_Member_StoredProcedure_A_UserRoleBased_FlowControl_Demo |
SQL Server 2000 and later |
Read More |
| dba3_fn_TestFlowControl_AFlowControlFunction_Demo |
SQL Server 2000 and later |
Read More |
| dba3_Add_Drop_IdentityColumnToTable_Demo |
SQL Server 2000 and later |
Read More |
| dba3_Alter_ColumnInTable_Demo |
SQL Server 2000 and later |
Read More |
| fn_decimalToBitpattern |
SQL Server 2000 and later |
Read More |
| fn_bitpatternToDecimal |
SQL Server 2000 and later |
Read More |
| fn_ipAddressProperties |
SQL Server 2000 and later |
Read More |
| Get current version and service pack level |
SQL Server 2000 and later |
Read More |
| dba3_MedicalDB_UnImplement_Article |
SQL Server 2000 and later |
Read More |
| dba3_MedicalDB_TestScriptForLogins_Article |
SQL Server 2000 and later |
Read More |
| dba3_MedicalDB_SecurityRolesAndUserLoginsSetup_Article |
SQL Server 2000 and later |
Read More |
| dba3_MedicalDB_SecurityRolesAndPermissions_Article |
SQL Server 2000 and later |
Read More |
| dba3_MedicalDB_SecurityObjectsAndData_Article |
SQL Server 2000 and later |
Read More |
| dba3_MedicalDB_Schema_Article |
SQL Server 2000 and later |
Read More |
| sp_selectAll |
SQL Server 2000 and later |
Read More |
| dba3_fn_Set_SuperSets_Article |
SQL Server 2000 and later |
Read More |
| dba3_fn_Set_SubSets_Article |
SQL Server 2000 and later |
Read More |
| ParseDate Function |
SQL Server 2000 and later |
Read More |
| Audit - Stored Procedure Permissions |
SQL Server 2000 and later |
Read More |
| SPLIT Function |
SQL Server 2000 and later |
Read More |
| UDF - Starting day of the previous month |
SQL Server 2000 and later |
Read More |
| UDF - Ending day of the previous month |
SQL Server 2000 and later |
Read More |
| UDF - Phone Parser |
SQL Server 2000 and later |
Read More |
| UDF - Calc distance |
SQL Server 2000 and later |
Read More |
| dba3_IsNumeric_Issues_Demo |
SQL Server 2000 and later |
Read More |
| DateOnly - Strip Time |
SQL Server 2000 and later |
Read More |
| dba3_0080_HierarchicalDB_UnImplement_Article |
SQL Server 2000 and later |
Read More |
| dba3_0070_hr_Set_InsertNewSet_Article |
SQL Server 2000 and later |
Read More |
| dba3_0060_hr_Set_MoveSets_Article |
SQL Server 2000 and later |
Read More |
| dba3_0050_hr_Set_ExciseSets_Article |
SQL Server 2000 and later |
Read More |
| dba3_0040_hr_Set_DropSetIncludeSubSets_Article |
SQL Server 2000 and later |
Read More |
| dba3_0030_hr_Set_SuperSets_WithOrder_Article |
SQL Server 2000 and later |
Read More |
| dba3_0020_hr_Set_SubSets_WithSize_Article |
SQL Server 2000 and later |
Read More |
| dba3_0010_HierarchicalDB_Schema_Article |
SQL Server 2000 and later |
Read More |
| Generate Autofixlogins - S2K SP3 |
SQL Server 2000 and later |
Read More |
| dba3_ObjectStatus_MsShipped_vs_NotMsShipped_Demo |
SQL Server 2000 and later |
Read More |
| Metadata get all column info with descriptions |
SQL Server 2000 and later |
Read More |
| Metadata get descriptions from all tables |
SQL Server 2000 and later |
Read More |
| dba3_Add_Identity_Column_ToExistingTable_Demo |
SQL Server 2000 and later |
Read More |
| dba3_Add_Identity_Column_ByReplacingTable_Demo |
SQL Server 2000 and later |
Read More |
| Convert alphanumeric string to numeric only result |
SQL Server 2000 and later |
Read More |
| Strip numeric chars from a string |
SQL Server 2000 and later |
Read More |
| dba3_Using_Identity()_With_TempTables_And_Tables_Demo |
SQL Server 2000 and later |
Read More |
| Local Partition Demo - Saturday Night Live |
SQL Server 2000 and later |
Read More |
| Local Partition Demo - Middle of The Road |
SQL Server 2000 and later |
Read More |
| Local Partition Demo - Life of the Party |
SQL Server 2000 and later |
Read More |
| dba3_DisplayUniqueIndicies_Demo |
SQL Server 2000 and later |
Read More |
| YukonJack - Try-Catch test script |
SQL Server 2000 and later |
Read More |
| fn_trimWhiteSpace - T-SQL whitespace trimmer function |
SQL Server 2000 and later |
Read More |
| stripChars - function to strip all but numerics from a string |
SQL Server 2000 and later |
Read More |
| dba3_fn_ParseOutNonNumerics |
SQL Server 2000 and later |
Read More |
| dba3_DisplayDefaultInformationForDatabase |
SQL Server 2000 and later |
Read More |
| fn_getRowCount.sql |
SQL Server 2000 and later |
Read More |
| GetRowCountAllTables.sql |
SQL Server 2000 and later |
Read More |
| listdatabaseinfo.sql |
SQL Server 2000 and later |
Read More |
| sp_DBA_ScriptServerDatabases |
SQL Server 2000 and later |
Read More |
| sp_TraceServer |
SQL Server 2000 and later |
Read More |
| disable_all_jobs.sql |
SQL Server 2000 and later |
Read More |
| enable_all_jobs.sql |
SQL Server 2000 and later |
Read More |
| ReConnect Users to a Database |
SQL Server 2000 and later |
Read More |
| dba3_fn_MMDDYYYY_DateTime_SN_demo |
SQL Server 2000 and later |
Read More |
| dba3_fn_MonthBeginAndEndDateTime_demo |
SQL Server 2000 and later |
Read More |
| sp_updateusagestats_alldbs.sql |
SQL Server 2000 and later |
Read More |
| db_statusinformationdump.sql |
SQL Server 2000 and later |
Read More |
| JobStatusSnapshot.sql |
SQL Server 2000 and later |
Read More |
| SQL Agent Job History Graph |
SQL Server 2000 and later |
Read More |
| dba3_DBMS_DataLogBackupDirectoryDatabaseMailProfile_Standards |
SQL Server 2000 and later |
Read More |
| admin db - script logins for migration |
SQL Server 2000 and later |
Read More |
| Collect Fragmentation Stats for Each table in AdminDB |
SQL Server 2000 and later |
Read More |
| Pad Value |
SQL Server 2000 and later |
Read More |
| round to increment |
SQL Server 2000 and later |
Read More |
| dba3_TableVariableJoin_Demo.sql |
SQL Server 2000 and later |
Read More |
| Process To Log SP usage and Times |
SQL Server 2000 and later |
Read More |
| dba3_Demo_Insert |
SQL Server 2000 and later |
Read More |
| Extract and compare date "YYMM" |
SQL Server 2000 and later |
Read More |
| Reindex all Tables in a Database |
SQL Server 2000 and later |
Read More |
| admin db - baseline and trends using sysperfinfo |
SQL Server 2000 and later |
Read More |
| admin db - db file performance baseline and trends using ::fn_virtualfilestats |
SQL Server 2000 and later |
Read More |
| fn_TableColumnExtendedprops |
SQL Server 2000 and later |
Read More |
| dba3_Implementing_and_maintaining_the_Calendar_design_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_BusinessDaysInRangeFromvBusinessCalendar_Article |
SQL Server 2000 and later |
Read More |
| dba3_ins_CalendarExclusionsFromFixedDates_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_CalendarExclusionsFixedDatesForRange_Article |
SQL Server 2000 and later |
Read More |
| dba3_ins_Calendar_Article |
SQL Server 2000 and later |
Read More |
| dba3_Calendar_Tables_and_Views_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_BusinessDaysInRangeFromSimpleCalendar_Article |
SQL Server 2000 and later |
Read More |
| dba3_SimpleCalendar_Article |
SQL Server 2000 and later |
Read More |
| dba3_ddl_CalendarSchema_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_MonthBeginAndEndDateTime_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_IsLeapYear_Demo_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_IsLeapYear_Article |
SQL Server 2000 and later |
Read More |
| Allow any user to view execution status of all jobs |
SQL Server 2000 and later |
Read More |
| dba3_fx_DaysWeeksYearsInRange_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_BusinessDaysInRangeByComputation_Article |
SQL Server 2000 and later |
Read More |
| dba3_fx_BusinessDaysInRangeByIteration_Article |
SQL Server 2000 and later |
Read More |
| Article - fn_date_format |
SQL Server 2000 and later |
Read More |
| Function to Strip All Spaces |
SQL Server 2000 and later |
Read More |
| Create Time Dimension |
SQL Server 2000 and later |
Read More |
| Create_Add_Proc |
SQL Server 2000 and later |
Read More |
| Create_Delete_Proc |
SQL Server 2000 and later |
Read More |
| Create_Update_Proc |
SQL Server 2000 and later |
Read More |
| Create_Get_Proc |
SQL Server 2000 and later |
Read More |
| Chage object owner |
SQL Server 2000 and later |
Read More |
| Generate a column of numbers. |
SQL Server 2000 and later |
Read More |
| Reordering Primary Keys |
SQL Server 2000 and later |
Read More |
| String manipulations |
SQL Server 2000 and later |
Read More |
| User-Defined string Functions Transact-SQL MS SQL Server |
SQL Server 2000 and later |
Read More |
| Sample DDL and data for dynamic query question |
SQL Server 2000 and later |
Read More |
| dba3_AlterTableAlterColumn_Demo |
SQL Server 2000 and later |
Read More |
| Find Field in tables |
SQL Server 2000 and later |
Read More |
| SQL ASYNC CALLS |
SQL Server 2000 and later |
Read More |
| Capture Replication Statistics in AdminDB |
SQL Server 2000 and later |
Read More |
| Base64 Decoder |
SQL Server 2000 and later |
Read More |
| Base64 Encoder |
SQL Server 2000 and later |
Read More |
| parse |
SQL Server 2000 and later |
Read More |
| Proper Case for Names with Mac Mc support |
SQL Server 2000 and later |
Read More |
| Article - Sequence Table Script, String Functions |
SQL Server 2000 and later |
Read More |
| julian2DateFvF |
SQL Server 2000 and later |
Read More |
| ISOweek |
SQL Server 2000 and later |
Read More |
| Generate Object Permission SQL DDL Statements for All User Tables |
SQL Server 2000 and later |
Read More |
| drop and recreate ALL FK, UQ, DF in a database |
SQL Server 2000 and later |
Read More |
| findColumns (setbased, 'dirty' version) |
SQL Server 2000 and later |
Read More |
| Handling Divide by zero in SQL Reporting Services |
SQL Server 2000 and later |
Read More |
| List index information for all databases |
SQL Server 2000 and later |
Read More |
| List index information for the current database |
SQL Server 2000 and later |
Read More |
| Simple script to APPEND text onto an NTEXT field |
SQL Server 2000 and later |
Read More |
| Date Matrix |
SQL Server 2000 and later |
Read More |
| Avoid loginfo being rolled back (T-SQL solution) |
SQL Server 2000 and later |
Read More |
| mfnCalculateHoursMinutes (shift time) |
SQL Server 2000 and later |
Read More |
| Remove Orphaned Users |
SQL Server 2000 and later |
Read More |
| Script SQL Database DDL |
SQL Server 2000 and later |
Read More |
| Find String In View Definitions |
SQL Server 2000 and later |
Read More |
<
