SQL Puzzles

SQLServerCentral Article

Finding Primes

  • Article

While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.

4.33 (6)

You rated this post out of 5. Change rating

2008-01-01 (first published: )

7,352 reads

SQLServerCentral Article

SQL 2000 DBA Toolkit Part 3

  • Article

Phonetic matching, working on finding terms that are misspelled, is an art and there are a number of ways to handle it. In SQL Server 2000 the tools are limited, but Michael Coles brings us part 3 of his toolkit with some handy functions that can help you with text searching.

You rated this post out of 5. Change rating

2006-04-27

16,853 reads

SQLServerCentral Article

Practical Uses of PatIndex

  • Article

String manipulation is not one of the strong points of T-SQL, but there are some functions that can greatly assist you with searching and working with character values. New author Robert Davis brings us a look at PATINDEX, one of the search functions and also explains the differences between it and the often used CHARINDEX.

4.5 (6)

You rated this post out of 5. Change rating

2006-02-06

20,360 reads

SQLServerCentral Article

Eliminating Cursors

  • Article

T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.

3.67 (81)

You rated this post out of 5. Change rating

2008-06-13 (first published: )

55,130 reads

SQLServerCentral Article

The GO Command and the Semicolon Terminator

  • Article

There are probably not many SQL Server DBAs that use the semicolon as a statement separator. In SQL Server 2005, this is required in certain places and new author Kenneth Powers brings us a look at where and why you need to use this syntax.

4.23 (22)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

45,437 reads

Blogs

The Data API Builder Start and Add Extensions in VS Code

By

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Read the latest Blogs

Forums

AD, powershell and ssis

By stan

Hi, i have a requirement that involves visiting multiple folders in AD for active,...

File date from Extended Event .xel files

By Michael L John

I know this, but I do not remember it. I have scoured by saved...

SSMS gets very messy

By oRBIT

At work we have quite a few databases that I'm frequently browsing. This is...

Visit the forum

Question of the Day

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

See possible answers