except sql

SQLServerCentral Article

How to filter non-existing records in SQL

  • Article

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4.22 (9)

You rated this post out of 5. Change rating

2021-11-26 (first published: )

14,356 reads

Blogs

When It’s Still Viable

By

If a technology is still viable, don’t overlook it. Don’t get caught up chasing...

T-SQL Tuesday #179: The Detective’s Toolkit

By

It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

Read the latest Blogs

Forums

Starting to Estimate Disk Storage for Memory-Optimized Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting to Estimate Disk Storage...

Keep. It. Simple.

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Keep. It. Simple.

case statement with and like operators

By Wren

Hello, I'm trying to remove results from this sql statement where the custid like...

Visit the forum

Question of the Day

Starting to Estimate Disk Storage for Memory-Optimized Tables

If I have durable memory-optimized tables, what is the starting point for estimating storage space?

See possible answers