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,215 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,215 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
816 reads
Since I just spent a bit more than half of my 24 Hours of PASSpresentation on tuning queries talking about...
2009-09-11
654 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,808 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
630 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,328 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,665 reads
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
563 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
666 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,325 reads
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Say you need outside help. You’ve exhausted all the things that you could do...
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item BIT_COUNT() III
Comments posted to this topic are about the item The Mythical Bus Accident
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers