Guy Glantser

Which One is Better? IN or BETWEEN?

• by Guy-Glantser

• Guy Glantser

I just had an interesting case of performance tuning: a query with multiple predicates on a very large table. Something...

2018-03-21 (first published: 2018-03-09)

4,057 reads

What is the CXPACKET Wait Type?

• by Guy-Glantser

• Guy Glantser

This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...

2018-03-02

621 reads

Use Filtered Statistics to Improve Performance on Very Large Tables

• by Guy-Glantser

• Guy Glantser

Let’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality...

2018-03-02

349 reads

How to Troubleshoot Waiting Tasks Without Requests in SQL Server?

• by Guy-Glantser

• Guy Glantser

Usually, when I need to troubleshoot currently running requests, I use a combination of sys.dm_exec_requests and sys.dm_os_waiting_tasks. The former retrieves...

2018-02-01

346 reads

Doing More with Less – My Productivity Guide

• by Guy-Glantser

• Guy Glantser

 
Houston, We Have a Problem
 
We are living in a crazy world. And it just gets more and more crazy all...

2018-01-28

825 reads

How to Size Your Database Files?

• by Guy-Glantser

• Guy Glantser

Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you...

2018-01-18 (first published: 2018-01-08)

1,711 reads

What is Graph Processing in SQL Server 2017?

• by Guy-Glantser

• Guy Glantser

There is a growing need for Graph Databases in the market. This is a type of database, which is capable...

2018-01-08

514 reads

What is the Automatic Plan Correction in SQL Server 2017?

• by Guy-Glantser

• Guy Glantser

SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about...

2017-12-25

494 reads

SQL Saturday Nepal 2017

• by Guy-Glantser

• Guy Glantser

 
I had the honor to visit Nepal and participate in SQL Saturday Nepal 2017. You can visit the event website...

2017-12-23

459 reads

How to Calculate Running Totals in SQL Server

• by Guy-Glantser

• Guy Glantser

 
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL...

2017-12-01 (first published: 2017-11-19)

2,819 reads