IF the MMDDYYYY formatted string date is guaranteed to always be 8 characters, the following works (most of the posted code doesn't consider the inclusion of the ".txt") according to...

• This reply was modified 2 years, 4 months ago by Jeff Moden. Reason: Missed Scott Pletcher's code and added credit to him there

Deleted.  Made a mistake and didn't check before I posted. 🙁

Here's a quick question for you because we have to enforce such things where I work... do you want the conversion to fail if the date contains less than 8...

From the article:

A few of them are in this post, though he's written a book with 450 pieces of advice.

My first thought when I read that was when they replaced...

All,

I'm new to Powershell so this could be a simple error.

I'm using a SQL agent job to backup a database to a UNC path and then rename it.

The...

I see a lot of focus here on not reindexing at all - mostly because no one can prove that reindexing improves performance.  I am not sure how that...

I have to second Michael's recommendation yet again.  Stop doing index maintenance on your RowStore indexes until you can prove some significant performance benefit.  Use the time to do Statistics...

Good Lord!  I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop.  The results are REALLY...

Since you're not using SQL Server (based on the INT4 datatypes you used), it may be that the RDBMS you're using doesn't allow CTEs (Common Table Expressions),...

The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team...

I agree with Phil.  Posting inserts to populate the test table with data will help a whole lot.

Also, the code you posted isn't from SQL Server but, since...

And, sorry... I was reading and answering from top down.  You and the OP got all this together.

If you just want an id you can just add ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) id, as a column to the query to get a sequential id column....

But, not the ID column the OP is looking for.

Simple question.

Who is the Brent Ozar of cloud computing ie all you need to know about SQL management and options in the cloud the does and don't of DBA...