2016-08-11 (first published: 2015-06-12)
3,668 reads
Scripts
2016-08-10 (first published: 2015-05-05)
5,496 reads
DynamicDateRangeGenerator
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
614 reads
Quick SQL Server Configuration Summary Report
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,530 reads
Calendar Table Function
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-02 (first published: 2014-12-29)
8,570 reads
Show running queries
Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.
2016-08-01 (first published: 2015-03-03)
5,448 reads
Report overlapping jobs
This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.
2016-07-29 (first published: 2014-06-21)
2,665 reads
Yet another way to defrag indexes
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,369 reads
Dynamic Table Name on Select Into
Based upon todays date as suffix and chosen string as prefix, select data from predefined table into dynamically named new table. Script is properly error handled with most common errors
2016-07-27 (first published: 2015-05-04)
2,587 reads
2016-07-26 (first published: 2014-11-20)
2,255 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Alamat Kontak Bank BCA KCP Pahlawan Telp:08218154392
WA CS:08218154392 Jl. Khp Hasan Mustopa No.108, Padasuka, Kec. Cibeunying Kidul, Kota Bandung, Jawa...
ALAMAT KANTOR BCA KCP Klender Telp:083831618008
WhatsApp:0838-3161-8008 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers