How to Design, Build and Test a Dynamic Search Stored Procedure
Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.
2015-03-06 (first published: 2013-11-05)
24,894 reads
Dwain Camps
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,085 reads
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)
33,156 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)
27,103 reads
Stupid T-SQL Tricks – Part 1: Logarithms
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,413 reads
The One Million Row T-SQL Test Harness
So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...
2014-04-17 (first published: 2014-04-08)
4,644 reads
Using the T-SQL MERGE Statement
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,674 reads
Manipulating Dates and Times in T-SQL
In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....
2014-04-08 (first published: 2014-04-04)
7,099 reads
Make it Work, Make it Fast, Make it Pretty
When I first heard this, it struck me as being a remarkably concise wisdom applicable to virtually any programming task....
2014-04-01
1,184 reads
Calendar Tables in T-SQL
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,691 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers