A dynamic SQL output parameter lets a statement built at run time hand a value back to the caller. This post shows input, output and input/output parameters with sp_executesql, explains the errors you meet, and measures why parameters beat concatenation: one reusable plan instead of ten, and no injection.
Remove Bookmark Lookup – SQL in Sixty Seconds #089
We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.
Azure SQL Firewall Rules: List, Add and Remove With T-SQL
Azure SQL firewall rules decide which IP addresses can reach a logical server and its databases. This post lists the server-level and database-level rules with T-SQL, adds, changes and removes one, and explains how to find the address Azure sees. It also covers the one thing T-SQL cannot do, which is let you in for the first time.
How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285
Question: How to Generate Script for SQL Server 2005 from SQL Server 2019?
Answer: Actually, I got this question from my client.
SQL SERVER – Boost SQL Server Priority and SSMS 18
Boost SQL Server Priority appeared in the historical SSMS 18.5.1 interface. I showed where to inspect that engine setting.
Identify Index Used for Query – SQL in Sixty Seconds #088
How do you identify index used for query? It is a popular question in my health checks, and this SQL in Sixty Seconds video shows the easy way.
Count TempDB Data Files: Five Ways to Check in SQL Server
You can count tempdb data files with the Properties window, three queries or the error log. This post shows all five checks with their results, explains what each one reads, and compares the count with the number of CPUs. It also covers the case where the Properties window won’t open.