tsql.tech-Code-snippets

KO | EN

gitlite — search

#python #hacktoberfest #golang #android #deep-learning #linux #nodejs #java #awesome #vue #security #ios #mcp #open-source

tsql.tech-Code-snippets

(★ 96)

Useful SQL Server scripts/SPs for DBA or SQL Developers that I use and/or have created

tsql.tech-Code-snippets 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# [tsql.tech](http://tsql.tech) Code snippets

List of contents:

* ## DMV (Estract useful informations from DMVs)
  - Availability Groups information
  - Find Active Locks
  - Find Key Lookup in Plan Cache
  - Find Long Running Queries in PlanCache
  - Find Most Expensive Queries in PlanCache
  - Find Plans of your query in PlanCache
  - Find implicit Conversion Queries in PlanCache
  - Measure IO Latency and Throughput in a period of time
  - Index Usage Statis
  - LatchesStats
  - SpinlockStats
  - Table Sizes
  - Waitstats

* ## Dynamic SQL
  - Execute and Track the performance and behavior of Dynamic SQL Statements
    [REFERENCE ARTICLE](https://tsql.tech/tracking-dynamic-sql-performance-automatically-with-a-wrapper-on-sp_executesql-dynamic-sql-inception/)

* ## Extended Events
  - Backup-Restore duration troubleshoot
  - Capture Plans with warning

* ## Functions
  - DelimitedSplit8K - The powerful splitting function by [Jeff Moden](http://www.sqlservercentral.com/articles/Tally+Table/72993/)
  - fn_KeepInString - Keep only certain values in a sting [See Article](https://tsql.tech/a-quick-function-to-remove-or-keep-only-string-patterns-from-sql-server-strings/)
  - fn_RemoveFromString - remove certain patterns from a string [See Article](https://tsql.tech/a-quick-function-to-remove-or-keep-only-string-patterns-from-sql-server-strings/)
  - fn_TrasposeString - Trasposes strings into tables [See Article](https://tsql.tech/a-quick-function-to-remove-or-keep-only-string-patterns-from-sql-server-strings/)

* ## Maintenance
  - Align Columnstore Index - [Automatically align columnstore indexes to enhance segment elimination (and hence performances)](https://tsql.tech/a-script-to-automatically-align-columnstore-indexes-to-enhance-segment-elimination-and-hence-performances/)
  - Data type consistency check
  - Rebuild Fragmented Heaps
  - Truncate All Transaction Log
  - VLF_Shrink
  - Add SQL Server Agent Alerts
  - Track progress of Index (re)creation

* ## Notebooks
  - Jupyter Notebook to use with SQL Server and Azure Data Studio
  - [The SQL Diagnostic (jupyter) Book](https://tsql.tech/the-sql-diagnostic-jupyter-book/)

* ## PowerBI
  - Job Information - [A report to analyze the Agent Job performance, comes with companion procedure](https://tsql.tech/a-powerbi-report-for-sql-server-agent-jobs/)
  - Permission Information - [A report to analyze the granular permissions on your SQL Server instance](https://tsql.tech/a-sql-server-permission-report-in-powerbi/)
  
* ## PowerShell
  - Covert Notebook to HTML - Converts a Jupyter Notebook to HTML for easy export [Requires jupyter installed in the System]
  - Create Diagnostic Notebooks - Automatically creates Jupyter Notebooks from the Latest Glen Berry Diagnostic Queries
  - Create FirstRespodersKit notebook - Automatically creates Jupyter Notebooks from the Latest FirstRespondersKit scripts
  - Export to CSV - A sample, simple, export SQL Table to CSV file using SQLServer Powershell Modules
  - PIP upgrade all packages - A simple way to upgrade all the installed Python packages using PIP

* ## QueryStore
  - Query Tuning Reccomandations
  - QueryStore_Duration

* ## Schema-Related
  - Bulk Move Schema
  - Find Column by name
  - Find Stored Procedure
  - Find primary key candidates

* ## Session Materials
  - How to use PowerBI as a Monitoring Tool (Slides and Report examples)

* ## Troubleshooting
  - How Many Rows has a DML Operation modified until now
  - ParallelTasks of a Session
  - Read TransactionLog User Actions [HOW TO FIND A SAFE RESTORE POINT (AND WHO MESSED UP) BY READING FROM THE TRANSACTION LOG](https://tsql.tech/find-who-e-when-something-was-messed-up-in-order-to-restore-to-a-safe-point-using-the-transaction-log/)
  - TempDB Page Contention
  - sp_whoisactive_find_longrunning_blocked_query
  - Tests the current database against its check constraints and reports any data that would fail a check were it enabled
  
* ## Views
  - BlitzCache_MissingIndexesView - Filters the BlitzCache historic table for misssing indexes reports
  - JobAndSchedules - Shows SQL Agent Jobs and Schedules, by [M.Pearson](http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30381/)

tsql.tech-Code-snippets

tsql.tech-Code-snippets 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

tsql.tech-Code-snippets

tsql.tech-Code-snippets 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README