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,784 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,784 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,735 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,855 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
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers