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)
26,547 reads
RBarry Young
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)
30,544 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,382 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,231 reads
2008-08-07
3,836 reads
Blogs
Weekly reading #22
By damianwidera
A little bit late but it is here! It is Wednesday already and we...
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Forums
Evergreen SQL Server
Comments posted to this topic are about the item Evergreen SQL Server
Do you really know what’s happening with your servers?
Comments posted to this topic are about the item Do you really know what’s...
Going from long to wide
Comments posted to this topic are about the item Going from long to wide
Ask SSC