Finding a table in a huge execution plan is a nightmare. In this SQL in Sixty Seconds video, I show how to find any table in execution plan with SSMS.
LTRIM and RTRIM With Custom Characters in SQL Server 2022
Use LTRIM and RTRIM with custom characters in SQL Server 2022, understand character sets, test TRIM directions, and preserve valid text.
Search a Query Plan for a Table: Find Node and XQuery
Search a query plan for a table with the Find Node feature in SSMS, or with XQuery over the plan XML. A demo query reads one table twice, and both methods find both visits. The post also shows how to save a plan file for later.
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
What is N in nvarchar? – Interview Question of the Week #301
Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.
SQL SERVER – Datatype Decimal Explained – Datatype Numeric
Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works.
Room for an Index Build: Free Space and TempDB Placement
Room for an index build is the free space that your database and tempdb need before the build starts. This post estimates the index, checks both places, breaks a build on purpose, and shows what SORT_IN_TEMPDB moves and what it leaves in your database.