The Axis Of Evil
Views, table variables and local variables are great in terms of programming principles.
But In terms of performance, they can be...
2013-03-25 (first published: 2013-03-20)
2,796 reads
Matan Yungman
Do You Know sys.dm_exec_text_query_plan?
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...
2013-03-19 (first published: 2013-03-12)
2,769 reads
On Trends And Proportions
Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to...
2013-03-05
552 reads
SQL Server Videos
About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.
Today, I want...
2013-02-26
1,042 reads
Things You Can Find In The Plan Cache
Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server...
2013-02-18
477 reads
SQL Server Podcasts
Photo credit: Digitalnative
About a year ago, I came across an online deal for a car stereo system with a USB...
2013-02-14
1,555 reads
Querying Execution Plan XML For Inaccurate Row Count Estimates
I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty...
2013-01-31
1,876 reads
What Queries From The Application Do To Your Plan Cache
Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query...
2013-01-09
1,172 reads
Small Changes Can Make A World Of Difference
SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements,...
2012-09-30
1,113 reads
What I Expect From 24 Hours Of Pass
24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time.
I expect to:
Have little to no...
2012-09-19
523 reads
Blogs
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...
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell 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