Blog: Grant Fritchey

210 blogs updated: 73 min. ago
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
Query Optimizer and Data Definition Language Queries
Data Definition Language queries don't go through the optimizer, right? While normally, my short answer to this question in the past would h...
10-01-2017 17:16:20 Grant Fritchey SQL Server
OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR hints when...
12-12-2016 16:04:21 Grant Fritchey SQL Server
Database Clone
There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is another. There are even thir...
28-11-2016 17:24:49 Grant Fritchey SQL Server
PowerShell to Test a Query
So you want to do some tuning, but you're not sure how to test a query on it's performance. Not a problem. Here's a very rough script that I...
23-11-2016 16:36:08 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.