There Must Be 15 Ways To Lose Your Cursors… Part 2
Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!
2010-07-02 (first published: 2009-04-27)
28,417 reads
RBarry Young
- Interests: Programming, Design, SQL, Mathematics, Logic, Set Theory, mentoring, Effective Knowledge Transfer, Speaking, Sci-Fi, Theology, Peace, Love and Understanding.
There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction
Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.
2010-06-30 (first published: 2009-04-14)
34,101 reads
The Sixty-Second Guide to becoming a SQL Server DBA
So you want to be a DBA, but don't know where to start learning what you need to know? R. Barry Young brings you a sixty second guide for how to get moving.
2009-12-04
16,534 reads
Just For Fun: An Impossible Delete
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
2009-10-30 (first published: 2008-08-05)
32,597 reads
2008-08-07
3,854 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers