2023-09-04
400 reads
T-SQL
2023-08-28
372 reads
Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
2023-08-28
Ordered Columnstore Indexes in SQL Server 2022
One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is not enforced by any SQL Server process. This leaves managing data order to us, which may or may not be an easy task.
2023-08-09
2023-08-09
406 reads
2023-08-07
356 reads
2023-08-04
465 reads
2023-07-31
511 reads
2023-07-28
612 reads
2023-07-24
581 reads
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 Duta Gardenia Telp:Cs.08216977726
Whatsapp:08216977726 Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda,...
BCA KCP Tebet Barat 2 No.telp:083834809483
Jl. Tebet Raya No.25 B Blok CI, Tebet Tim., Kec. Tebet, Kota Jakarta Selatan,...
BCA KCP Kas Pusat Grosir Surabaya Telpon. 083135766741
WhatsApp 083135766741 Pusat Grosir Surabaya, Blok B/3, No 16/17, Tembok Dukuh, Bubutan, Surabaya, East...
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