Using a Variable for an IN Predicate
How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.
2013-03-01 (first published: 2011-06-21)
26,741 reads
Todd Fifield
- Interests: Music Producing/Writing
Key Word Searches
This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.
2012-09-07 (first published: 2011-02-28)
35,574 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Semanggi Telpon/WA:08137887595
BCA KCP Semanggi Telpon/WA:08137887595.Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Bend. Hilir, Kecamatan...
BCA KCP GAMA Telpon/WA:08137887595
BCA KCP GAMA Telpon/WA:08137887595.Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
BCA KCP Palmerah Telpon/WA:08137887595
BCA KCP Palmerah Telpon/WA:08137887595.Jl. Palmerah Barat No.38 A, Grogol Utara, Kec. Kebayoran Lama, Kota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers