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 Maricaya Hub:Cs.08216977726
Whatsapp:08216977726 Jl. Veteran Selatan No.86, Maricaya Sel., Kec. Mamajang, Kota Makassar, Sulawesi Selatan 90142
BCA KCP Kopo Telp/wa 085169998803
Telp/wa 085169998803 Jl. Raya Kopo No.26 A-B, Panjunan, Kec. Astanaanyar, Kota Bandung, Jawa Barat...
BCA KCU ASIA TELP/CS:083135765355
Whatsapp:083135765355 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec. Medan...
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