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,955 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,955 reads
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,396 reads
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,400 reads
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
9,010 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,654 reads
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers