Removing Duplicate Rows
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
2001-05-14
11,788 reads
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
2001-05-14
11,788 reads
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,503 reads
2001-05-13
2,551 reads
2001-05-13
2,725 reads
2001-05-11
3,000 reads
Have an older workstation with only a little hard drive space? Tired of the SQL Server tools taking about a hundred megs on your most precious drive? If you answered yes to either one of those questions, then this quick tip is for you.
2001-05-11
2,821 reads
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,365 reads
2001-05-11
2,266 reads
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
16,972 reads
Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.
2001-05-10
6,413 reads
Dreaming of a data analyst career but feeling a little lost? Already playing with...
I came across a bit of a weird error when I was trying to...
As a Software Engineer, i would like to learn how to dockerize my Python...
I cannot get a snapshot to generate for one of my five publications. The...
Hi Our Physical servers are going to be moved to a new location and...
Comments posted to this topic are about the item Is Perfect Software Attainable?
I run a marked transaction across multiple databases with this code:
BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs' USE sandbox2 INSERT dbo.AddressTable (AddressID, AddressValue, AddressPostal) VALUES (12, '123 three St', '4444') GO USE sandbox3 INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message') GO INSERT sandbox4.dbo.logger (uid) VALUES (700) COMMIT TRAN onemorenewdbTran GOHow many marks are inserted into msdb.dbo.logmarkhistory? See possible answers