best practices in SQL Archives

Using APPLY with Table-Valued Functions

Posted on May 7, 2025May 7, 2025 by Zubair Shaik

1 Restrictions on APPLY in Certain SQL Queries** Certain queries may not allow APPLY to function as expected. For example, APPLY cannot be used in views with an INSTEAD OF….

SQL Server

Naming Conventions for Tables and Columns

Posted on April 29, 2025April 29, 2025 by Zubair Shaik

Certainly! Crafting a comprehensive guide on database table and column naming conventions is essential for maintaining clarity, consistency, and scalability in database design. Below is an extensive exploration of best….

SQL Server

PATINDEX vs CHARINDEX

Posted on April 28, 2025April 29, 2025 by Zubair Shaik

PATINDEX vs CHARINDEX: A Detailed Comparison In SQL Server, string manipulation is an essential aspect of working with textual data. Often, one of the most common tasks when dealing with….