2016-08-11 (first published: 2015-06-12)
3,674 reads
Scripts
2016-08-10 (first published: 2015-05-05)
5,512 reads
DynamicDateRangeGenerator
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
619 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,552 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,584 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,452 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,673 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,378 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,596 reads
2016-07-26 (first published: 2014-11-20)
2,258 reads
Blogs
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers