2017-03-08 (first published: 2017-02-16)
2,040 reads
Scripts
2017-03-07 (first published: 2017-03-01)
1,266 reads
Corrupt Page Notification
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
522 reads
Missing index with change impact percentage
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,352 reads
2017-02-28 (first published: 2015-06-22)
2,121 reads
Getting resource content from blocked process report
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2017-02-27 (first published: 2017-02-21)
1,317 reads
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,625 reads
2017-01-31 (first published: 2017-01-30)
813 reads
2017-01-30 (first published: 2017-01-26)
19,708 reads
Query details about objects allocated in TEMPDB.
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,251 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers