Using OVER() to Remove Duplicate Rows
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.
2016-11-08
6,097 reads
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.
2016-11-08
6,097 reads
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,272 reads
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,229 reads
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
8,847 reads
An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.
2009-08-21
10,495 reads
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
How do I check my professional courier status?
I have the following historical wait report for my SQL server. I have noticed...
Comments posted to this topic are about the item Has SQL Server Performance Improved?