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,791 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,791 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,507 reads
2001-05-13
2,553 reads
2001-05-13
2,767 reads
2001-05-11
3,001 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,822 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,366 reads
2001-05-11
2,277 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,997 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,443 reads
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Enable a Disabled Index
Comments posted to this topic are about the item Diving Deeper into the Import...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers