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,925 reads
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,925 reads
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 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,205 reads
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,128 reads
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,414 reads
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,645 reads
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
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
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
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,697 reads
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
Comments posted to this topic are about the item SQL Server Ghosts