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,287 reads
Scripts
Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
210 reads
2018-03-19 (first published: 2018-03-15)
445 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,156 reads
2018-02-28 (first published: 2018-01-10)
3,099 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)
567 reads
2018-02-23 (first published: 2018-02-19)
162 reads
2018-02-19 (first published: 2018-02-07)
1,015 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,052 reads
2018-02-12 (first published: 2018-01-24)
330 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers