Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,171 through 7,185 (of 59,072 total)

Reply To: SQL jobs failed

Ant-Green wrote:
Whats the full error message you get.
Renaming disabling the actual SA account is fine jobs can still be owned by that account, that is what I do on my...
--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 1, 2020 at 12:32 pm

#3748025
Reply To: Are You Ready To Change Your Work Environment?

I used to work from home in the mornings, work in the office from about noon to 8 (and not get much done because of all the "drive by shootings"),...
--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 1, 2020 at 12:30 pm

#3748008
Reply To: find and replace text in sproc

Thomas Rushton wrote:
The idea of doing a DROP & CREATE fills me with dread - all the bespoke permissions you could lose...
Ditto that. Since this is a 2019 thread, I'm thinking...
--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 1, 2020 at 12:07 pm

#3748005
Reply To: Where AI Shines

DinoRS wrote:
First of all: it would need to be UV-C specifically, that's the one you're not catching with your sunscreen lotion and most importantly: You should know that injection 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)

April 30, 2020 at 4:45 pm

#3747759
Reply To: A Security Regression

No... the bottom line is that no security is perfect especially from inhouse attacks. I got a report yesterday that even "Zoom" has been hacked an the account information for...
--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)

April 30, 2020 at 4:31 pm

#3747746
Reply To: Have txt/csv files, but header need to find from which row it will start

I'm at work now and can't help just now. I'll have a go at it tonight after work.

--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)

April 30, 2020 at 2:35 pm

#3747692
Reply To: I want to find header row dynamically and create table schema with that header.

DBA.k wrote:
can you please help on this task
Yes but let's stop this thread and take it back to the original thread where I see you've provided the information I asked...
--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)

April 30, 2020 at 2:34 pm

#3747691
Reply To: Uptime history without Monitoring tool

Another way is to just periodically sample the Create_Date of TempDB from sys.Databases and do a DATEDIFF. That will actually let you know if the SQL Service was restarted whether...
--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)

April 30, 2020 at 2:28 pm

#3747687
Reply To: DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries

I will probably never need DAX but I have to say that I've book marked this incredible article for if I ever do. What a great thing you've done here......
--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)

April 30, 2020 at 12:25 pm

#3747646
Reply To: Object naming

jonathan.crawford wrote:
I prefer to name my address tables "whereDeyAt", my individual identifier table "whoDey" and the transaction table showing activities "whazzzaaaaaaaap" (I alias that one, it's long)
BWAAAA-HAAAA-HAAAA!!!! SNNNOOORRRRTTT!!!! NOW THATS...
--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)

April 29, 2020 at 7:57 pm

#3747458
Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Ah... so you meant a REFERENCES clause in a bit of DRI. Understood. I wasn't getting that from your post.
As attractive to some as it is, I'm not likely to...
--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)

April 29, 2020 at 7:26 pm

#3747444
Reply To: Have txt/csv files, but header need to find from which row it will start

You've provided one example file. Could you provide a couple more that represent some of the other files that have different delimiters, etc?
Also, how many "columns" do these files generally...
--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)

April 29, 2020 at 2:47 pm

#3747327
Reply To: Keeping Unique Aliases

David.Poole wrote:
Let's face it standards articles and forums are coke and mentoes
Heh... you said a mouthful. 😀

--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)

April 28, 2020 at 11:59 pm

#3747170
Reply To: How to skip duplicate record and keep on running until the end?

adonetok wrote:
I tried Phil Parkin's way, it is working now.
Thank all of you.
Cool. Thanks for the feedback. To be sure, though, do you understand how and why Phil's good code...
--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)

April 28, 2020 at 2:46 pm

#3747016
Reply To: Keeping Unique Aliases

Tom_Hogan wrote:
Jeff Moden wrote:
Totally agreed about the usefulness of standards but I have to say that bad standards are as bad and sometimes worsen than no standards.
Not to detail the thread,...
--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)

April 28, 2020 at 2:40 pm

#3747015

Viewing 15 posts - 7,171 through 7,185 (of 59,072 total)