Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,551 through 2,565 (of 59,098 total)

Reply To: full name splitting based on the condition

@Sathish,
Are you all set? If not, take a look at the article at the first link in my signature line below to learn how to post some "Readily Consumable Data"...
--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)

November 5, 2022 at 8:24 pm

#4109120
Reply To: Why does a select on 1 table end up putting locks on other tables?

@Tobar... did you ever figure this out? Without being able to put my hands on the database, I'm out of suggestions.
--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)

November 5, 2022 at 8:22 pm

#4109119
Reply To: Sql subquery poor perf - Need to rewrite to optimise

DesNorton wrote:
Assuming that all of the other 20 subqueries are based on the same pattern in tblPolSpec, you will probably get better performance if you use a CROSS-TAB query like...
--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)

November 5, 2022 at 7:44 pm

#4109112
Reply To: Sqlagent data transfer issue

Blokeandbird wrote:
Many thanks for your help. I have been told that it uses DTExec.exe to run the SSISpackage. I am trying to find out more about this but if anyone...
--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)

November 5, 2022 at 7:43 pm

#4109111
Reply To: Datafile full, but it isn't a table

Memory optimized?
--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)

November 4, 2022 at 6:34 pm

#4108830
Reply To: Sql subquery poor perf - Need to rewrite to optimise
The original code looks like a "poor man's CROSSTAB". Try the following true CROSSTAB instead.
```
 SELECT  PolNr = m.PolNr
       ...
```
--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)
November 4, 2022 at 6:14 pm

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

Thanks for the reply, Eirikur.
--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)

November 4, 2022 at 4:59 pm

#4108775
Reply To: No validation if Table Valued Function is used

Grant Fritchey wrote:
I'd suggest adding a Continuous Integration step into your setup. Just deploy the code, without data, into a database, on commit of the code (or a push to 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)

November 4, 2022 at 4:41 pm

#4108774
Reply To: Table Header with Dynamic Dates

rjjh78 wrote:
this works perfectly! Many thanks!!
It works perfectly for the given data. Try deleting one of the dates and find out that the date doesn't appear in the result. If...
--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)

November 4, 2022 at 4:32 pm

#4108772
Reply To: Select into variable table name

To continue, one of my pet peeves are SQL lines of code that go off screen and dynamic SQL that comes out as a single line of code, especially when...
--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)

November 3, 2022 at 7:18 pm

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

Just in case anyone else is having the issue... I've verified that I'm no longer getting email responses for posts that I've subscribed to or have responded to. I've send...
--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)

November 3, 2022 at 6:43 pm

#4108370
Reply To: Select into variable table name

Another simplification would be to use DATENAME for the year instead of casting the results of the YEAR(() function.
EDIT: Sorry... I missed the -1 that was being done.
--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)

November 3, 2022 at 6:11 pm

#4108358
Reply To: Order Value per Region

Post withdrawn.
--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)

November 3, 2022 at 6:03 pm

#4108357
Reply To: Validate result

You also list the 3 conditions, as follows...
If duplicate codes then invalid result
if 8 & another code then invalid result
if 9 & another code then invalid result
For the first rule,...
--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)

November 3, 2022 at 5:57 pm

#4108346
Reply To: Validate result

Johnson330 wrote:
[Options table] 1 Option1 2 Option2 8 None 9 NotKnown
[Answers table] Student Answer 100 1 100 2
101 1 101 9
Student 100 answers are valid. Student 101 answers are 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)

November 3, 2022 at 5:54 pm

#4108345

Viewing 15 posts - 2,551 through 2,565 (of 59,098 total)