There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...
2015-09-09
1,294 reads
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...
2015-09-09
167 reads
I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....
2015-09-21 (first published: 2015-09-09)
2,699 reads
One of the interesting things with Redgate’s SQL Data Generator (SDG) is that it allows the user of custom data...
2015-09-18 (first published: 2015-09-09)
1,827 reads
Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it...
2015-09-09
454 reads
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2015-09-28 (first published: 2015-09-09)
1,267 reads
In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing...
2015-09-18 (first published: 2015-09-09)
3,285 reads
Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what events contained within that package might be related to other events.
Related Posts:
How...
2015-09-09
11 reads
I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left...
2015-09-09
995 reads
Working with the default XEvent session and trying to make it more suitable to Enterprise worthy.
Related Posts:
SQL Servers Black Box Recorder - system_health December 29, 2018
Finding Installed Event...
2015-09-09
11 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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