Table Valued Function to return a range of prime numbers
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
419 reads
Jonathan Roberts
Get file sizes of database files and free space on disk
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
5,471 reads
Function to count set bits in a signed integer
This function counts the number of 1's in the binary representation of an integer.
2015-07-28 (first published: 2014-02-24)
973 reads
Function to display integer as binary string
This function converts an integer to its binary representation. e.g. 15 is converted to '00001111'
2015-04-29 (first published: 2014-02-24)
785 reads
Use Dynamic SQL to Improve Query Performance
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
32,703 reads
Using Certificates to Sign Stored Procedures
How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.
2010-06-21
11,305 reads
Version Control your Stored Procedures
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
2010-05-06
20,799 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
SSIS SMPT limit of 256 characters
Is using C# the best to resolve SSIS SMPT limit of 256 characters using...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers