Dimensional Modelling Case Study Part 1 - Age Group
Learn how you can handle dimensional modeling in a data warehouse when your data uses different categorization for ages.
2024-01-12
1,224 reads
Articles
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” In that post, I talked about how we can use SQL Server’s metadata to instantly retrieve the row count for a table.
2024-01-12
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2024-01-11 (first published: 2022-09-01)
2,209 reads
Adding Cookie Consent to SQL Server Central
We are adding a consent form to the SQL Server Central website to allow our cookies.
2024-01-10
1,035 reads
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
Learn about the benefits of mixed extent allocation in SQL Server 2016, along with how you can check this setting or enable it in your database.
2024-01-10
944 reads
2024-01-10
66 reads
Connecting SQL Server to SaaS applications with a Linked Server
But nowadays, most services are in the cloud. They're not on your servers; they're somewhere else. With most software-as-a-service (SAAS) offerings, you don't have many options to configure connectivity. What if you need data from one SaaS service into another?
2024-01-10
Getting Started with Azure Data Studio
Azure Data Studio (ADS) is a cross platform query tool for SQL Server. Learn how to get started using ADS to work with your SQL Server instances.
2024-01-09 (first published: 2019-03-04)
6,453 reads
The Profiler Extension in Azure Data Studio (ADS)
This article covers the basics of the Profiler extension in Azure Data Studio, a handy way to trace your application calls.
2024-01-09 (first published: 2023-12-29)
1,211 reads
Using Azure Data Studio with Git
In this article, we will examine how to use Azure Data Studio with a git repository for storing code.
2024-01-09 (first published: 2019-05-14)
9,479 reads
Blogs
Troubleshooting SQL Server Error 8623: The query processor ran out of internal resources and could not produce a query plan
By SQLPals
SQL Server Error 8623 At least once day, an application for...
Friday Flyway Tips–The Version Control Blade
By Steve Jones
The Flyway Desktop Version Control tab is gone and a new blade has appeared...
A New Word: Candling
By Steve Jones
candling – v. intr. the habit of taking stock of your life on the...
Forums
Play To Your Strengths
Comments posted to this topic are about the item Play To Your Strengths
FTS Catalogs Set to Case Sensitive True/False
I understand what the setting means for Collation Sequences and the impact it has...
XML path running slow
This is the sub query being used in the join and it's timing out....
Question of the Day
Rounding Numerics
I have this code on SQL Server 2019:
SET ARITHABORT ON; GO DECLARE @result DECIMAL(5, 2), @value_1 DECIMAL(5, 4), @value_2 DECIMAL(5, 4); SET @value_1 = 1.1234; SET @value_2 = 1.1234 ; SELECT @result = @value_1 + @value_2; SELECT @result; GOWhat setting of NUMERIC_ROUNDABORT will return an error from this code? See possible answers