Asif Sayed


SQLServerCentral Article

Generating a Sequential Pattern

For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.

2.5 (2)

You rated this post out of 5. Change rating

2006-05-17

9,045 reads

Blogs

SQL Server is Slow, part 3 of 4

By

In parts 1 and 2 of this series, we’ve gathered info and done the...

AI Model Size, Parameters and Download

By

At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...

SplashFlag - Building an IoT Swimming Notification Device from Scratch

By

After setting up dozens of Internet of Things (IoT) smart home devices, I started...

Read the latest Blogs

Forums

caught off guard by some greek lettering in a warehouse feed

By stan

Hi we run 2019 standard.   Our warehouse's ssis based etl is klunky but so...

Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY

By Chandan Shukla

Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...

Vector Datatype

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Vector Datatype

Visit the forum

Question of the Day

Vector Datatype

The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?

See possible answers