Blog Posts

Blog Post

Where is your Awesome?

Everyone of us is in a perpetual pursuit of awesomeness - some actively looking for it, while others passively. Either way, it is inherent in our making to reach...

2020-09-11 (first published: )

426 reads

Blog Post

Adaptive Joins in SQL Server

SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...

2020-09-10 (first published: )

1,604 reads

Blogs

A New Word: Anderance

By

anderance – n. the awareness that your partner perceives the relationship from a totally...

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Read the latest Blogs

Forums

SQL Server Auditing: Track Changes by Specific Users on Specific Database Tables

By konstantinDBA

Hello Everyone! My organization is looking to implement a solution in SQL Server (2019...

Experimental Verification of the NKTg Law on 8 Planets (NASA 2024 Data, SQL)

By NKTgLaw

Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...

The Yutes

By Grant Fritchey

Comments posted to this topic are about the item The Yutes

Visit the forum

Question of the Day

Tables with a SPARSE Column and Consumption

True or False:  Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.

See possible answers