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

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

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!