2014-02-28 (first published: 2011-02-16)
13,761 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
16,240 reads
Calendar Tables
Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.
2014-02-14 (first published: 2010-07-15)
43,786 reads
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
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 Sampoerna Strategic Square Telpon/WA:08137887595
BCA KCP Sampoerna Strategic Square Telpon/WA:08137887595.Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A...
BCA KCP Pluit Mega Mal Tlpn/Wa 0853.7373.7551
Jl. Pluit Permai No.Raya 60, Pluit, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta...
BCA KCP Sudirman Mansion Telpon/WA:08137887595
BCA KCP Sudirman Mansion Telpon/WA:08137887595.Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G...
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