Performance Tuning OLAP Reports
Reports that use an Analysis Services cube as a data source can often have performance problems during pre-execution. Before you...
2009-11-09
3,075 reads
Devin Knight
SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,777 reads
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2009-11-07
854 reads
Basic SSIS Interview Questions
I have decided to make a short series of blogs about possible interview questions to help you prepare for an...
2009-11-07
1,951 reads
Answers to Basic SSIS Interview Questions
This is just a starting point for you to prepare for your interview so make sure not to limit yourself...
2009-11-07
2,324 reads
Answers to Advanced SSIS Interview Question
Last week I wrote a set of Advanced SSIS Interview Questions. Here are the answers I came up for these. ...
2009-11-07
2,010 reads
Better Know A SSIS Transform – The Pivot Transform
This is part 1 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-11-07
741 reads
Better Know A SSIS Transform - The Sort Transform
This is part 2 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-11-07
1,512 reads
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-11-07
954 reads
Better Know A SSIS Transform – Conditional Split
This is part 3 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-11-07
1,153 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers