Why not just generate GUIDs?  With the dashes, they're 36 bytes in length when converted to CHAR.  Without the dashes, they're 32.

OK, so what was the "silly" fix you employed?

I'll also state that it's a shame that you're resorting...

Sharpen up your resume, find a trustworthy "jobber" type of recruiter (they'll want to interview you to ensure you're worth your salt in SQL and/or DataAnalysis), and then let them...

Hi Team,

We get xls file every day with so many sheets in it. I need to validate only the sheet named with current year. In this case, it is...

Hi,

I have below requirement. Please advise how to achieve that with BCP or any other tool

<li style="list-style-type: none;">

1. Have Table A with 5 million records

<li style="list-style-type: none;">

...

Change is change. Whether its better or not is something we have to evaluate, test, experiment with, and decide. I worry about people getting caught up in thinking we...

And I also recommend normalizing databases ..Wow! Seriously, I do not like using a data model that is hundreds of years old and based on Roman numerals. O probably...

Consider the following article while you're at it. 😉

https://www.sqlservercentral.com/editorials/the-art-of-commenting

To Grant's point, I wouldn't even call them "suggestions".  They're a "clue" that some code somewhere might (strong emphasis in "might") benefit from an index.  I don't know about lately...

Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks.  I'm just a little gob-smacked that someone has been...

Hello, beginner in Tsql

I need help: here in one of the tables that I use, one of the fields is declared in decimal (10.5).

I understand that the field is...

I'm thinking that you're going to need to do a reinstall but I'm not sure.  Your best bet would be to contact MS on this problem.

I would think that an actual join with a lookup table would be better so that you don't...

Hi

I have below Data and i want Balance Invoices on accoun of Fifo .

In case of C00220 it should return 54575  entry

In case of C00575 it should return 1593...

• This reply was modified 6 years, 4 months ago by Jeff Moden. Reason: Comment about possible misread of the OP

I love the "Conclusion" in the PDF I came across on the subject.  Basically, they pat themselves on the back for doing a good job of recovery (which took several...