Sins of SQL: The Time Table
Steve Gray discusses one of the oldest OLAP techiques for representing the time dimension - and shows why it's a lot easier to stick to DATETIME values.
2010-06-01
13,668 reads
Steve Gray
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Setiabudi No.Telponcs 083831618865
Whatsapp 083831618865 Jl. Dr. Setiabudi No.146, Hegarmanah, Kec. Cidadap, Kota Bandung, Jawa Barat 40114
BCA KCP Pluit Raya Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta...
BCA KCU CIKARANG No tlpon:083138717148
Whatsapp:083138717148. Jl. MH. Thamrin No.163, Cibatu, Cikarang Selatan, Bekasi Regency, West Java 17530
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