Just gonna leave this here:

https://www.mssqltips.com/tutorial/how-to-shrink-the-transaction-log/

Are the execution plans different? I would look there first. And test it out on a dev instance so you can do terrible things like DBCC FREEPROCCACHE, which you should...

Seems like you should be able to CAST the end result of the query to get less precision. The only problem is if you're losing precision in the CTE.

What "one very important step" am I missing? Please elaborate!

Seems to me, I should use a For Each File loop in SSIS, and then inside that, pass the file name...

• This reply was modified 8 months, 2 weeks ago by pietlinden.
• This reply was modified 8 months, 2 weeks ago by pietlinden.

Is the PowerQuery source ever going to work in SSIS? If not, how do I call the PowerQuery refresh in Excel from inside SSIS?

If you're trying to create a running total, use a windowing function.

SUM(1 + COALESCE(Fact0r,0)/100) OVER (ORDER BY PricingDate ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

?

Just make sure your "window" defining...

Got some data instead of just pictures?

Oh, something like this:

SELECT 
roh.itemID, 
roh.[Best Before Date], 
roh.[On Hand],
oa.TotalOrders
FROM REporting.FGMonthlyRiskOnHand roh
OUTER APPLY (
SELECT SUM(SalesOrders) AS TotalOrders
FROM Reporting.FGMonthlyRiskSales mrs
WHERE mrs.ItemID =...

• This reply was modified 8 months, 3 weeks ago by pietlinden.

When you define your CTE, you have to specify the column names...

WITH cteExample (FirstName, LastName, IDNo)
AS
(
SELECT fName, LName, NotMySSN
FROM tableX
)
SELECT FirstName, LastName
FROM cteExample
WHERE IDNo > 10;

If you...

• This reply was modified 8 months, 3 weeks ago by pietlinden.

Use SUM() instead of ROW_NUMBER()?

https://codingsight.com/calculating-running-total-with-over-clause-and-partition-by-clause-in-sql-server/

• This reply was modified 9 months ago by pietlinden.

You don't have anybody building databases in Access do you? That's where I'd look.  My guess is that someone has permissions on your Master Data Services instance that he shouldn't....

the  sp_foreachdb  part?

This may give you an idea... I dumped the result of the query into a temporary table. (Not sure how to parameterize the object name, for some reason.)

            
March 16, 2025 at 7:37 pm
            
#4560844

            
            
                                                
        

This may give you an idea... I dumped the result of the query into a temporary table. (Not sure how to parameterize the object name, for some reason.)

            
March 16, 2025 at 7:37 pm
            
#4560843

            
            
                                                
        

Oh riiiiiiight! (silly me!) ... RedGate has such a tool. (It's a good thing that nobody that works for Red Gate is on here... you know, like Grant or Steve!)

A...

Welcome!  Getting a useful answer can be tricky. So Jeff Moden wrote a great article that explains how to ask a question in such a way that it gets answered....

• This reply was modified 9 months, 4 weeks ago by pietlinden.