Monthly Archives: December 2014

Table-Valued Functions and Cursors Performance

Another performance issue identified was the use of Cursors when applying Table-Valued Functions to large datasets, whereby the TVF was applied to each individual record using a cursor, e.g. to split delimited strings into lists: DECLARE @string_table TABLE ( string VARCHAR(MAX) ); INSERT INTO @string_table VALUES (‘the,first,string,of,several’) ,(‘this,is,another,string’) ,(‘the,last,string’) ,(…); — Cursor method: DECLARE @string […]

Kevin Kline

Career and Technical Advice for the IT Professional


Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert


A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!