Jonathan Roberts


Technical Article

Comprehensive SQL Performance Monitoring and Optimisation Script

This script monitors and reports the execution statistics of SQL statements over a specified period, capturing metrics such as execution counts, CPU time, I/O operations, and elapsed time. It provides a comprehensive view of query performance, aiding in the diagnosis of performance issues and identifying problematic SQL queries in the database.

5 (1)

You rated this post out of 5. Change rating

2024-07-29 (first published: )

1,912 reads

Technical Article

User-Created GENERATE_SERIES() Function for Older SQL Server Versions

In the world of SQL Server, adaptation is key. While the built-in GENERATE_SERIES() function was a valuable addition in SQL Server 2022, its absence in older versions created a functionality gap. Enter the user-written GENERATE_SERIES function. Adapted from Jeff Moden's "dbo.fnTally", it offers an efficient means to generate a series of numbers within a defined range in older SQL Server versions. Its design mirrors the built-in function in SQL Server 2022, making the transition between versions as simple as removing the dbo. prefix. This forward-thinking design reflects the ingenuity of the SQL Server community, ensuring a seamless, efficient database migration experience.

You rated this post out of 5. Change rating

2023-06-26 (first published: )

2,316 reads

Technical Article

A DateRange Table Valued function

The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.

5 (6)

You rated this post out of 5. Change rating

2019-08-29 (first published: )

5,174 reads

Blogs

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

By

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...

Read the latest Blogs

Forums

Execution Plan Operators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Execution Plan Operators

Merge spans with Dates Logic

By dhanekulakalyan

--for a given member if the startdate and endate is continous we need to...

Merge data from two different source until the data is available from both sourc

By komal145

I have two sources , one coming from datalake and another is file. we...

Visit the forum

Question of the Day

Execution Plan Operators

When looking at an execution plan in SSMS, what types of operators are shown?

See possible answers