Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag cursors Rss

   Items 1 to 13 of 13   
 

Cursors for T-SQL Beginners

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...
By Wagner Crivelini 2011/05/27 (first published: 2009/01/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 22,031 reads

What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)

Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.  Read more...
By Additional Articles 2010/09/01 | Source: Database Journal | Category: cursors
Rating:  Rate this |   Briefcase | 4,548 reads

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!  Read more...
By RBarry Young 2010/07/02 (first published: 2009/04/27) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,906 reads

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.  Read more...
By RBarry Young 2010/06/25 (first published: 2009/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,559 reads

Cursors Be Gone!

A short tutorial on converting cursors to more conventional loops.  Read more...
By Gaby Abed 2010/06/18 (first published: 2008/12/24) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 36,847 reads

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!  Read more...
By RBarry Young 2010/07/02 (first published: 2009/04/27) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,906 reads

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.  Read more...
By RBarry Young 2010/06/25 (first published: 2009/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,559 reads

Avoiding cursors with SQL Server 2005

Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them.  Read more...
By Additional Articles 2009/03/19 | Source: Builder.com | Category: cursors
Rating:  Rate this |   Briefcase | 5,331 reads

Cursors for T-SQL Beginners

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...
By Wagner Crivelini 2011/05/27 (first published: 2009/01/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 22,031 reads

Cursors Be Gone!

A short tutorial on converting cursors to more conventional loops.  Read more...
By Gaby Abed 2010/06/18 (first published: 2008/12/24) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 36,847 reads

SQL Server Cursor Examples

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?   Read more...
By Additional Articles 2008/10/21 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,228 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton 2008/10/10 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 569 reads

DB Connection Killer

This script opens a little cursor that will clean out connections to any DBs you specify.  Read more...
By Miguel Pereira-543757 2008/09/09 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 1,314 reads
   Items 1 to 13 of 13   
 
Tags
t-sql (5)    
performance tuning (2)    
while loop (2)    
blocking (1)    
data generation (1)    
execution plans (1)    
fetch (1)    
loop (1)    
random numbers (1)    
spid (1)    
test data (1)