The MATCH clause finds rows in SQL Server graph tables by describing the path between them. The small graph runs one hop, two hops, a shared skill and a SHORTEST_PATH query, compares the plain join, and shows what the MATCH clause does not allow.
TSQL_SCALAR_UDF_INLINING: How to Disable Scalar UDF Inlining
TSQL_SCALAR_UDF_INLINING is the database scoped setting that switches scalar UDF inlining off. This post builds a demo database, proves with execution counts that inlining is on or off, and shows the narrower switches at function and query level. It ends with the undo statement.
Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276
Question: Where to Download SQL Server 2019 for FREE?
Answer: This is one of the most popular questions, I keep on receiving from blog readers.
OPTIMIZE_FOR_SEQUENTIAL_KEY: Test the Last Page Insert Fix
OPTIMIZE_FOR_SEQUENTIAL_KEY is an index option that targets last page insert contention. This post tests it with 32 connections that insert into a clustered identity key, with the option off and on. The option changes the kind of waiting, and the post shows how to decide whether it helps your table.
SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights
In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.
ANSI_WARNINGS OFF: Why SQL Server Truncates Data Silently
With ANSI_WARNINGS OFF, SQL Server cuts a string to fit its column and reports no error. This post runs the same insert with the setting on and off, and shows what else changes: variables, divide by zero and filtered indexes. It also shows how to check which setting a session uses.
TempDB Metadata Tables: Check, Enable and Count Them
The tempdb metadata tables can live in memory, and four short steps tell you whether yours do. This post checks the setting, shows how to turn it on and off, and counts the tables SQL Server moves. It also says when the feature is worth a restart.