/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 markcarrington.azurewebsites.net
New FetchXML Features and Documentation - Mark Carrington
| | joeydantoni.com
Using SQL Sentry Plan Explorer to Shed Light on Estimated Execution Plans - The SQL Herald
16.5 parsecs away

Travel
| | Note: While I do have business relationships with many vendors, I do not have one with SQL Sentry aside from attending their great annual party at the PASS Summit. SQL Server allows us to have access to two types of execution plans, estimated and actual. Actual execution plans give us the real row counts and...
| | sqlnikon.com
Virtual Book Club: SQL Server Execution Plans, Chapter 4 - SQLNikon
18.6 parsecs away

Travel
| | [AI summary] The author reviews Chapter 4 of the SQL Server book 'SQL Server Execution Plans,' discussing complex query concepts, execution strategies, and personal insights into T-SQL optimization.
| | markcarrington.dev
Inside FetchXML pt 2 - link-entity - Mark Carrington
4.8 parsecs away

Travel
| | To combine data from different records in your query you need to use the element. This is equivalent to a join in SQL. Each needs 3 key pieces of information: The entity type to link to The attribute in the main entity to join from The attribute in Continue Reading
| | tsqltuesday.azurewebsites.net
T-SQL Tuesday #158, Implementing Worst Practices - T-SQL Tuesday
30.0 parsecs away

Travel
| [AI summary] This post invites database professionals to share personal experiences and justifications for implementing non-standard or historically discouraged T-SQL practices in specific edge cases.