Sorry for not minding my own business, but what if you created a schema for the temporary objects? Then when you're sure you're done with them, just use DROP SCHEMA.

...

DROP...

Maybe this hints at what's going on?

https://blog.greglow.com/2019/02/26/sql-text-vs-varcharmax-in-row-vs-out-of-row-storage/

It might be that the varbinary(8000) is stored outside the row of your table, so when you do not include that column in your...

Phil,

does that fix the problem if you're using the import wizard from within SQL Server?

Thanks!

Pieter

CSV and Excel you can pretty much use the Import Data stuff... just fires up SSIS and runs the wizard. You can also use something like BULK INSERT to do...

Oh I'm an idiot.

Create separate PowerQueries that read a single table and clean all that junk. (Just duplicate the query instead of referencing it). Then have one return the Purchases...

Never heard of any of those file types (are they?), but generally speaking, the pattern for ingesting data into PowerBI is

1. filter for a specific file type.

2. use PowerQuery to...

Looks like you would have to put all the items you want backed up into one or more filegroups (so that you can leave out the ones you do not...

CROSS APPLY is analogous to INNER JOIN <table-valued function> and OUTER APPLY is analogous to OUTER JOIN <table-valued function>.

That was easy!

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 6 months, 3 weeks ago by pietlinden.
• This reply was modified 6 months, 3 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 6 months, 3 weeks ago by pietlinden.