Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 59,067 total)

Reply To: Comparison in the WHERE condition
Eddie Wuerch wrote:
Lets break this down into sets.
You are combining two sets of data from this table:
1. All Product rows where [product_id] > 2
2. All Product rows where [product_id] is 1...
--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)
April 11, 2022 at 7:29 pm

#4014143
Reply To: Comparison in the WHERE condition

The code is simple enough so why not do it in a UNION ALL between two queries to get rid of the "OR"?
--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)

April 11, 2022 at 7:26 pm

#4014141
Reply To: Removing Text From All Rows
Carlo Romagnano wrote:
```
WITH ctePC
AS ( SELECT expression
     FROM
       ( VALUES
        ...
```
--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)
April 11, 2022 at 7:20 pm

#4014139
Reply To: make script more robust

I don't know but it sounds like the source of the files never deletes the old files. With that, what are you doing about identical entries every time you run...
--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)

April 11, 2022 at 7:06 pm

#4014136
Reply To: Should I use Azure for this?

pietlinden wrote:
A friend of mine owns a bakery. His data needs are pretty simple, so in theory I could use Access (shudder)... It's basically Recipes, Recipe Ingredients, Ingredient Purchases, 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)

April 11, 2022 at 7:00 pm

#4014117
Reply To: make script more robust

Bruin wrote:
I'm running thru folders where output from job processing happens and sometimes the product we use to run\schedule jobs doesn't detect and error condition even though the SP or...
--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)

April 11, 2022 at 2:07 am

#4013695
Reply To: make script more robust

Bruin wrote:
This script works, but I would like to add a few more things to the process, and need some help.
1) Search multiple folders 2) Search for multiple strings patterns ...
--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)

April 10, 2022 at 11:35 pm

#4013670
Reply To: Having a case or if statement in where clause on Max Date

a_car11 wrote:
This is what worked for me, but any rooms for improvement or suggestions is gratefully appreciated:
SELECT account, name, street, due_date FROM my_table WHERE CAST(CONVERT(VARCHAR,due_date,102) AS DATETIME) = (
case 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)

April 9, 2022 at 1:39 am

#4012957
Reply To: Possible to Side Load a DB to AOAG then rename

If you use a SAN, check the SAN documentation for a "SAN Snapshot". It's almost instantaneous.
--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)

April 9, 2022 at 12:55 am

#4012939
Reply To: SQL query is taking 9 hours to complete

surafeb7 wrote:
My apologies, COVID delayed my progress.
Start working slowly.
Regards
RR
You came down with COVID? Sorry to hear and glad you're still around. I know I sound like a Grandma but take...
--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)

April 8, 2022 at 12:44 am

#4012421
Reply To: Having a case or if statement in where clause on Max Date

I'll start off by saying that putting columns in functions in the WHERE clause is almost always going to cause full table or index scans and that's going to kill...
--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)

April 7, 2022 at 5:16 pm

#4012294
Reply To: SQL Server Restore

PJ_SQL wrote:
I am trying to restore prod backup to test instance, so overwriting it should not be a problem.
Ok... first of all, remember that none of the privs you established...
--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)

April 7, 2022 at 3:04 am

#4011961
Reply To: Database in "Recovery" and Query to Find Information

To be honest, I don't trust any of the estimates. I've never had them be close for me.
I'm happy that everything eventually came back for you. Sounds like you're having...
--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)

April 7, 2022 at 2:54 am

#4011957
Reply To: Conditional Sum in SQL
I'm looking at a part of what you posted..
```
PatID    StartDate  EndDate    Type of Line Insert Dt  Remv Dt Pt...
```
--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)
April 7, 2022 at 2:49 am

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

I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like the following...
--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)

April 7, 2022 at 12:01 am

#4011896

Viewing 15 posts - 3,646 through 3,660 (of 59,067 total)