Lifehacker

Remove Duplicate Rows in a Google Spreadsheet With This Script

Long spreadsheets with a lot of entries can sometimes mistakenly have multiple instances of the same data. It's easy to remove them in Google Spreadsheet by making a simple script, says MakeUseOf. In ...
Computerworld

LINQ in .NET returning duplicate rows from a working SQL view [SOLVED]

Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...
Ars Technica

T-SQL: Creating a (not quite) duplicate row

Hello, I've got a bit of an unusual request, I want to create some duplicate rows in a SQL Server table. We have a WorkOrders table that has our customer orders in it. Every order has a WOID ...
Ars Technica

T-SQL to remove files older than x days?

I'm having to robocopy SQL 2005 dbs to another server for backup, and the other server is running SQL 2000. What is the T-SQL I need to use in order to delete files older than 'x' days? Since I'm not ...