Technical Article

Progressive Sums in T-SQL

A common problem in sql is how to calculate and process, for the current row, information that is based on the results (sum, product, difference, etc) of the rows read so far.A solution (we use) to this problem is to create a self join query based on the primary key using the condition of "greater […]

2 (1)

You rated this post out of 5. Change rating

2006-03-23 (first published: )

415 reads

Blogs

Secure Azure SQL Server Backups Using Managed Identities

By

I do believe most people know about the ability to backup your SQL server...

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

By

As AI continues to evolve, many of us are looking for ways to leverage...

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Read the latest Blogs

Forums

Internationalisation

By julian.fletcher

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Size of DB on physical disk doesn't match Disk Usage by Table report

By water490

Hi everyone I am looking at the size of my db on disk (ie...

Getting the TEXTSIZE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the TEXTSIZE

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096
But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers