Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,181 through 9,195 (of 59,091 total)

Reply To: formatting T-SQL

ed.elliott wrote:
Break down those barriers! I've been on the opposite side where we have had DBA's who always looked busy and were never interested in what we did unless there...
--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 12, 2019 at 5:47 pm

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

BrainDonor wrote:
MS have added database diagrams back into SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Other than Windowing functions, this is one of the best moves MS has ever done. It certainly made 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)

June 12, 2019 at 2:12 pm

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

jcelko212 32090 wrote:
An identifier cannot be a numeric since it is a nominal scale.
Heh... you changed your form of rubbish. And, yes, you CAN do some very necessary math with...
--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 12, 2019 at 1:59 pm

#3652752
Reply To: 2016 SP2 CU6 & tempdb

Haven't made it to CU6, yet (we try to stay off the bleeding edge) so thanks for the heads up. Hopefully, this will also bump your post back close 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)

June 11, 2019 at 7:42 pm

#3652475
Reply To: Randomly being logged out

Just confirming that it's happened to me as well. Intermittent problems are the worst things to troubleshoot.
--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 11, 2019 at 7:39 pm

#3652473
Reply To: script d'olla IN RDS

Heh... What??!! RTFM???!! That works??!! 😀 😀 😀
--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 11, 2019 at 7:36 pm

#3652472
Reply To: LOOP vs CTE vs NUMS function
There are a couple of things we need to be able to help you.
1. Post the "MCS_ClarionDateToSQL" function so we can figure out what it is that you're trying 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)
June 11, 2019 at 7:33 pm

#3652471
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

Viewing 15 posts - 9,181 through 9,195 (of 59,091 total)