Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 59,101 total)

Reply To: Are the posted questions getting worse?

I would think that a trigger to try to catch errors in other places would be mostly useless for a lot of code but I don't see anything wrong 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 14, 2021 at 7:15 pm

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

Brandie Tarvin wrote:
I just took a glance at the trigger. The size of the thing is truly horrendous.
If it's for a table with a large number of columns and it's an...
--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 14, 2021 at 2:39 pm

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

Brandie Tarvin wrote:
Brief tangent into real SQL stuff...
Has anyone ever heard of table triggers not firing for every row if you do set-based updates to records?
Our vendor sent us code for...
--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 14, 2021 at 1:18 pm

#3895953
Reply To: Load folder full of csv files

Ok. Mostly done. We still need to add some "pretty" error handling and the file move-after-imported thing but this is working quite nicely and it does tolerate errors along 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 14, 2021 at 6:08 am

#3895803
Reply To: Load folder full of csv files

Sorry. I've not had much time to work on this. Working on it now. Having some fairly good success. I'm also making sure that it's fully documented so that you...
--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 14, 2021 at 3:32 am

#3895774
Reply To: UDF not working

Perfect. I think we may have a little work to do on the Condit but check this out. Remember, don't think about what you want to do to a row......
--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 14, 2021 at 2:43 am

#3895771
Reply To: what condition case when related to portion key mean ?
ahmed_elbarbary.2010 wrote:
I work on sql server 2012 I don't understand condition below do this condition as below
```
case WHEN Po.PortionKey LIKE '%[_]%' 
THEN
 SUBSTRING(Po.PortionKey, LEN(LTRIM(RTRIM(Po.PortionKey)))+1,LEN(LTRIM(RTRIM(Po.PortionKey)))) end
 as modifiedportionkey
```
what...
--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 14, 2021 at 12:54 am

#3895749
Reply To: UDF not working

Thanks, Scott. The readily consumable test data you provided had a couple of bugs in the CREATE TABLE statements. For example, there is no such datatype as "NVCHAR"... that had...
--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 13, 2021 at 9:23 pm

#3895720
Reply To: UDF not working

Scott745618 wrote:
Ok apologies I am new to this. On another note how do you find a tables details, like column names and data type (for example in SAS you have...
--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 13, 2021 at 7:24 pm

#3895701
Reply To: GUIDs as clustered index

@vsamantha35
You never came back to say what you folks ended up doing nor how it worked or....
I can't speak for the others but I'd find it very interesting. Thanks.
--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 13, 2021 at 4:19 pm

#3895670
Reply To: outer apply alternative

boehnc wrote:
My goal is to get the results below. Trying to get the nearest date and result from the #Data table where the resultdate<=ProcDate. An outer apply is taking 4...
--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, 2021 at 9:33 pm

#3895181
Reply To: are varchar(max) columns always stored out-of-row?

I mostly agree with Scott and Frederico on this subject... I almost always force LOBs to be out of row for a table. I'll add that I also generally default...
--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, 2021 at 9:30 pm

#3895179
Reply To: are varchar(max) columns always stored out-of-row?

frederico_fonseca wrote:
partially incorrect - reading the manual helps so do read the "Create table" statement on the manuals where you may learn something.
and having (max) data inrow is in some...
--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, 2021 at 8:15 pm

#3895157
Reply To: UDF not working

The Dixie Flatline wrote:
Jeff, one of the best things I ever heard about comments is this:
Comments don't exist to describe what the code is doing. They exist to describe what 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)

June 11, 2021 at 7:57 pm

#3895150
Reply To: Cost effective VPN solution for AWS with MFA

Roust_m wrote:
Hi,
I've recently setup VPN on our AWS account and had my AWS bill go up by $200. It appears that you pay for it even when nobody uses 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)

June 11, 2021 at 3:39 pm

#3895031

Viewing 15 posts - 5,161 through 5,175 (of 59,101 total)