Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,196 through 9,210 (of 59,099 total)

Reply To: How to Retrieve a Substring From a Larger String of Varying Length

Totally agreed that in real life, order does matter. I'll also state that it also matters in "relational theory". If it didn't, indexes wouldn't do a bloody thing for us...
--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)

June 10, 2019 at 10:13 pm

#3651988
Reply To: How to Retrieve a Substring From a Larger String of Varying Length

Matt Miller (4) wrote:
Unfortunately - I don't think STRING_SPLIT will work From the BOL for String_split:
The output rows might be in any order. The order is not guaranteed to match the order...
--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)

June 10, 2019 at 8:06 pm

#3651953
Reply To: How to update a table that causes temporary duplicate index

In either case, you need to determine if the index is being used in association with FKs before you either drop or disable the index. IIRC, doing either will cause...
--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)

June 10, 2019 at 7:57 pm

#3651945
Reply To: sp_runwebtask error after migration from SQL Server 2000

Now you
IdolR wrote:
Erland Sommarskog wrote:
Apparently there is a trigger the table calling sp_runwebtask.
Yes! 3 bloody triggers where set for that table. Deleted them fixed the problem!! Thanks!
Do you know...
--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)

June 9, 2019 at 11:52 pm

#3651652
Reply To: Need help with query where i need to aggregate an aggregate

jcelko212 32090 wrote:
The poster can control the @ and # tables he creates, can't he? Data element names, etc. are also under their control. Yes, you can get stuck with crap...
--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)

June 9, 2019 at 7:37 pm

#3651602
Reply To: Microsoft Exercise

The treadmill has gotten faster and the changes have gotten worse.
It's still amazes me that there are still bugs in the basic engine that they're fixing and that they make...
--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)

June 7, 2019 at 3:07 pm

#3651061
Reply To: Database with thousand of tables and no foreign keys.

Gamleur84 wrote:
Hi Yes, it is a major product from Microsoft, it is their ERP system Dynamics AX. There is no way that the product (database) has data integrity issues as...
--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)

June 7, 2019 at 1:31 pm

#3651042
Reply To: Database with thousand of tables and no foreign keys.

Gamleur84 wrote:
I will talk with developers to understand how the integrity of the data is maintained through the code without foreign keys.
We know the answer to that, which...
--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)

June 6, 2019 at 5:26 am

#3650670
Reply To: Cloud Pace

I'm reminded of the item about change in my signature line below. And, at the pace the changes are coming out, it can be a little (or a lot) frighting...
--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)

June 6, 2019 at 5:23 am

#3650669
Reply To: Changing Database Names

Whether you use the old or new method, there's a whole lot more to it if you really want to do it right.
--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)

June 6, 2019 at 5:20 am

#3650668
Reply To: File sizing

mishka-723908 wrote:
Thanks for the replies. Yes, we are working on alerts now. In our case its a DW. Since we have multiple files that are currently set as limited 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)

June 6, 2019 at 3:10 am

#3650665
Reply To: Friday Fun - Excel Formula to SQL Functions

ScottPletcher wrote:
Also, you want to avoid BETWEEN when dealing with dates / times.
I have heard this often but I have never seen any proof as to why. I am 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)

June 6, 2019 at 1:19 am

#3650657
Reply To: Friday Fun - Excel Formula to SQL Functions

David Jackson wrote:
Also, you want to avoid BETWEEN when dealing with dates / times.
<strong style="background-color: transparent; background-image: none; font-family: arial,tahoma; font-size: 13.33px; font-style: normal; font-variant: normal; font-weight: bold; letter-spacing: normal; text-align:...
--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)

June 6, 2019 at 1:18 am

#3650656
Reply To: The Worst Comments

Now THAT's funny. Talk about "Team Work", eh?
--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)

June 6, 2019 at 1:00 am

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

Must be something in the wind with Git/GitHub... the Lansing, MI user group is having a speaker talk about getting started with Git/GitHub.
As a bit of a sidebar, I gave...
--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)

June 6, 2019 at 12:55 am

#3650652

Viewing 15 posts - 9,196 through 9,210 (of 59,099 total)