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)
51,281 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)
51,281 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)
9,175 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,996 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)
46,411 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)
171,020 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)
40,179 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)
82,100 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,372 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,672 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,828 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers