Blog: Grant Fritchey

210 blogs updated: 67 min. ago
What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change, them, insert new things into the schedule, w...
09-07-2018 17:18:50 Grant Fritchey SQL Server
Plan Metrics Without the Plan: Trace Flag 7412
I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag 7412, we don't need the pl...
11-06-2018 17:04:50 Grant Fritchey SQL Server
Extended Events, the system_health Session, and Waits
I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old Trace Events (aka, Prof...
04-06-2018 17:23:09 Grant Fritchey SQL Server
Query To Retrieve Statistics Data: dm_db_stats_histogram
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced: dm_db_sta...
29-05-2018 16:49:50 Grant Fritchey SQL Server
Adaptive Joins
I was surprised to find out that a lot people hadn't heard about the new join type, Adaptive join. So, I figured I could do a quick overview...
27-02-2018 17:07:49 Grant Fritchey SQL Server
Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI, but it will all be done with the s...
07-08-2017 17:15:46 Grant Fritchey SQL Server
There Is a Magic Button, a Rant
OK guys. I think it's way past time. A bunch of us have been keeping a secret from the rest of you. We know something that you don't. I don'...
01-08-2017 16:48:08 Grant Fritchey SQL Server
Database Fundamentals #4: Create a Database
SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works and have as man...
26-06-2017 16:08:59 Grant Fritchey SQL Server
The Three T's of Backups
I just read several more horror stories that include, among other things, failed backups. I've said it before (at volume, extreme volume), a...
19-06-2017 16:08:26 Grant Fritchey SQL Server
Does Query Store Pre-Allocate Space
I love the questions I get while I'm presenting because they force me to think and learn. The question in the title is one I received recent...
07-02-2017 16:55:45 Grant Fritchey SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.