Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,826 through 6,840 (of 59,072 total)

Reply To: Query taking more than 4 hrs. - Any recommendations/suggestions?

Feivel wrote:
Jeff Moden wrote:
See the 2nd link in my signature line below on the information you should provide on performance related problems. Thanks.
Okay thanks I'll follow this guideline going forward. Could...
--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)

July 4, 2020 at 2:00 am

#3767433
Reply To: TempDB question help and best practices to implement

JSB_89 wrote:
@jeff
Developers think its always DBA's fault bcz the query is running slow . Initially they were pulling data to temp tables which we corrected into physical tables and drop...
--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)

July 3, 2020 at 12:15 am

#3767194
Reply To: Query taking more than 4 hrs. - Any recommendations/suggestions?

See the 2nd link in my signature line below on the information you should provide on performance related problems. 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)

July 2, 2020 at 5:04 pm

#3767089
Reply To: TempDB question help and best practices to implement

JSB_89 wrote:
Our developers are running a huge select query pulling millions of records for a datawarehouse and when examined the query shown no issues in the Executionplan .
Heh... you've correctly...
--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)

July 2, 2020 at 4:58 pm

#3767073
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

@as1981 ,
Apologies for missing your question on this.
Yes, it's possible to work it out from historical information as you've said but it's still pretty much of a SWAG simply because...
--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)

July 1, 2020 at 7:47 pm

#3766820
Reply To: SQL Server Trigger to prevent insertion of duplicate data in Table

I don't know if it will help in this case but you CAN write a unique index with an "Ignore Duplicates" attribute that will simply not insert duplicates and won't...
--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 30, 2020 at 8:49 pm

#3766558
Reply To: Help with SQL Select with ^^^^
David Burrows wrote:
WHERE SUBSTRING([column],CHARINDEX('^',[column],PATINDEX('%PQ5|1|[0-9]%',[column])),4) = '^^^^'
If you look at the following post where the OP finally posted some semblance of the data he's actually trying to filter, you'll...
--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 29, 2020 at 3:41 pm

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

Steve Jones - SSC Editor wrote:
A moment of silence, please.
I heard from his family and Mike Vessey, https://www.sqlservercentral.com/author/mvdba, passed away on 25 Jun 2020. I was pleased to meet Mike and host him...
--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 29, 2020 at 3:36 pm

#3766198
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

Look at the code... I had to write it without being able to run it. You have the advantage of testing. 😀 Look at the ON clause... see the mistake...
--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 27, 2020 at 11:01 pm

#3765360
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

Tech wrote:
well, that is way over my head. I have a lot to learn. I understand the Joins and the Alias but is there a way to do it 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 27, 2020 at 10:26 pm

#3765357
Reply To: How to get data for 7 days Sunday to Saturday of the previous week
I still don't have test data and don't have the time today to make some but this should be close...
```
   WITH cteShift AS
(
 SELECT ShiftStartDT...
```
--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 26, 2020 at 11:14 pm

#3765294
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

Understood... back in a few...

--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 26, 2020 at 10:11 pm

#3765290
Reply To: Help with SQL Select with ^^^^

srisadhu wrote:
Just posting some solution that you can think of doensot make you pro and doesnot make ignorant.
When someone posts on forum it means that they can't get through documentation(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 26, 2020 at 7:06 pm

#3765268
Reply To: How to get data for 7 days Sunday to Saturday of the previous week

It's difficult to tell if you just want a sum by week (observing the times of the shifts) or if you want the sums by shift. If the former, 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 26, 2020 at 7:01 pm

#3765267
Reply To: Help with SQL Select with ^^^^

Post deleted because the op seemed offended by advice on how to post such problems.,
--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 26, 2020 at 5:47 pm

#3765263

Viewing 15 posts - 6,826 through 6,840 (of 59,072 total)