Transact-SQL

SQLServerCentral Article

Playing popular game of Wordle using T-SQL

  • Article

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

2022-01-19

261 reads

SQLServerCentral Article

Playing popular game of Wordle using T-SQL

  • Article

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

2022-01-19

3,822 reads

Technical Article

Execute on DMVs without user having View Server State

  • Script

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

5 (1)

2020-09-24

1,158 reads

SQLServerCentral Article

SQL Server Name Convention and T-SQL Programming Style

  • Article

There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]

4.67 (9)

2019-12-10

18,330 reads

SQLServerCentral Article

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

  • Article

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

5 (9)

2019-08-08

5,697 reads

Blogs

Daily Coping 20 May 2020

By

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

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

Recover SQL Server 2012 from file backups

By Scott Coleman

In a ransomware disaster recovery situation, we have a physical server that we are...

Running Trace - Error: Login timeout expired

By ramana3327

Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...

query perf issue

By siri_28

Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers