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,285 reads

Blogs

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

SQL Saturday Oregon & SW Washington 2024

By

Wow I am so late in posting these notes! But this conference was amazing,...

Challenges Enterprises Face When Adopting AI

By

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Sparse Column Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Storage

The Managed Cloud Database Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Managed Cloud Database Options

Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 6...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers