TempDB memory leak?

I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a...

2016-01-05

1 reads

Advent of Code

If you want your skills to be sharp, you practice.  If you want to get yourself to actually do practice,...

2016-01-04 (first published: )

1,536 reads

Indexing Strategy

What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...

2015-12-28 (first published: )

3,463 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

RTO 15 minutes with differential backups

By DBANewbie

Hi. I'm working through the official exam reference book for 70-764 by Isakov and...

Towards an efficient interface between application and database

By Phil Factor

Comments posted to this topic are about the item Towards an efficient interface between...

How to handle date on temp table when is null or not ?

By ahmed_elbarbary.2010

How to handle date on temp table when is null or not ? I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers