Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,201 through 7,215 (of 59,091 total)

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
Reply To: Keeping Unique Aliases

Totally agreed about the usefulness of standards but I have to say that bad standards are as bad and sometimes worsen than no standards.
--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 4:33 am

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

adonetok wrote:
I set up primary key on email column.
I want to void inserting any duplicate record in email column.
That creates an index. If you modify that index to include the...
--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 4:19 am

#3746871
Reply To: Cannot extract Filename from Filepath using GetFileName in C#

Cool. Thanks for the info, Jeffrey. You should write an article on this stuff. I think it would be a big help to folks that use SSIS, especially people that...
--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 27, 2020 at 10:48 pm

#3746838
Reply To: Slow Trigger performance when big batches

Getting back to your original problem... I think that a large part of the pain you're going through is that the inclusion of which "fields" changed in the VARCHAR(MAX) constitutes...
--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 27, 2020 at 9:11 pm

#3746815
Reply To: Are the posted questions getting worse?

Heh... let the silliness continue. I just got an email saying...
KILL 99.9% OF BACTERIA & HARMFUL MICROBES
FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON INTERIOR SURFACES
Reg $129.95
2...
--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 27, 2020 at 8:55 pm

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

There is no hierarchical REFERENCES clause in SQL Server. If that's not what you meant, the only other thing that I can think of is some form of DRI and...
--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 27, 2020 at 8:47 pm

#3746798

Viewing 15 posts - 7,201 through 7,215 (of 59,091 total)