SQL Server uses a proportional fill algorithm when the filegroup has multiple files.  This means it will check the available space in each file an proportionally use each data file...

If you want to be able to calculate or pull information from one Matrix to another (or rather - from a different dataset) - then you can use a LOOKUP...

Depends on how you write the query using the UDF - because it is still an embedded query in the...

Not a comparison I would make. They do different things and will have different uses. Stored...

Use the cross-tab method as outlined by Thom - this does not utilize the PIVOT operator and is much easier to structure, especially when you want to pivot/cross-tab multiple columns.

You can use the aggregates min or max.  You don't have to count or sum.

Max(case when ... then column else '' end)

Hi there,

I would like to know the solution for the error which happened on our DB restoring process this morning. It used to work well to refresh the Dev...

I will use both approaches - depending on what the project requires.  For example - when I want to make sure several processes run parallel - the master/child package approach...

How is the SSH tunnel being opened?  I have seen issues where the calling process - in this case SSIS - is run under a user context that does not...

Not sure those changes will be enough...you need to expand the following:

From (Values (0), (3), (6), (9), (12), (15)) As t(n)

This needs to cover the full length...

You have include the table [ABC_Schema].[ABC2_Table] b - with no join predicates (cross join) and you don't return any columns from that table or filter by any results in that...

You just have to use what I provided and build a cross-tab:

Declare @Warranty Table (WarrantyId int, EffectiveDate Date);
Declare @Claims Table (WarrantyId int, ClaimDate Date);

 Insert Into @Warranty...

SQL Server needed the max amount of memory at some point - and will not return that memory to the OS unless the OS requests it (and you don't have...

First - you have to calculate the quarter start and end dates and name for all relevant quarters for that warranty start date.  Once you have that you left join...

• This reply was modified 6 years, 6 months ago by Jeffrey Williams.

This is not a bug - it is related to the first query that is executed after the stats have been updated.  That first query will generate the execution plan...