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
Mike McQuillan
Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,272 reads
Guide to MCITP: SQL Server 2008 BI Developer
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,229 reads
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
8,847 reads
Guide to MCITP: SQL Server 2008 Developer
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
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
How do I check my professional courier status?
How do I check my professional courier status?
Significance of Historical waits report in SQL server Performance dashboard
I have the following historical wait report for my SQL server. I have noticed...
Has SQL Server Performance Improved?
Comments posted to this topic are about the item Has SQL Server Performance Improved?
Ask SSC