T-SQL Tuesday: The Contributing Factor

Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two about how they have made a positive contribution in your life. I’ve known Ewald for 27 years, though we only met two years ago. It’s wonderful that he is hosting this T-SQL Tuesday. My first
-> Continue reading T-SQL Tuesday: The Contributing Factor

Post image

End of Life for Microsoft Windows XP and Server 2003: Six-One or Up

Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an open invitation for attack. XP will, in his words, be “zero day forever”. As you know, Windows XP is the client version of Windows Server 2003, and includes much of
-> Continue reading End of Life for Microsoft Windows XP and Server 2003: Six-One or Up

Post image

Goodbye, old friend

SQL Server 2000, I will miss you. Two months ago, my last customer running on SQL Server 2000 took the plunge, and upgraded to SQL Server 2005. Last night between 9pm and 1:30am this morning, I performed diagnostics on the new environment, and it only struck me today that I would not be supporting SQL
-> Continue reading Goodbye, old friend

Post image

Duplicate Index Finder updated

The SQL Server 2000 Duplicate Index Finder has been updated. I presented the newest version tonight at the SQLskills.com immersion event open night. Grab the scripts here. Changes include a workaround for appending RID and UNIQUIFIER identifiers to indexes. From what I can tell, it is version-complete now. Unless any bugs creep up again, of
-> Continue reading Duplicate Index Finder updated

Remove duplicate indexes in SQL Server 2000

With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many respects, in that SQL Server 2000 does not support included columns, nor disabled indexes, so the scripts themselves were straightforward.
-> Continue reading Remove duplicate indexes in SQL Server 2000

Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000

For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been plaguing us for a while now, and today I made it work, thanks entirely to uber1024. Add this to your SQL Server 2000 instance:

Photo by John Barkiple on
-> Continue reading Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000