PowerShell arrays are 0-based. We have 10 elements, so the index goes from 0 to 9. The assignment was $numbers = @(1,2,3,4,5,6,7,8,9,10). So $numbers[0] = 1, $numbers[1] = 2,...

I don't get it. If you set element 4 to Null, why is it that number 5 vanishes from the array?

Really? It...

those "mad" numbers show up frequently in certain plans - they should be ignored.

most of the times if you get a ACTUAL explain plan those numbers will be correct...

• This reply was modified 1 year ago by  pdanes.

And, I think it was mentioned earlier, but any chance you have "autoclose" or "autoshrink" turned on? I doubt that autoshrink would cause this issue, but I could see...

And your backup process is done outside of SQL? Is there a reason you don't use the SQL Agent to schedule the jobs? I mean, nothing against doing it...

• This reply was modified 1 year, 2 months ago by  pdanes.

That sounds like it may be a bug in SSMS then... but oof... using the edit GUI in SSMS? I find that to be clunky and painful to work...

As another random thought - Are you seeing any pattern to when it blanks out? Like is it good at 8:02 but by 8:15 it is blank? If so,...

• This reply was modified 1 year, 2 months ago by  pdanes.
• This reply was modified 1 year, 2 months ago by  pdanes.
• This reply was modified 1 year, 2 months ago by  pdanes.

OK, I finally found notes on the sys view I was trying to remember:

sys.dm_db_file_space_usage

This time, that should (actually) help you determine what you need to know (you would...

Even weirder. I just made some manual changes, in a table that I confirmed has a primary key. Initially, it showed a change in only one of the tables, from...

Just thought of a small scenario that MAY not impact you, but thought I'd toss this in here too - do you have any heaps? The reason I ask...

• This reply was modified 1 year, 2 months ago by  pdanes.
• This reply was modified 1 year, 2 months ago by  pdanes.

OK, I finally found notes on the sys view I was trying to remember:

sys.dm_db_file_space_usage

This time, that should (actually) help you determine what you need to know (you would likely...

Well, it's consistent in that it makes a backup only if there is a reason to do so. I find it a more sensible strategy, but as you wrote, it's...

Thank you, I'll give that a try and see how it works, although the problem I'm running into is that I'm not getting the datetime-last-modified reliably from the system. Other...

I didn't want to go into to a bunch of unnecessary detail that has nothing to do with my specific problem, but since you ask...

The Windows scheduled task runs every...

• This reply was modified 1 year, 2 months ago by  pdanes.