You are here |
www.sqlskills.com | ||
| | | |
erikdarling.com
|
|
| | | | ||
| | | |
www.sql.kiwi
|
|
| | | | SQL Server can generate dynamic seek plans, where a seek is driven by Constant Scan and Merge Interval operators. The plans use internal functions LikeRangeStart, LikeRangeEnd, and LikeRangeInfo. Watch out for hidden conversions using GetRangeThroughConvert and GetRangeWithMismatchedTypes. | |
| | | |
littlekendra.com
|
|
| | | | Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps. | |
| | | |
blog.crossjoin.co.uk
|
|
| | I can hear you yawning already - yet another blog post on getting data from multiple Excel workbooks in Power Query and Power BI. Just about everyone who has ever written a blog post on Power BI has written about this subject, including me. However there's a twist this time: what if your Excel workbooks... |