Jeff Moden

What's in your CLR?

For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.

3.14 (7)

2017-08-11 (first published: )

632 reads

A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!

4.89 (36)

2015-10-23 (first published: )

13,612 reads

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".

4.9 (60)

2014-09-19 (first published: )

20,372 reads

How to Make Scalar UDFs Run Faster (SQL Spackle)

It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.

4.93 (102)

2014-06-24 (first published: )

19,333 reads

Blogs

T-SQL Tuesday #116 Roundup – SQL on Linux

By

This month’s topic is wide open to anything you could think of that had...

Adding a Column with a Default Constraint

By

Last week a question came up about adding a column to a table, and...

Rename Azure VM OS Disk

By

In a recent post about creating Azure VMs using PowerShell, I noted a common...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Query to check the latest windows patch detaisl and last reboot

By ramyours2003

i need a query to check the latest windows patch details and last reboot ...

Remove SQL Server from Failover Cluster

By SJD

Hi, I'm having a problem with a Windows Server 2008 R2 Failover Cluster with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers