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,323 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,323 reads
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,296 reads
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,265 reads
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
8,894 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,545 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Hi All, I installed reporting services evaluation edition for testing purpose, but now 180...
Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are...
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...