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 Altira Sunter Tlp (+62 821°3111°179
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, Sunter Jaya, Kec....
BCA KCP Purwosari No tlpon:083138717148
Whatsapp:083138717148.Solo Center Point, Ruko No. A11 & A12, Sondakan, Kec. Laweyan, Kota Surakarta, Jawa...
BCA KCP Banda No.Tlp.083179431643
Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat 40115
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