The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
LifeAsBob
Saturday, February 16, 2019
Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book
~hpa0014.jpg
bob Links
The 12volt Side of L...
Come, Sir, you must mend a bad supper with a glass of good ale. - Robert Dodsley
Script Vault:
(New or Upload)
2gbMemory
Active Directory - Enumerate G
Activity Monitor
Activity Monitor 2
Always - On Routing
Always-On Health Status
Auto Growth - Check out of con
Auto-Close Set All
Azure ILB Listener
Backup - Estimated Completion
Backup - How Long
Backup Find File Name
Backup History 1
Backup History 2
Backup History 2
backups
Backups - Size
Blocked Processes
Blocked Processes 2
Blocking Script - SQL 2K
Blocking Script - SQL 2K5
Buffer Pool Useage
Column data compare
Columns - comma list
Columns - List All
Columns - Search for
Compression - All Tables 1
Compression - All Tables 2
Compression - All Tables 3
Compression - Find All
Copy Data 100
CPU by Database
Data Files - DMV - Free space
Data Files - Space Allocation
Database Compatability Mode -
Database Mail Configuration
Database Owner - Chg All
Databases Read Only
DBCC CheckDB - Last Time
DD - Directories
Deadlocks - Find
Disk Space Stats
DOS Short Files Names
Error Log Read
Execution Cache
Extended Events - Trap
File Initilization Status
Filegroup - change text
Filegroup - List All Size
Filegroup - Whats in
Find Logged On Users
Foreign Keys - Table
Foreign Keys Missing Indexes 1
Foreign Keys Missing Indexes 2
Foreign Keys Missing Indexes 3
GUID Check
Hyper Treading 1
I/O File Stats 1
I/O File Stats 2
I/O Stalls
I/O Stalls by Drive
Identity - Find Next
Identity Reset all
Identity Values - Check Max
Identity Values - Reseed
Indexes - Compare
Indexes - Drop - sql2k5+
Indexes - No Primary Key
Indexes - Rebuild All
Indexes - Reindex 2K5
Indexes - Usage
Indexes Create All
Indexes Finds Scans
Indexes Fragmentation
Indexes Highly Used
Indexes List All and Fields
Indexes List Table 4 One
Indexes List Unused
Indexes Missing
Indexes Missing - Query Plans
Indexes Missing 2
Indexes Only Updated
Indexes Overlap
Indexes Size
Indexes Size FileGroup
Indexes Size and Type
IP Address
Jobs - Copy from MSDB
Jobs - Duration View
Jobs - Find Running
Jobs - List all SQL2K
Jobs - List w/ Avg & Run Time
Jobs - List with Schedule
Jobs - Listing steps, tsql
Jobs - Transfer 2014
Jobs - Transfer 2k8
Kill Connections
Last Time SQL Server Restarted
LDF Files - Rebuild
Linked Svr - Recover Passwords
Locks by Session Id
Locks by Type
Logins - Clone - SQL2K
Logins - Clone - SQL2K5
Logins - Synchronize
Logins - Transfer
Logins - Transfer 2
Logins - Transfer SA
Logins - Unlock
Logins Transfer 2005
Logon Trigger View
Memory - Queries waiting for
Object Search
Parallelism Query Instance
Parallelism Set Instance
Password - Generate Random
Patches appled SQL
Performance Issue 1
Performance Issues 2
Permissions - All
Permissions - Roles
Permissions CopyFromUsertoUser
Permissions Read Only to All
Port Number - Get
Power Plans
Public Role Permissions
Public Role Permissions 2
Query Plan - Compile Timeout
Query Plan - Get PS
Query Plan Get
Query Plan Remove EXEC
Query Plan Remove No EXEC
Query Plan Single Use
Quest Litespeed - Table Restor
Quoted Identifiers List
Rename Files
Resource Governor setup
Restore - Query Progress
Restore Databases Directory
Restore Script Generator
Restore When What
Rpt Svc - Add Email Sub
Rpt Svc - Add users
Rpt Svc - Avg Rpt Runtime
Rpt Svc - Avg RunTime Pnt Fld
Rpt Svc - Delete All Subscript
Rpt Svc - Executed
Rpt Svc - Run Subscription
Rpt Svc - SQL Agent to Report
Rpt Svc - Subscr Run When
Rpt Svc - Who Runs What
Schema - List Default
Schema - Update dbo
Schema Change Default All
Schema Common Dev
Schema Move Objects
Script Out Data SQL
Search All Tables All Columns
Search Code SQL 2K
Search Code SQL 2K5
Search Code SQL 2K5 (xml)
Server Name - Physical 1
Service - Restart
SOX User Permissions
SOX Users Roles SysAdmin
SOX Users Roles SysAdmin 2K5
sp_who
SPID Monitor
SPID to OS Thread
SPIDS - Kill
SQL Agent Log Clean Up
SQL Agent Tokens
SQL Mail On Express
Statistics
Statistics - Drop All
Statistics 2
Stored Procedure - Tables Refe
String Cnt Char Occurrences 1
String Cnt Char Occurrences 2
String Cnt Char Occurrences 3
String Split
String Transformation - Remove
Suspect Database Recovery
System Databases - Grow
Table Row Count running proces
Table Space rows indexes
Tables - Find LOB
Tables - List Columns, Types
Tables - Size Filegroup - 1
Tables - Size Filegroup - 2
Tables - Size, Rows Index Data
Tables Row Count
Tables Space & Row Count
TempDB - Allocation Bottleneck
TempDB - Allocation Type
TempDB - Setup
TempDB - Space Useage
Time Elapsed
Top Queries - By CPU
Top Queries - By Disk I/O
Top Queries - By Duration
Top Queries - By Reads
Transaction - Monitoring
True Up
Truncate Table Delegation
Unblock a File
Views - Refresh All
Views - Tables Used
Views of Base Tables
Waiting On
Waiting Processes
Waits Top
Walking the Dog by Days, loop
Login
Script
SELECT Convert(Varchar(100),value_in_use) as value_in_use FROM sys.configurations WHERE name = 'max degree of parallelism'
Notes:
from Gail Shaw: https://www.sqlservercentral.com/Forums/Topic1088108-391-1.aspx modified by bob with the convert statement so that it will run in a asp.net data grid
Update by:
Updated On:
12/3/2018 6:38:18 PM
Created by:
Created On:
12/3/2018 6:38:18 PM
Script Name:
Think ! The text boxes below only works if your particular SQL Server is available via where this website is hosted / on the internet, so this is really code that is for me !; though I am working to update it to run either server side or client side via a check box, this will be a nice future enhancement (think AJAX).
Integrated Authentication
Time Out:
Wrap cell contents in results
Display Messages (Print)
Run For a specific database