Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,676 through 3,690 (of 59,087 total)

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
Reply To: Performance related issue after using left join to bring new fields to the query

I agree with what the others said. you've basically guaranteed that there's no chance of index seeks or high performance seek/range scans by embedding columns in functions, doing a leading...
--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 6, 2022 at 11:36 pm

#4011894
Reply To: SQL Server Restore

My suggestion is that you REALLY need to STUDY RESTORE in the official documentation. Here's the link...
https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql
There are several caveats and possible gotchas and if you've not 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)

April 6, 2022 at 11:24 pm

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

surafeb7 wrote:
Hey Jeff,
"SELECT Name_04, Name_05, Name_06, Cnt = COUNT(*)"
I executed the above query in the reference (security) table and the findings are as below. In total 1271 rows in total.
Cnt...
--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 5, 2022 at 10:26 pm

#4011268
Reply To: Slow Sql server

https://www.google.com/search?q=what+is+using+memory+in+SQL+Server
--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 5, 2022 at 10:04 pm

#4011265
Reply To: Do you dream about SQL Server and things IT?

Funny that you mention that. I do the same thing.
A long time ago, I remember that I would solve something (it wasn't SQL back then) in a dream, wake up,...
--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 4, 2022 at 7:04 pm

#4010657

Viewing 15 posts - 3,676 through 3,690 (of 59,087 total)