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,787 reads
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,787 reads
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,740 reads
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
551 reads
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,041 reads
Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server...
2013-02-18
475 reads
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,552 reads
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,858 reads
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,168 reads
SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements,...
2012-09-30
1,111 reads
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
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers