Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 59,098 total)

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
Reply To: DELETE

Is there more than 1 such occurrence per row in the table and what is the datatype of the column that this type of data is in?
--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:08 pm

#4029173
Reply To: Cummulative Updates in SQL 2017 & Free space calculataions

ramana3327 wrote:
If you have SSAS also installed with Database services on the server, do you need to apply cumulative updates separately or it will give you the option to select...
--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:02 pm

#4029172
Reply To: NT Authority/System User failed to open Model database

ramana3327 wrote:
All jobs are running as sa only.
Just to ask the question, you DO have the "sa" login disabled, correct? And, yes, jobs can still run with sysadmin privs...
--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 7, 2022 at 11:37 pm

#4028832

Viewing 15 posts - 3,556 through 3,570 (of 59,098 total)