Forcing a Plan That Has a Plan Guide
The question that came up during a recent class I was teaching was: What if you have a plan guide...
2018-12-11 (first published: 2018-11-26)
1,820 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
Privacy and Protection in the Age of the GDPR
We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at...
2018-12-10
241 reads
Query Store and Plan Cache Plans Compared
Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...
2018-12-03 (first published: 2018-11-19)
2,018 reads
Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,238 reads
Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
3,991 reads
What Is Happening, Right Now, At the PASS Summit?
Honestly, that’s a very hard question to answer. I mean, first of all, you can look at the schedule. There...
2018-11-05
207 reads
Why Did a Plan Get Removed From Cache?
I was recently asked if we could tell why a plan was removed from cache. If you read this blog,...
2018-10-26 (first published: 2018-10-22)
1,904 reads
Using Extended Events to Capture Implicit Conversions
Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices....
2018-10-24 (first published: 2018-10-15)
1,807 reads
Database Fundamentals #19: JOINS
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...
2018-10-22 (first published: 2018-10-08)
2,968 reads
Adaptive Joins and Join Hints
At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer...
2018-10-10 (first published: 2018-10-01)
2,724 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Alamat Kantor BCA KCU Wahid Hasyim Telp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...
Alamat Kantor BCA KCU Thamrin Telp:0817825533
Hub Via Wa:62817825533 Alamat: Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng,...
Alamat Kantor BCA KCU Scbd Telp:0817825533
Hub Via Wa:62817825533 Alamat: Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers