NuRoN Consulting, INC.
Skip over navigation
Home
Blog
About Us
Clients
Contact Us
File Download
Donate for FREE Code
SQL Tools
Databases
DBA
Aggregates
Assemblies
Functions
dbo.fnGetDate
dbo.GetLastMins
dbo.GetSytemWaitStats
dbo.GetVirtualFileStats
dbo.ObjectScriptsGetSnapShot
dbo.SecurityScriptsGetSnapShot
Metadata.GetIndexPhysicalStats
Metadata.GetIOVirtualFileStats
Procedures
dbo.DBFileInfoRefresh
dbo.DropOldTemporaryObjects
dbo.FindSSISSQL
dbo.NotifyLoginFailures
dbo.ObjectScriptsLogCreate
dbo.RedgateScriptSingleDatabase
dbo.SecurityScriptsLogCreate
dbo.SecurityScriptsOrphanCleanup
dbo.SSISPackagesImport
dbo.SSISPackageSplitFileConnections
dbo.SSISPackageSplitSQL
dbo.SystemWaitStatsUpdate
dbo.usp_LastMin
dbo.usp_MissingServers
dbo.usp_populate_SQLServerUsage
dbo.usp_SQLServerMonitor_pivot
dbo.usp_SystemMonitor_Initiate
dbo.VirtualFileStatsIns
Tables
Triggers
Views
dbo.vSQLServerMonitor
Metadata.Assemblies
Metadata.CheckConstraints
Metadata.Columns
Metadata.DatabaseFiles
Metadata.DatabaseFilesAll
Metadata.Defaults
Metadata.Dependencies
Metadata.ExpressionDependencies
Metadata.ExpressionDependencyColumns
Metadata.ForeignKeys
Metadata.FunctionColumns
Metadata.Hobts
Metadata.IndexDetail
Metadata.Indexes
Metadata.IndexPartitionDetails
Metadata.IndexPhysicalStats
Metadata.Objects
Metadata.ObjectScripts
Metadata.PartitionFunctions
Metadata.PartitionRowInfo
Metadata.PartitionSchemes
Metadata.PartitionValues
Metadata.Permissions
Metadata.PermissionsAll
Metadata.PermissionsRecursive
Metadata.PermissionsRecursiveAll
Metadata.Principals
Metadata.PrincipalsAll
Metadata.ProcedureScripts
Metadata.RoleMembers
Metadata.RoleMembersAll
Metadata.RoleMembersRecursive
Metadata.RoleMembersRecursiveAll
Metadata.ServerPrincipals
Metadata.StoredProcedureParams
Metadata.TableColumns
Metadata.Tables
Metadata.TableScripts
Metadata.TableUsage
Metadata.ViewColumns
master
Procedures
sp_BackupFileList
sp_BackupHeaderList
sp_bcp
sp_Column
sp_Compare
sp_CompareDBProcedures
sp_CompareDBTables
sp_compile_proc
sp_CursorScript
sp_DBDrop
sp_DBFileInfo
sp_DBHasChanged
sp_DBRename
sp_DBScript
sp_DependencyReport
sp_ErrorHandler
sp_ExecBatchTerminated
sp_ExecTemplate
sp_FailedJobs
sp_files
sp_FindInvalidLogins
sp_FK
sp_FK_script
sp_GetError
sp_GetInputBuffer
sp_GetStruct
sp_GrantAll
sp_helpindex2
sp_Html
sp_HtmlDetail
sp_index
sp_index_script
sp_Insert
sp_JobHistory
sp_Jobs
sp_join
sp_kill
sp_LogError
sp_Merge
sp_MetadataViewsCreate
sp_MoveSchema
sp_MScleanupmergepublisher
sp_MSrepl_startup
sp_NotifyServerStart
sp_objects
sp_ParamDefault
sp_permissions
sp_PermissionsDBList
sp_pivot
sp_PopulateProc
sp_PrimaryKeyWhere
sp_proc_find
sp_proc_find_DBList
sp_proc_help
sp_Profile
sp_ProfileUnPivot
sp_RenameKeys
sp_Restore
sp_RunningJobs
sp_script
sp_ScriptDB
sp_servers
sp_ShrinkSimpleLog
sp_SingleLookupProc
sp_SQLskills_ExposeColsInIndexLevels
sp_StatsIO
sp_StatsIOComp
sp_SysInfo
sp_SysMon
sp_Table
sp_Table_Script
sp_TableReplace
sp_TableValues
sp_TempTables
sp_text
sp_TSQLJobCreate
sp_unpivot
sp_ViewScript
sp_whoio
sp_whoio_02
sp_wholock
usp_AuditTrace
usp_AuditTrace_SQLStmt
usp_DeadlockTrace
msdb
Procedures
dbo.usp_GetJobExecutionStatus
dbo.usp_purge_jobhistory
dbo.usp_StartJobSynchronous
dbo.usp_WaitForJobs
dbo.usp_GetJobExecutionStatus
dbo.usp_purge_jobhistory
dbo.usp_StartJobSynchronous
dbo.usp_WaitForJobs
Triggers
dbo.trg_sysjobhistory_email_failure
dbo.trg_sysjobhistory_email_failure
Util
Aggregates
dbo.BinaryOrAggregate
dbo.BitMask
dbo.BuildColumnsUpdated
dbo.MEDIAN
dbo.MEDIAN_BIG
dbo.MEDIAN_NUMERIC
dbo.StringConcat
dbo.StringConcatSorted
Assemblies
Accessibility
Microsoft.Data.Schema.ScriptDom
Microsoft.Data.Schema.ScriptDom.Sql
Microsoft.JScript
Microsoft.Vsa
System.Configuration.Install
System.DirectoryServices
System.Drawing
System.Management
System.Runtime.Serialization.Formatters.Soap
System.Windows.Forms
UtilClr
Functions
AD.GetGroupMembers
DBA.ConvertToExtents
dbo.BinaryReverse
dbo.BinaryReverseAndTrim
dbo.BinarySetCount
dbo.BinaryTrim
dbo.BitwiseIn
dbo.CastXML
dbo.CastXMLInline
dbo.CleanHTML
dbo.CombineIntToDateTime
dbo.CompareNamesForOwnerThrowDate
dbo.ConvertSQLtoHTML
dbo.CreateConditionalUpdate
dbo.GenerateAlterScript
dbo.GetColumnType
dbo.GetCPUUsage
dbo.GetDates
dbo.GetDateTimeDifference
dbo.GetNumbers
dbo.GetNumbersInline
dbo.GetPercentage
dbo.GetProcedureFromExecuteSQL
dbo.GetTempTableName
dbo.ImplyingPermissions
dbo.IsNonWhiteSpaceIdentical
dbo.OrderViewColumns
dbo.ParseBitMask
dbo.ParseBitMask_CLR
dbo.ParseByteArrayToCols1024
dbo.ParseByteArrayToCols128
dbo.ParseByteArrayToCols16
dbo.ParseByteArrayToCols256
dbo.ParseByteArrayToCols32
dbo.ParseByteArrayToCols512
dbo.ParseByteArrayToCols64
dbo.ParseByteArrayToCols8
dbo.ParseColumnsUpdated
dbo.ParseColumnsUpdated_CLR
dbo.ParseDelimited
dbo.ParseDelimited_CLR
dbo.ParseDelimitedColumns1024
dbo.ParseDelimitedColumns1024_CLR
dbo.ParseDelimitedColumns128
dbo.ParseDelimitedColumns128_CLR
dbo.ParseDelimitedColumns16
dbo.ParseDelimitedColumns16_CLR
dbo.ParseDelimitedColumns256
dbo.ParseDelimitedColumns256_CLR
dbo.ParseDelimitedColumns32
dbo.ParseDelimitedColumns32_CLR
dbo.ParseDelimitedColumns4
dbo.ParseDelimitedColumns4_CLR
dbo.ParseDelimitedColumns512
dbo.ParseDelimitedColumns512_CLR
dbo.ParseDelimitedColumns64
dbo.ParseDelimitedColumns64_CLR
dbo.ParseDelimitedColumns8
dbo.ParseDelimitedColumns8_CLR
dbo.ParseDelimitedTableColumns32
dbo.ParseDelimitedTableColumns32_CLR
dbo.ParseSPDefaults
dbo.ParseTextQualified
dbo.ProcedureInputDelimitedTable
dbo.QuotenameOptional
dbo.RemoveLeadingZeros
dbo.RemoveLeadingZerosInline
dbo.ReplaceSchemaFromXMLList
dbo.ReplaceTextFromXMLList
dbo.ResolveDecimal
dbo.ResolveDecimal_CLR
dbo.SPParamDefault
dbo.StreetName
dbo.TokenizeSQL
dbo.TrimBothEnds
dbo.TrimEnd
dbo.TrimMultiline
dbo.TrimStart
dbo.TryParseDateIntTimeInt
dbo.TryParseDateTime
dbo.TryParseDecimal
dbo.XMLTable
FS.AppendAllTextToFile
FS.FileCopy
FS.FileDelete
FS.FileMove
FS.FileReplace
FS.FilesDelete
FS.FilesDeleteMatch
FS.GetDirectoryInfo
FS.GetFileInfo
FS.GetVolumeInfo
FS.GetVolumeInfo_CLR
FS.ReadAllTextFromFile
FS.ReadLine
Metadata.GetIndexPhysicalStats
Metadata.GetIOVirtualFileStats
RE.RegExEscape
RE.RegExIndex
RE.RegExIsMatch
RE.RegExMatch
RE.RegExMatches
RE.RegExOptionEnumeration
RE.RegExReplace
RE.RegExReplaceX
RE.RegExSplit
Procedures
DBA.GetChangedExtents
dbo.FixedLengthColumnBuilder
dbo.FixedLengthDefinitionIns
dbo.GetProcessorCount
dbo.GetSQLStatisticsIO
dbo.GetSQLStatisticsIO_CLR
dbo.LineFunctionGeneratorDelimited
dbo.LineFunctionGeneratorFixedLength
dbo.PopulateSystemWaitTypes
dbo.PrintLargeText
dbo.PrintLargeText_CLR
dbo.ProfileImport
dbo.SQLColumnDependencyAppend
dbo.SQLColumnDependencyGet
dbo.usp_CacheTables
dbo.usp_DeadlockReport
dbo.usp_Delete_Older_Files
dbo.usp_DiabloFailedRowDetail
dbo.usp_DiabloFailedRowDetail_GenerateEmail
dbo.usp_populate_DiabloSpecColumnMapping
dbo.usp_populate_DiabloSpecTableMapping
dbo.usp_populate_SSISDataTypes
dbo.usp_populate_SSISErrorCodes
dbo.usp_ServerDataFileReport
dbo.usp_SqlAgentPoll_Cleanup
dbo.usp_SqlAgentPoll_Insert
dbo.usp_SqlAgentPoll_Missing
Tables
Triggers
Views
dbo.DefaultTrace
dbo.ExactNumericDataTypeRanges
dbo.SysInfo
dbo.SystemObjectTypes
dbo.vDiabloFailedRowDetail
Metadata.Assemblies
Metadata.CheckConstraints
Metadata.Columns
Metadata.DatabaseFiles
Metadata.Defaults
Metadata.Dependencies
Metadata.ExpressionDependencies
Metadata.ExpressionDependencyColumns
Metadata.ForeignKeys
Metadata.FunctionColumns
Metadata.Hobts
Metadata.IndexDetail
Metadata.Indexes
Metadata.IndexPartitionDetails
Metadata.IndexPhysicalStats
Metadata.Objects
Metadata.ObjectScripts
Metadata.PartitionFunctions
Metadata.PartitionRowInfo
Metadata.PartitionSchemes
Metadata.PartitionValues
Metadata.Permissions
Metadata.PermissionsRecursive
Metadata.Principals
Metadata.ProcedureScripts
Metadata.RoleMembers
Metadata.RoleMembersRecursive
Metadata.ServerPrincipals
Metadata.StoredProcedureParams
Metadata.TableColumns
Metadata.Tables
Metadata.TableScripts
Metadata.TableUsage
Metadata.ViewColumns
Template Scripts
Active Directory
Linked Server
Admin
Attach DB
Backup History
Cache Tables
Change DB Owner for all databases
Change Dbowner to SA
Change Default Database
Change Default Schema owners to default
Change Job Owner msdb
Change Job Owner
Check Edition
Compare Table Data
Compress Tables
Compression List
Create Join on Index columns
Create login and server member script
Create missing indexes
Create object aliases
Create Snapshot
Create X_ tables
Data Files Split
Database File Usage
Default DB SET
Delete duplicates
Delete Trigger Create
Drop user schemas from system databases
File Usage Batch
File Usage
Foreign Key missing index create
Fragmentation
Generate Ins Upd Del Stored Proc
Generate Primary and, Unique key and Index Script
Get Instances
Get Port Number
Grant Connect Right to all DB users
Grant showplan access
Grant View Definition
Import DTSX contents into a table
Index Dataspace
Index Defrag
Index Fragmentation Status
Index NC Bad vs Missing
Is Database in Full Recovery
Kill Database Process
Last SQL Server and Agent start time
LatLonDistance
List Of Columns
List Of Index Columns
Median
Merge
MSDB Job Duration
New Objects
Orphaned Users
ParseName
PartitionQueries
Print Large Text
Recreate Indexes
Remap Logins
Rename database files
Rename Primary Unique Foreign
Resize Database Files
Restore Corestore
Restore History
Restore List
Restore with standby
Script Foreign Keys
Script Insert Statements
Search SQL Agent Command
Server Properties
SERVERPROPERTY
Set Enviroment Variables
Set Recovery Simple
Shrink Files
Switch Identity Property
Table Row Count
Table RowCount and Index Size
Table usage report on Temporary
Top costly executed statements
Trust Constraints
UseCoreStoreSnapShot
usp_whoio_hist
xp_ReadErrorLog
AuditTrace
Dmitry Troubleshoot
FindCursors
Profile Actions
Setup Startup Procedure
usp_AuditTrace
usp_AuditTrace_SQLStmt
usp_DeadlockTrace
usp_ProfileImport
Backup Restore
Filegroup Restore
Move script for restore
BatchFiles
Copy Dbschema Files
BCP
Export Import All Tables
Binay
Binary char conversions
CDC
CDC ALL
cdc jobs
Error Reporting
Rollback Forward Script
Script cdc schema tables
SQLServerCentral
Troubleshoot
Check Constraint
Duplicate check constraint columns
Rebuild Valid Year
Select all check constraints
Code Tables
Create Tables
Instead of Trigger
Columns
Add Not Null with defaults to bit columns
All Columns
Column Changes
Column Select
Columns Comparison
Columns_Updated
Copy Column Headers and Make it a list
Create views
Find Numeric Column Values
Find Spaces at front of column
Get Column list and clustered index key_ordinal
Get Column List
Key and Foreign Key Columns
Order View Columns
Primary key join create
Rename Columns
Sort View Columns
SQL_Variant
Trim all columns
Data Files
Move for Restore
Database
Available Database List
Create Database
Set Default Options
Date
Packing Date Intervals
Date Calculations
Start and End day of Quarter
DBA
Find Proc SQL
Import SSIS Packages
Monitor Object and Security Scripting
Object Script Logging
Samples
Security Script Logging
Split SSIS File Connections
Split SSIS Packages SQL
SystemWaitTypes
VirtualFileStats
DDL Trigger
Table
Default Trace
Disable Enable
Query Default Trace
Dependencies
Object Column Dependencies
SQL Column Dependencies
Diagnostic
Blocked connection info
Diagnostic Info
Missing Index
MissingIndexes
Session Info
Show Lock Info
DMV
Connection Info
DMV 01
DMV 02
DMV Starter Pack
Documentation
System Proc Doc
Extended Properties
Add update drop select extended property
DropOrUpdateExistingExtendedProperties
GetCurrentAndMissingExtendedProperties
GetExtendedProperties
GetExtendedPropertiesForDelete
GetExtendedPropertiesForModification
Overview
PrepareDocumentableObjects
SetIndividualExtendedProperties
Extract
ExtractTablesView
FileIO
File Copy Test
Volume analysis
FOREIGN KEY
Find Missing Values
ForeignKeyTable
Functions
Get function definitions
GRANT
VIEW SERVER STATE
IndexDefrag
dba_indexDefrag_sp
Defrag Report
Indexes
Indexes Table
IndexPhysicalStats
Inferred Matching
Reset Service Control
Inline Function
Inline Function Sample
IO
Latency
Joins
Trans Mort Prop Address
LineParser
Create All functions
Create ColumnDef Type
Delimited function generator
Substring function generator
Linked Server
Linked Server Test
LiteSpeed
Backup Database
Delete Old Backup Files
Diablo Restore
Settings
Local
Restore Diablo
Locks
Locking prior to process start
Locking rows or partition
Login
sp_change_users_login
master
Memory
Memory Grants
Memory Usage by object
Misc
FNMA
Median
Parse dir cmd
Recreate Table Index
States
msdb
After restoring msdb follow these steps
Clear notify email operator
Create alert operator notification_method list
Current running jobs
Disable notification
Find Job Step
GRANT EXEC xp_sqlagent proc to public
jobs view
Last Restore Date
Replace DTLogExec
Set Include step in output history
Split jobs to SSIS and SQL
ssispackages
Update JobStep Command
Parallel Execute
Parallel Execute
Partition
Drop Partitioned Tables
GetPartitionID
Inspect Partitions
ListPartitionValues
Partition Compression Report
Performance Counters
Page Life Expectancy
Total Server Memory
Permissions
Troubleshoot Permissions
Procedure Defaults
Test Procedure Defaults
Profile
Analyze grouped profile
Analyze Load Control Differences
RAISERROR
Raiserror
RegEx
RegExSamples
Restore Master Key
Restore Master Key
Schema
Alter authorization to defaults
Cleanup user schemas
Drop objects belonging to Schema and schema
Drop User Schemas
Search
Search any character field
SELECT
Horizontal Aggregate
VALUES
Server
Rename Server
Service Broker
04 Tutorial Beginning a Conversation
05 Tutorial Receiving Request
06 Tutorial Receiving Reply
Code Generator
Create Service Account Logins
Original Tutorial
Setup Que
Setup Tables
System tables
Test
Troubleshoot
Service Broker Generic
Code Generator
Setup Que
Setup Tables
System tables
Test
Special User Access
SQL Agent Jobs
Change Job Owner
Email Deadlock Info
Email Job Disable Enable
Find Service Account
JobScript_FindConflictingJobSchedules
JobScript_FindMissedJobs
SQL Agent Schedule View
Trigger to email jobs
SQLCompare
SSIS
Data Types
Fixed Length Column Builder
New Fixed Length
Query fileconnections
ssispackages
StatsIO
ParseLogicalReads
ParseLogicalReads2
Stored Procedure
Generate Execution Script
Strings
Replace database names
Replace Multiple spaces to one space
System Objects
All Objects by modified date
Find Object definition
Hierarchy Union ALL
Object Types
Write all definitions to text
System Proc
msdb.dbo.usp_FailedJobs
msdb.dbo.usp_GetJobExecutionStatus
msdb.dbo.usp_purge_jobhistory
msdb.dbo.usp_StartJobSynchronous
msdb.dbo.usp_WaitForJobs
sp_BackupFileList
sp_BackupHeaderList
sp_bcp
sp_Column
sp_Compare
sp_CompareDBProcedures
sp_CompareDBPTables
sp_compile_proc
sp_CursorScript
sp_DBDrop
sp_DBFileInfo
sp_DBHasChanged
sp_DBRename
sp_DBScript
sp_DependencyReport
sp_ErrorHandler
sp_ExecBatchTerminated
sp_ExecTemplate
sp_FailedJobs
sp_files
sp_FindInvalidLogins
sp_FK
sp_FK_script
sp_GetError
sp_GetInputBuffer
sp_GetStruct
sp_GrantAll
sp_helpindex2
sp_Html
sp_HtmlDetail
sp_index
sp_index_script
sp_insert
sp_JobHistory
sp_Jobs
sp_Join
sp_Kill
sp_LogError
sp_merge
sp_MetadataViewsCreate
sp_MoveSchema
sp_NotifyServerStart
sp_objects
sp_ParamDefault
sp_permissions
sp_PermissionsDBList
sp_pivot
sp_PopulateProc
sp_PrimaryKeyWhere
sp_proc_find
sp_proc_find_DBList
sp_proc_help
sp_profile
sp_ProfileUnPivot
sp_RenameKeys
sp_Restore
sp_RunningJobs
sp_script
sp_ScriptDB
sp_servers
sp_ShrinkSimpleLog
sp_SingleLookupProc
sp_SQLskills_ExposeColsInIndexLevels
sp_StatsIO
sp_StatsIOComp
sp_SysInfo
sp_SysMon
sp_Table
sp_Table_Script
sp_TableReplace
sp_TableValues
sp_TempTables
sp_text
sp_TSQLJobCreate
sp_unpivot
sp_ViewScript
sp_whoio
sp_whoio_02
sp_wholock
usp_AuditTrace
usp_AuditTrace_SQLStmt
usp_DeadlockTrace
Table
Table script from tab delimited
Tables List
Table Stats
How Many Pages are compressed
Update And Scan statistics
TempDB
Session Usage
Template Procedures
Exec Expression
Tests
sp_whoio capture memory
TransDeed Test
TransLien PropId Test
Trace
MergePropertyAndBuilding SQLSTMT
Transactions
Open Transactions
Triggers
Disable or Enable Triggers
Troubleshoot
Failed Index
Users
Change Default DB
Cleanup unused database users
Create Logins
Database Group Members
Database Permissions
Delete Unused Users
Drop and non sysadmin users
Get recursive user permissions from multiple databases
Recreate Windows Groups as Logins
sp_help_revlogin
SysAdmin List
Windows User List
Util
Backup Util and DBA
Delete all temp and log files
DiabloSpecMapping
Drop All to Redeploy
Grant access to all logins
ReplaceCoalesce
Set Trustworthy ON
SPParamDefault
Utility
File Replacement for the line
Views
List View Columns
WAITS
Cumulative
Difference 01
Difference 02
Difference 03
WorkingOn
DiabloLoadCombinerGeneratedQ2
DiabloLoadCombinerGeneratedQ3
DiabloLoadCombinerGeneratedQ4
DiabloLoadCombinerGenerator
TransTest
XML
Cast string as XML
Cross Apply
Double function test 2
Double function test
FOR XML Path
FOR XML
OPENROWSET
Parameter Passing
Print Large Text with XML
Query SSIS packages
Reading XML
Replace XML Escape
XML Retrieve Element
XMLTable
Blog
>
SQL Tools
>
Template Scripts
>
SELECT
>
VALUES
Template Script: SELECT\VALUES.sql
SELECT
*
FROM
(
VALUES
(
1
,
'Human Resources'
,
'Margheim'
)
,
(
2
,
'Sales'
,
'Byham'
)
,
(
3
,
'Finance'
,
'Gill'
)
,
(
4
,
'Purchasing'
,
'Barber'
)
,
(
5
,
'Manufacturing'
,
'Brewer'
)
)
AS
ddata
(
DeptID
,
DeptName
,
Manager
)
Description for Template Script: SELECT\VALUES.sql
Todo
Home
Site Map
Search
Register
Sign In