This should do the trick for you.  It hasn't populated the original table with the extra rows but it creates the source we could with.  I'm just not sure that's...

Good luck on the exams, Michael.  When you pass them, maybe you can teach me about XML! 😀

Setting a Fill Factor of 80% across the board is a huge and totally unnecessary waste of memory and disk space especially if you have ever increasing index keys that...

Yes, the Select runs fine but the BCP doesn't. I'm running the BCP in Query Analyzer in SSMS on the server and database the Select is run on. So...

Nope... you've got it.  The 2nd operand tells what character position to start working with.  The 3rd operand identified how many characters to replace.  It can be "0" which means...

All the values in the this field are up to three digit numbers separated by decimal points, but there are up to nine (maybe slightly more) such octets.   Some...

Thank you for the feedback, Sabarish (I hope I split your name correctly).  Just to be sure, though, do you understand what STUFF does?  I ask only because a whole...

I'm trying to export a query to an XML file. The file gets created fine but it's empty so it's my Select query. I've tried setting quoted_identifiers to on...

Forum,

How do we tune a huge DB with ~2TB with huge tables most of them are heaps and some have cluster and non clustered indexes, this is not about...

You're welcome but which one?

Seems SQL Server doesn't have a regular expression function.

I am trying to query for records in which a varchar field contains values  123.x.5, where x is a integer of...

 SELECT CONVERT(DATETIME2(7), STUFF(REPLACE(STUFF('2020-04-29-14.41.26.686978',11,1,'T'),'.',':'),20,1,'.'));

DevOps isn't related to cadance or QA/testing. It is related to learning to become better. Plenty of companies conflated the two and drove speed over quality (many still...

You do realize that your dates that you're copying from aren't dates, right?  They probably the number of days since 1900-01-01 but they're not actually dates.  I believe that's your...

The big thing missing here is that there was no investigation as to why any of the bugs were released.  There's something very wrong when this type of thing happens...