I ran into this error recently while trying to clone a production database:
Msg 2601, Level 14, State 1, LineNumber
Cannot insert duplicate...
2018-11-02 (first published: 2018-10-24)
2,512 reads
Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...
2018-09-24
242 reads
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...
2018-09-24 (first published: 2018-09-13)
3,189 reads
“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the...
2018-09-05 (first published: 2018-08-17)
3,022 reads
Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...
2018-08-24 (first published: 2018-08-12)
1,999 reads
Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...
2018-03-05
411 reads
It’s that time of year again: time to make resolutions, then try to stick to them. Sure, we could start...
2018-01-09
418 reads
The obesity epidemic is much in the news these days. The list of health issues related to being overweight is...
2017-12-27 (first published: 2017-12-13)
1,747 reads
I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...
2017-12-18
340 reads
Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...
2017-12-06 (first published: 2017-11-27)
1,561 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers