Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,676 through 6,690 (of 59,102 total)

Reply To: Previous row where condition exists

tacy.highland wrote:
It missed about 4 records which had triple matches...
This is what I'm trying to get at. If you used the old standby of using ROW_NUMBER() to find dupes 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)

August 7, 2020 at 12:08 am

#3778037
Reply To: NPI Data

frederico_fonseca wrote:
try adding firstrow option to start data at row 2 - row 1 is headers so it would blow the size of the columns you defined on that table.
--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)

August 6, 2020 at 6:48 pm

#3777957
Reply To: Previous row where condition exists

tacy.highland wrote:

Actually, I used all of the values listed in the table as the values which identify duplicates (those are what the Row_Number used to create the RowNum column). Does...

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

August 6, 2020 at 6:38 pm

#3777955
Reply To: Much lines from soms in audit

mark4data wrote:

I had the requirement to put on auditing. I made the server specifications, put in a file, and read the file info a database only the security officer can...

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

August 6, 2020 at 6:03 pm

#3777939
Reply To: Previous row where condition exists

Which columns are used to determine if a row is a duplicate or not? I'm not talking about after you use ROW_NUMBER() to mark them... I'm talking about what did...

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

August 6, 2020 at 6:01 pm

#3777938
Reply To: Trying to find all databases not in using sys.dm_db_index_usage_stats

Sounds like an excellent plan.

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

August 6, 2020 at 2:44 pm

#3777871
Reply To: Trying to find all databases not in using sys.dm_db_index_usage_stats

Somebody wrote:

Lowell. THANK YOU. I was overthinking it. Why didn't I think of your first one for the NOT IN. But thanks for the second one as well. ...

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

August 5, 2020 at 9:39 pm

#3777650
Reply To: NPI Data

david.edwards 76768 wrote:

Jeff Moden wrote:

smattiko83 wrote:

Thanks again for all your help. Did the sample look ok?

A cursory glance says it looks fine. I didn't do a deep dive on it.

I'm shocked!! A...

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

August 5, 2020 at 9:09 pm

#3777640
Reply To: NPI Data

smattiko83 wrote:

Thanks again for all your help. Did the sample look ok?

A cursory glance says it looks fine. I didn't do a deep dive on 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)

August 5, 2020 at 2:59 am

#3777375
Reply To: Resetting Filegrowth

Heh... I got it right but I suck at taking tests even if they're just one question long. I knew the answer without looking at the list of answers but,...

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

August 4, 2020 at 3:10 pm

#3777212
Reply To: Good Morning!

GOOD MORNING GRANT!!!!

I recently saw an article about "Self-made men" and it expresses exactly the way I feel. To summarize, I'm definitely not "self-made". I'm where I'm at because 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)

August 3, 2020 at 3:51 pm

#3776918
Reply To: Trying to find all databases not in using sys.dm_db_index_usage_stats

Somebody wrote:

Yea, that is the problem with this one. It only lists the dbs since last server restart that have been accessed, I want an opposite list. In a SQL...

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

August 3, 2020 at 1:21 pm

#3776857
Reply To: string compare again .. :)

Alan Burstein wrote:

Just as a side note, depending on how often your columns are updated/modified, you can always split the string ahead of time using a permanent tally table like this:

Agreed. ...

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

August 3, 2020 at 12:54 pm

#3776830
Reply To: string compare again .. :)

Jus wrote:

This is awesome. worked great. you made my day Jeff. Always big fan of you.. 🙂

Glad to have been able to help. Thank you for the feedback.

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

August 2, 2020 at 4:39 am

#3776640
Reply To: string compare again .. :)
Here you go. DelimitedSplit8K made the changes very simple.
```
--****** This is for when the position matches, as well... ******
--===== Define what we're looking for.
   ...
```
Attachments:
You must be logged in to view attached files.
--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)
August 2, 2020 at 1:46 am

#3776620

Viewing 15 posts - 6,676 through 6,690 (of 59,102 total)

Jeff Moden

Forum Replies Created

Attachments: