GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
853 reads
How to use SORT control in SSIS ? TIP #115
Dear Friends,
In the series ofLearn SSIS step by step this is the 5th post. Now from this post we are...
2015-09-24 (first published: 2015-09-12)
2,305 reads
MOVING SYSTEM DATABASES
Below document provides information that can be used for moving system database. However this is not recommended for database installation...
2015-09-12
26,914 reads
Data Needed to Recover SQL server from a Host Crash
Am sure every DBA has once in his/her career come across a situation of recovering a database or an instance...
2015-09-12
294 reads
What happens when you execute a query
When a query is submitted to SQL server it goes through several processing steps. A proper understanding of these steps...
2015-09-12
4,876 reads
SQL Join Algorithms
SQL queries implement various joins when datasets are to be retrieved from one/multiple tables and merged on a certain criteria...
2015-09-12
4,335 reads
Outlier Detection with SQL Server, part 8: A T-SQL Hack for Mahalanobis Distance
By Steve Bolton
…………Longer code and substantial performance limitations were the prices we paid in return for greater sophistication with Cook’s...
2015-09-23 (first published: 2015-09-12)
3,625 reads
Argenis and Ryan
It’s the time of the year when PASS holds its annual elections for the board of directors. This year we...
2015-09-11
866 reads
Fall Means Election Season
While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...
2015-09-25 (first published: 2015-09-11)
865 reads
Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...
2015-09-11
14 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers