A reader said he uses a CTE to control join order. Does a CTE change the order of join in an inner join? Here is what I found.
SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text
Turning on graphical execution plan output requires resetting SHOWPLAN and checking the SSMS actual-plan option. These examples explain batch separators, estimated plans, and actual XML output.
Assertion Queries: Data Checks That Should Return Zero Rows
Let a short query find the order with no lines before a customer does. A small demo shows the failing keys, constraint error 547 and a clean repair.
MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET
FIND_IN_SET searches a comma-separated string for a complete member and returns its position. I keep whitespace in that string deliberate.
SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020
Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.
SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer
Can you retrieve the last inserted rows from a table with no identity or date column? Here is my chat with Dustin on a question with no good answer.
Buffer Cache Hit Ratio: Why a Healthy Number Can Lie
A 99 percent ratio does not mean your memory is fine. Here is how to read the counter correctly and what to check beside it.