2020-02-27
23,514 reads
T-SQL
2020-02-27
726 reads
Introduction to Indexed Views in SQL Server
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
22,045 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
88,915 reads
Handling Aggregations on a Poorly Designed Database
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
3,464 reads
2020-02-14
890 reads
A quick search without an index
Alex Chamchourine explains how he managed to find a row in a billion row table without an index.
2020-02-14
8,091 reads
2020-02-10
1,016 reads
Introduction to PIVOT operator in SQL
Learn how to use the PIVOT operator in SQL in a step-by-step manner.
2020-02-06
13,553 reads
Efficient Solutions to Gaps and Islands Challenges
Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used to analyse baseball winning streaks.
2020-02-06
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
Alamat BCA KCU GREEN GARDEN Telp/WA:0817629933
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
Alamat BCA KCU KEDOYA PERMAI Telp/WA:0817629933
Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5, Kb. Jeruk, Kec. Kb....
Alamat BCA KCU SUDIRMAN Telp/WA:0817629933
Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
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