When naming transactions causes an error
For the last part of the series on transactions, I’m going to look at a problem that I ran across...
2015-12-21 (first published: 2015-12-15)
2,586 reads
For the last part of the series on transactions, I’m going to look at a problem that I ran across...
2015-12-21 (first published: 2015-12-15)
2,586 reads
Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...
2015-12-04 (first published: 2015-12-01)
5,921 reads
This is the second in a short series on transactions. In the previous part I discussed nested transactions and showed...
2015-11-20 (first published: 2015-11-17)
3,442 reads
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
880 reads
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,848 reads
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,439 reads
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,145 reads
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...
2015-09-08
1,190 reads
There are many, many guides to successfully completing a post grad degree, so I am not going to add to...
2015-08-11
604 reads
Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/
By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...
2013-09-04
2,111 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