Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 59,086 total)

Reply To: Parse txt file

Bruin wrote:
Is there some magic that pulls in the file?
Thx.
Not really.... just do a BULK INSERT from the file. I haven't had the time to post it but you should...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2022 at 3:20 am

#4029793
Reply To: Drawbacks of having hundreds of data files per database

Yes... there is a drawback. A fair bit of code will actually run slower because there's an extra lay of structure that you have to go through. Partitioning is NOT...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2022 at 1:46 am

#4029772
Reply To: Can't copy login to one server in a cluster

You're correct... and I wondered where the heck that reply went. 😛
I can't delete the post but I can change it to nothing. My apologies for the distraction and apologies...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2022 at 1:22 am

#4029769
Reply To: Author "notes" in SSRS?

peterzeke wrote:
With that said, how do you choose to leave "notes" in an .rdl?
Why not? We do so for ever programmable object in SQL Server in the flower box. It...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 6:11 pm

#4029623
Reply To: Author "notes" in SSRS?

I agree that Version Control is of the utmost importance.
Disclaimer: I have troubles even spelling SSRS correctly. 😉
With that, I hit up a search engine and it appears that there's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 6:09 pm

#4029621
Reply To: Can't copy login to one server in a cluster

I posted to the wrong thread... post removed. Apologies.

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 6:04 pm

#4029620
Reply To: JSON String invalid

IMHO, it seems to me that you're attacking the wrong issue. Whatever is creating the bad JSON is the real issue that needs to be fixed.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 5:55 pm

#4029618
Reply To: Parse txt file

So, the next step is to include only those tags that you want and you listed those at the following post...
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1
We don't actually need to do that step... The original...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 5:45 pm

#4029616
Reply To: how to get text from hashed text value by sql server 2017 ?

When trying to use hashed passwords, you don't unhash what you have stored. As others said, hashing is basically a one-way-trip and that's a good thing.
When the user creates their...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 5:32 pm

#4029601
Reply To: Standards Matter

Thomas Franz wrote:
Just to refer to the orginal problem: The root problem of the big log file could be fixed / prevented, if you would partition your tables. Ola's script would...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 4:10 pm

#4029555
Reply To: Crazy Interview Questions

The best question of them all also comes from "Star Trek"...
"How do you feel"?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 2:33 pm

#4029515
Reply To: Parse txt file

Never mind... I tried to write it for 2012 and above. If you have 2017 or above, we can do a little optimization. If you have less than 2012, then...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 3:46 am

#4029248
Reply To: Parse txt file

Ok. Totally understood on not being about to provide the full monty in an original file. Just to make really sure, the file located at...
https://www.sqlservercentral.com/wp-content/uploads/2022/04/sample.txt
... is a correct representation of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2022 at 1:42 am

#4029218
Reply To: Parse txt file

Bruin wrote:
How could original script posted by zzartin, be modified to just pickup these tags during extraction? Currently it's finding ALL which do some testing with the file might be...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 8, 2022 at 11:20 pm

#4029175
Reply To: SQL 2012 through 2019 in-place

fujitora19 wrote:
I've downloaded SQL Server Standard 2019 to upgrade our database because we have a Microsoft Campus Agreement, but I'm being asked for a license for SQL Server 2019 Reporting...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 8, 2022 at 10:17 pm

#4029174

Viewing 15 posts - 3,541 through 3,555 (of 59,086 total)