Do you know if the log file is increasing significantly during the data import? I think 'bulk logged' recovery mode is sometimes used in this situation. Sorry I can't...

just wanting to check - 20GB purely for OS and 18 purely for SQL - so a total of 38GB ?

Thanks for that posting - it was a good reminder that we have to be more cautious and less trusting when traveling. I'd like to thing everyone is as...

DOH!!!! double facepalm moment

multiple copies of management studio open (I have v17 because it still has debug mode and v18 because I have sql2019)

executed a query thinking it was on...

looks like it's tried to apply "parallelism" (not quite the correct word, but it will do) to the function - this is possibly a result of the new scalar...

this sounds like a buffer cache issue - sometimes fast, sometimes slow, depends on if it is in cache...if not then it could be a recompile?

How much RAM on that...

looks like it's tried to apply "parallelism" (not quite the correct word, but it will do) to the function - this is possibly a result of the new scalar value...

big difference in the plans - it explains quite a lot

scrap that - I tried it and it's still an issue

looks like the assertion to the return variable is stopping at the first row within  a scalar function (ask Microsoft)...

Hi Grant,

That's the point, the statement does include an ORDER BY.

See my first post.

CREATE FUNCTION [dbo].[fnTest]()
RETURNS int
AS
BEGIN
       declare @myNumber INT;
...

This isn't what I'd call a change in behavior. It's always been stated, for decades now, that you can't rely on the order of rows without an ORDER BY...

be careful with the money data type - Vietnamese Dong tend to overflow after a certain value. (i'm talking building a hospital costs, not buying a chocolate bar)

one word "bitlocker", we've had laptops stolen - lesson learned!!! - even our company approved USB sticks have encryption now

but i still don't quite get Encryption at rest for sql

if space is the issue then look at stretch to azure - it's not cheap but it is a monthly cost that offsets you buying a new SAN/Server - and...

but why only in functions ?

i'm starting to worry quite a bit of code now - given that we are upgrading in the next 3 weeks