Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2024-11-29 (first published: 2014-04-07)
50,740 reads
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2024-11-29 (first published: 2014-04-07)
50,740 reads
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
2024-11-15 (first published: 2015-03-17)
8,917 reads
Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.
2024-09-20 (first published: 2013-09-26)
18,725 reads
Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.
2024-07-26 (first published: 2012-08-02)
44,921 reads
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?
2017-02-03 (first published: 2013-10-28)
164,568 reads
Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure
2015-09-18 (first published: 2014-01-20)
38,279 reads
Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype,...
2015-09-08 (first published: 2015-08-28)
81,080 reads
What exactly does this mean? We’ve heard of “code patterns” in other programming languages, but what does it mean to...
2015-06-04 (first published: 2015-05-27)
9,262 reads
There is one software tool that should be in every software developer’s tool chest. That is knowledge of the platform...
2015-05-26 (first published: 2015-05-21)
7,613 reads
Today’s blog will be the second in a multi-part series on replicating Excel functions in T-SQL, continuing with Excel’s NORM.DIST...
2015-05-14
10,765 reads
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Life's Little Frustrations
Comments posted to this topic are about the item When INCLUDE Columns Quietly Inflate...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers