Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Using a MEMORY table as an array

By well0549,

I liked the script of using a table as an array. But Didn't liked the cursor in it so I rewrote the script so that it uses a memory table.

I tested it in the Query analyzer and this one is indeed faster. So all the people out there yelling that a memory table is faster than a cursor could be right.....

I say could be because the memory table variant has less statements in it.......

Total article views: 1155 | Views in the last 30 days: 2
 
Related Articles
FORUM

memory

memory

FORUM

Memory

Memory

FORUM

Memory

Memory

FORUM

Confused on memory

memory

FORUM

memory

MS Fulltext search memory and SQL 2005 memory configuration

Tags
miscellaneous    
 
Contribute