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,797 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,777 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
479 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,560 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,877 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
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Forums
Personal Contact Is Vital
Comments posted to this topic are about the item Personal Contact Is Vital
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers