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,095 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)
33,447 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,353 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,664 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
10,002 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,356 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,553 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,358 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,243 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,379 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers