Blog: Brent Ozar

210 blogs updated: 42 min. ago
How Trace Flag 2335 Affects Memory Grants
This trace flag is documented in KB #2413549, which says, "Using large amounts of memory can result in an inefficient plan in SQL Server." T...
15-08-2018 16:13:59 Brent Ozar SQL Server
A Common Query Error
So Many Choices When you only need stuff from a table where there's matching (or not!) data in another table, the humble query writer has ma...
14-08-2018 16:07:47 Brent Ozar SQL Server
Setting Up SQL Server: People Still Need Help
I Like What's Happening I wanna start off by saying that I like what Microsoft has been doing with the setup process it made a lot of sense ...
13-08-2018 15:42:44 Brent Ozar SQL Server
[Video] Office Hours 2018/8/8 (With Transcriptions)
This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU s...
12-08-2018 17:38:04 Brent Ozar SQL Server
First Responder Kit Release: A Year From Now These Will All Stop Working On 2008 And 2008R2
You think I'm kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the updated here. sp_Blitz Imp...
10-08-2018 22:56:26 Brent Ozar SQL Server
The First 3 Things I Look At on a SQL Server
1. Are backups and CHECKDB being done? Before I step out on the wire, I want to know if there's a safety net. If there's a recoverability ri...
10-08-2018 15:55:43 Brent Ozar SQL Server
How to Check for Non-Existence of Rows
You're writing a query, and you wanna check to see if rows exist in a table. I'm using the free Stack Overflow database, and I wanna find al...
09-08-2018 15:47:13 Brent Ozar SQL Server
Why Does My Select Query Have An Assert?
You And Ert This is a quick post because it came up with a client. I like having stuff to point people to that's sort of like automation, ri...
08-08-2018 16:14:41 Brent Ozar SQL Server
A Visual Guide to Choosing an Index Type
Warning: I'm about to overly simplify a whole lot of topics to make things easy. Armchair architects, warm up your flamethrowers. Your table...
07-08-2018 16:27:27 Brent Ozar SQL Server
Two Important Differences Between SQL Server and PostgreSQL
SQL ConstantCare uses PostgreSQL as a back end specifically, AWS RDS Aurora so I've spent a lot of time writing Postgres queries lately. Her...
06-08-2018 15:44:36 Brent Ozar 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.