No Join Predicate
You could be looking at an execution plan on a query and see this message: Warning, No Join Predicate. With...
2009-09-15
3,192 reads
You could be looking at an execution plan on a query and see this message: Warning, No Join Predicate. With...
2009-09-15
3,192 reads
My first one over there. It’s discussing whether or not you should do two things, build your own monitoring tool,...
2009-09-14
811 reads
Since I just spent a bit more than half of my 24 Hours of PASSpresentation on tuning queries talking about...
2009-09-11
650 reads
I got the question the other day, when are you likely to see a spool in an execution plan? Easy,...
2009-09-09
2,769 reads
The new book is up on Amazon. I only worked on three chapters of Rob Walter’s new book and that...
2009-09-04
622 reads
I haven’t done well with this. I missed a post. I missed a bunch of workouts. I put on weight....
2009-08-29
1,326 reads
We’ve received wonderful support from the community. Brad McGehee has a list with great people on it who have volunteered...
2009-08-29
1,655 reads
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
561 reads
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
661 reads
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,322 reads
By Steve Jones
Rodney Kidd took some great shots of the keynote and published an album here:...
By Brian Kelley
here is the compiled video of the Red Teaming course Microsoft put together.
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
Hi all, Has anyone encountered an issue whereby using a distributed availability group...
hi, i have seen in my server sometimes some SPIDs get stuck. so we...
Recently I was asked to investigate the update statistics process on a particular database....
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers