Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,412 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,812 reads
Carpenters vs. DBAs
Let’s get the caveat out of the way up front, I work for a tool vendor.
If you look around at...
2016-07-05
1,228 reads
SQL Server 2016 is Out and It's Fabulous!
On the First of June, SQL Server 2016 was officially released. While it is still early days to measure the full impact of the release, the one thing that is exceedingly clear is that this is a very successful software release. There have been very few complaints online beyond the standard heard during any upgrade: […]
2016-06-27
153 reads
Because
Because there’s nothing else I can do at the moment.
The post Because appeared first on Home Of The Scary DBA.
2016-06-14
522 reads
Choosing the Right SQL Server Edition
Post #6 of #entrylevel #iwanttohelp in support of Tim Ford’s (b|t) beginner’s initiative.
If you’re just getting started with SQL Server,...
2016-06-13
1,234 reads
Elastic Query in Azure SQL Database and Views
The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...
2016-06-13 (first published: 2016-06-06)
2,136 reads
Resources for Learning Azure Data Platform
You want to start working with Azure and the Azure Data Platform, but getting started is not easy. Just knowing...
2016-06-10 (first published: 2016-06-02)
1,511 reads
Independent Azure Data Platform Instructors
The Azure Data Platform is taking off. I’m seeing more and more interest on the forums, at conferences and in...
2016-06-01
419 reads
Precedence Goes to Query Store or Plan Guide?
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
938 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers