Natively Compiled Procedures and Bad Execution Plans
I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...
2014-06-17
1,346 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
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...
2014-06-13 (first published: 2014-06-10)
2,054 reads
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
748 reads
Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,357 reads
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,476 reads
Carolina Cruise
I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...
2014-05-09
491 reads
Speaker of the Month, May 2014
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to...
2014-05-02
1,188 reads
Microsoft Azure Automation
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it...
2014-04-24 (first published: 2014-04-16)
1,778 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,372 reads
I Am Better Than You
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why...
2014-04-22
931 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