Tally Tables in T-SQL
The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a...
2014-03-27
56,581 reads
Dwain Camps
Getting an INDEX SEEK to Speed up LIKE “%string%” Searches
In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow...
2014-03-26
20,689 reads
Common Table Expressions in SQL
In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE). CTEs share similarities with VIEWS and derived tables, but...
2014-03-23
1,605 reads
The T-SQL ROW_NUMBER() Function
If you learn one new T-SQL (i.e., Microsoft SQL Server) concept today it should be ROW_NUMBER(). Introduced in SQL 2005,...
2014-03-22
2,964 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,698 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,080 reads
2014-01-09
2,342 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,361 reads
2013-09-03
2,456 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,571 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers