Kamran Ali

Eliminating Cursors

T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.

3.67 (81)

2008-06-13 (first published: )

54,728 reads

Blogs

Cursor Dynamic SQL

By

Today was working on SQL Server cursor standard cursor deification would be like this:...

How to get the Active Directory user password policy values

By

Recently I have had to troubleshoot quite a bit of SQL login issues and...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

How does DBCC CHECKDB use tempdb?

By RaufDBA

I would like to know the working principle of DBCC regarding the tempdb. I...

Minimum memory

By WhiteLotus

Hi All , Should we adjust the minimum memory per query (in KB)  in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers