Superman

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Which One is Better? IN or BETWEEN?

by Superman

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

Use Filtered Statistics to Improve Performance on Very Large Tables

by Superman

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

412 reads

What is the CXPACKET Wait Type?

by Superman

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

860 reads

How to Troubleshoot Waiting Tasks Without Requests in SQL Server?

by Superman

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

534 reads

Doing More with Less – My Productivity Guide

by Superman

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

878 reads

How to Size Your Database Files?

by Superman

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

What is Graph Processing in SQL Server 2017?

by Superman

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

582 reads

What is the Automatic Plan Correction in SQL Server 2017?

by Superman

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

644 reads

SQL Saturday Nepal 2017

by Superman

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

504 reads

How to Calculate Running Totals in SQL Server

by Superman

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

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Telp BCA KCP Central Park Cs 0823-74977784

Wa:082374977784 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren, Grogol...

Telp BCA KCP Mandala Raya Cs 0823-74977784

By Layanan_BCA_24jam

Wa:082374977784 Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers