Adding a Query Governor to Dynamic-Search Stored Procedures
When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.
2014-12-15
4,077 reads
Dwain Camps
Splitting Strings Based on Patterns
Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.
2014-09-12 (first published: 2012-11-29)
32,594 reads
Exploring Recursive CTEs by Example
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
2014-07-25 (first published: 2012-07-17)
26,920 reads
Creating a Date Range from Multiple Rows Based on a Single Date
When you've got only a single effective date on a record and you need to artificially create the effective end date based on a following row in T-SQL, the techniques discussed in this article will help you decide what is best.
2014-03-18
33,131 reads
The SQL TABLE Type: Beyond Table-Valued Parameters
Follow along as this starter article on the SQL TABLE Type walks you through the various ways it can be used in T-SQL.
2014-03-03
9,244 reads
Variable Default Values to a Stored Procedure (SQL Spackle)
A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.
2013-09-03
8,231 reads
A Hazard of Using the SQL Merge Statement
The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned
2013-04-03
24,164 reads
Double Counting and Sign Reversals
Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless.
2013-01-07
4,324 reads
Departures from Origins and Arrivals at Destinations
A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.
2012-12-11
15,141 reads
Set Up Grouping Intervals for Excel (SQL Spackle)
So you want to group your data for charting in Excel? Here's how, the easy way!
2012-07-31
5,354 reads
Blogs
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an...
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Forums
How to get result from deleted row
Hi Guys I have a store proc that delete a row from a and...
Count of Distinct Values
Hi If value is 21000030 it should return 4 not 5 . In first...
Joining against min date only
This is one of those things very hard (for me)to explain in words. See...
Question of the Day
Rolling Back CUs
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers