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)
27,197 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-25 (first published: 2009-04-14)
31,889 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,399 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,345 reads
2008-08-07
3,840 reads
Blogs
How to Design Backups in SQL Server?
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Daily Coping 23 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Getting Up and Running with Dapr
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
Forums
The OPENJSON return schema
Comments posted to this topic are about the item The OPENJSON return schema
Thank a Mentor
Comments posted to this topic are about the item Thank a Mentor
Create an RPA Flow that Connects to Oracle Data in UiPath Studio
Comments posted to this topic are about the item Create an RPA Flow that...
Ask SSC