CCI – Data Loading considerations with Partitioned Tables and CCI
Introduction
In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a...
2018-10-10
254 reads
Introduction
In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a...
2018-10-10
254 reads
Intro
In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time...
2018-09-26
140 reads
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
173 reads
Intro
I would like to start a miniseries of blogs where I try to summarize lessons learned from large data loading...
2018-09-03
60 reads
Intro
Intro
I have recently faced the issue of handling big numbers in SSAS Tabular. Our SSAS model processes accounting data for...
2018-07-27
277 reads
Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...
2018-05-23
90 reads
Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...
2018-01-31
130 reads
What are the limits?
What are the limits?
Of course, as a follow-up to my last article you might ask at least...
2017-11-29
133 reads
Issue
Recently we came across an interesting issue. I guess this will not happen often, but I think it’s worth mentioning...
2017-11-20
64 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers