Hi from the north of England

I take breaks too which makes it easier - I have also been rigid with my work hours and try not to start any...

Hi

I have been working remotely now for the last 3 weeks and so far it has all been good. Though today I need a short "mental health break", which...

I started looking through the Azure Learning Explorer. I should go through some of the Azure fundamentals. Learned quite a bit about Azure SQL, but not the core stuff as...

:), fortunately (for Grant), no.

We're actually really slow to hire and fire. Our CEO told us in Feb not to worry and we could pay...

• This reply was modified 6 years, 3 months ago by Steve Jones - SSC Editor.

It's interesting. A friend was over last night. He has 400+ reports under him. Had to let 10% go at the beginning of the year. Easy to do. Got told...

Well, the big company meeting announcing what changes will be made was held this morning.  I will still have a job, but everyone making over 60k is getting an...

So, how's everyone surviving the shut in?

We've got a nice day on tap here, and while I'm putting in a couple extra hours this afternoon, I think I still...

I think it works on most platforms. The core kernel is the same.

You are welcome. If you have more issues, please post back. Including code makes this easier for us, both with setup and seeing your expected results.

How else can I compress DATA?  You mean COMPRESS function?

or What do you mean by this:

<<Compess both DATA and Indexes - the command you gave only compresses the table...

Excellent. Looking forward to it. We'd love more ADF articles, btw.

I've seen a few places report  SET QUOTED IDENTIFIER ON fixed things.

Multiple reports from SQL Agent, but it might apply here.

https://joyfulcraftsmen.com/blog/internal-query-processor-error-debugged/

Does this help? I assume you mean backup files from the database, not VM backups.

https://stackoverflow.com/questions/56903837/delete-files-older-than-x-number-of-days-from-azure-blob-storage-using-azure-fun

Have you run the estimate procedure?

I haven't seen many people saw they do row without page, but I'm sure some have done this. What I'd really do is not compress...

If this is SQL 2019, you can use window functions. This might help you. Your requirement isn't clear. Here is some sample data and a query. Not sure if this...