User Defined Function (UDF)

A User-Defined Function returns more rows

  • Article

The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]

4 (5)

2019-10-14

4,187 reads

Tokenizing a String Using PARSENAME

  • Article

SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting.

1 (1)

2004-12-27

10,303 reads

Blogs

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Steps for a Successful Data Migration Session at Microsoft Ignite

By

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Query execution plan sort operation

By yuvipoy

Hi All, Could you please let me know what could be the cause of...

Using mode() in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using mode() in R

Machine Learning Services on Database Server verses R Lang Execution on Laptop

By HookSQLDBA7

We are running SQL Server 2017 (RTM) on Windows. The question came up, if...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers