SQL Puzzles

SQL Puzzle 7

  • Article

After a gap of sixteen months, Lionel Clarke, the creator of the only 3-D maze game to be written in TSQL, returns with a new SQL puzzle. It is very simple. You have to move as much of the data as you can from the source tables to the destination tables.

2007-11-08

2,661 reads

The T-SQL Quiz

  • Article

Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.

4.82 (11)

2008-05-01 (first published: )

18,092 reads

Blogs

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Convert date value

By pwalter83

Hi, I have a requirement to convert a date value like '7th March 2020' ...

Partitioning table techniques which one is best way?

By Saravanan_tvr

Hello All, I am about to do partitioning for my DW tables based on...

MAXDOP and cost threshold for parallelism settings

By vsamantha35

Hi All, On one of our newly migrated sup-prod azure vm which is running...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers