Skip to content

Erik Darling Data

SQL Server Consulting, Education, and Training
  • Home
  • About Me
  • Coaching
  • Blog
  • Contact Me
  • FAQ

Blog

Announcing My Precon For SQL Saturday Washington, DC

November 15, 2019 Erik Darling Leave a comment

HELLO GUAM! If you’re planning on attending SQL Saturday Washington, DC, why not play hooky from work and spend the…

Continue Reading →

Posted in: Server Tuning, SQL Saturday, SQL Server

Stack Overflow Demo Database Column Store Edition: Helpful Links

Erik Darling Leave a comment

Sniff If you’re starting from scratch with column store, here are some links that’ll help you get a better understanding…

Continue Reading →

Posted in: columnstore, SQL Server, Stack Column Store

Stack Overflow Demo Database Column Store Edition: Exploring Relationships

November 14, 2019 Erik Darling Leave a comment

Special Relativity To get you started exploring the Stack Overflow column store database, here are some queries that show how…

Continue Reading →

Posted in: columnstore, SQL Server, Stack Column Store

Stack Overflow Demo Database Column Store Edition: Downloads And Links

November 13, 2019 Erik Darling 3 Comments

Gett Itt If you want to download the database, here’s the magnet link for the torrent. I don’t have another…

Continue Reading →

Posted in: SQL Server, Stack Column Store

Stack Overflow Demo Database Column Store Edition: Making It Bigger

November 12, 2019 Erik Darling Leave a comment

Stack Over Sharing Rather than an F5 script to do this, I decided to make a stored procedure out of…

Continue Reading →

Posted in: SQL Server, Stack Column Store

Stack Overflow Demo Database Column Store Edition Introduction

November 11, 2019 Erik Darling Leave a comment

In The Way Back Machine I really wanted a version of the Stack Overflow data dump that was all clustered…

Continue Reading →

Posted in: SQL Server, Stack Column Store

Are Long Compile Times Bringing You Down?

November 8, 2019 Erik Darling 2 Comments

Rarities I ran into a very funny situation while working with a client recently. They were using Entity Framework, and…

Continue Reading →

Posted in: SQL Server

Startup Expression Predicates And Parameter Sniffing

November 7, 2019 Erik Darling 2 Comments

Sounds Great Startup Expression Predicates can be helpful. They may also exacerbate parameter sniffing issues in similar ways to IF…

Continue Reading →

Posted in: SQL Server

Why Not Exists Makes More Sense Than Left Joins

November 6, 2019 Erik Darling 5 Comments

Checklist This is always fun to talk to people about, because of all the misconceptions around the concept. You need…

Continue Reading →

Posted in: SQL Server

Not In And Nullables

November 5, 2019 Erik Darling Leave a comment

What This Isn’t I’m not writing about how if you use NOT IN, and suffer from NULL values in a…

Continue Reading →

Posted in: Execution Plans, Query Tuning, SQL Server

Post navigation

Page 3 of 30
← Previous 1 2 3 4 … 30 Next →

Recent Posts

  • Waiting For Deadlocks
  • SQL Server 2019 Memory Grants Are Higher
  • Greatest, Least, and SQL Server

Categories

  • Accelerated Database Recovery
  • Batch Mode
  • Bugs
  • CHECKDB
  • columnstore
  • Dynamic SQL
  • Execution Plans
  • FROID
  • Indexing
  • Isolation Levels
  • Joe Obbish
  • Locking
  • Memory Grants
  • Office Hours
  • OPTIMIZE_FOR_SEQUENTIAL_KEY
  • Parallelism
  • Parameter Sniffing
  • perfview
  • Plan Cache
  • Query Tuning
  • Server Tuning
  • Spills
  • SQL Saturday
  • SQL Server
  • SQLBits
  • Stack Column Store
  • Statistics
  • tempdb
  • Training
  • Triggers
  • Wait Stats
Copyright © 2019 Erik Darling Data