Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
4,956 reads
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
13,515 reads
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
2009-07-20 (first published: 2009-07-03)
1,321 reads
In this article I discuss a new feature in SQL 2008, table-valued parameters and particularly the restriction that they have to be read-only. I argue that this makes this feature considerably less useful that it could be, and that in order to build scalable applications be able to pass read-write table parameters between stored procedures is essential.
2008-04-02
2,677 reads
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
2008-01-31
17,862 reads
When reading rating information, how do you you knew how many points each separate voter gave if you only know the average rating and the number of votes? Well, you might be surprised to learn that you can figure it out using SQL
2007-10-01
1,919 reads
When a function is wrapped around an indexed column in the WHERE clause it will usually prevent the proper usage of that index. This article gives an example and discusses what other options are available.
2007-09-27
5,005 reads
We have a first look at one of the features in SQL Server 2008 that was cut from SQL Server 2005, but which has been highly anticipated. How many times have you written an "insert new, update match" routine? Jacob Sebastion shows us easy this becomes with the new MERGE keyword in SQL Server 2008.
2007-09-11
14,050 reads
One of the more common requests of an application working with SQL Server is to deal with pages, or sections, or data rather than an entire result set. Often an application retreives the entire result set and then only shows the user a few records, repeating the process with the next page. Regular columnist Jacob Sebastian brings us a more efficient method of implementing paging in SQL Server 2005.
2007-08-29
13,706 reads
One common need that DBAs run into is building a report that returns data in some random order. Especially if you're doing some type of contest, like giving something away at your User Group meeting. Andy Warren brings us a short article on this with a look at the performance impact of randomly ordering results.
2007-08-23
4,348 reads
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Comments posted to this topic are about the item URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers