Change the server name of the SQL Server Instance
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,272 reads
Scripts
Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
208 reads
2018-03-19 (first published: 2018-03-15)
442 reads
Unused Indexes in your databases
This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude
2018-03-06 (first published: 2011-02-10)
6,147 reads
2018-02-28 (first published: 2018-01-10)
3,097 reads
Custom Replication Status Record Latency Monitor
Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold
2018-02-27 (first published: 2015-01-23)
562 reads
2018-02-23 (first published: 2018-02-19)
161 reads
2018-02-19 (first published: 2018-02-07)
1,010 reads
Compression estimates
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,050 reads
2018-02-12 (first published: 2018-01-24)
322 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers