StingyJack

  • Interests: Music, Animals, Computers.

Technical Article

sp_what

This is a replacement for SP_who and modification of sp_who2. It will always list only active, nonsystem processes, and will list the number of seconds a transaction has been running for. Some transactions do not report a last batch time, so I forced a large value to display so you can see any issue with […]

5 (1)

You rated this post out of 5. Change rating

2006-10-02 (first published: )

2,302 reads

Blogs

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Beginner’s Guide: Create a File Organizer CLI Tool in Rust

By

Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Read the latest Blogs

Forums

How Many Can Be the Greatest

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Many Can Be the...

How to process images and analyze charts with AI

By Daniel Calbimonte

Comments posted to this topic are about the item How to process images and...

Patching the Patch

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Patching the Patch

Visit the forum

Question of the Day

How Many Can Be the Greatest

I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:

select GREATEST( col1, col2, col3, ...)

See possible answers