Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,206 through 8,220 (of 59,091 total)

Reply To: Need help to insert Data into 2 Tables
Adelia wrote:
Hi Lowell,
I execute as follow
```
insert into [dbo].[master_profile]([profile_name], [profile_ic_no])
select [NAMA], [NOKP_NEW] 
from [dbo].[EMPMAS_DATA]

insert into [dbo].[master_individual]([profile_id], [identification_no])
select 
  MyLookup.profile_ic_no, 
  MySource.[NOKP_NEW] 
from [dbo].[EMPMAS_DATA] MySource
INNER JOIN [dbo].[master_profile]...
```
--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)
December 5, 2019 at 2:57 pm

#3704996
Reply To: Tempdb Growth

Explosive growth of TempDB is normally caused by just one thing... some code that has created a many-to-many join, accidentally or not. To emphasize the problem with this, let's call...
--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)

December 5, 2019 at 2:51 pm

#3704994
Reply To: Database file size question

Heh... like I said, I even said to immediately regrow it to 2GB in my first post on the subject. 😀

--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)

December 5, 2019 at 2:42 pm

#3704993
Reply To: Database file size question

jasona.work wrote:
I'm with Jeff on your analysis, but not on his suggestion on tackling the Transaction Log (not completely, at least!)
I'd still go with the shrink the size to 0...
--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)

December 5, 2019 at 2:30 pm

#3704976
Reply To: Expect the Unexpected with DiRT

David.Poole wrote:
Worth reading about Netflix and the Chaos Monkey approach
Do you have any links? (or did I simply miss them in the article?)

--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)

December 5, 2019 at 2:03 pm

#3704970
Reply To: Database file size question

Mike Scalise wrote:
Thanks, Jeff!
I completely understand your rationale for shrinking the log file to 0 for the reasons you mentioned, but let me ask—in your experience, how resource intensive is 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)

December 5, 2019 at 2:00 pm

#3704960
Reply To: Database file size question

IMHO, your analysis is spot on, Mike. You only need to decide on what the growth of each file should be in MB.
Since the Log file did grow by 10%...
--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)

December 5, 2019 at 4:52 am

#3704627
Reply To: Find rows older than 60 days with Epoch time format

Isabelle2378 wrote:
Thank you for your reply! That is very helpful 🙂 I need to run this purge job once a week but unfortunately I don't know how many rows 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)

December 5, 2019 at 4:36 am

#3704626
Reply To: Expect the Unexpected with DiRT

Our annual DiRT testing takes place this weekend. We're not Google by any means but it's just as important to us. The whole company gets involved in one form 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)

December 5, 2019 at 4:16 am

#3704622
Reply To: It's More Than What You Know

David Burrows wrote:
Jeff Moden wrote:
Exactly and well said. And if someone keeps in mind that there will almost always be...
2.A better answer...
Especially with my code :-/
Heh... so say we all about our...
--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)

December 4, 2019 at 10:08 pm

#3704536
Reply To: Slow deletes

Sam, I hope you didn't miss the following because that SHRINK FILE stuff isn't going to solve your slow deletes.
https://www.sqlservercentral.com/forums/topic/slow-deletes#post-3704281
--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)

December 4, 2019 at 9:44 pm

#3704533
Reply To: Slow deletes

MVDBA (Mike Vessey) wrote:
jeff- you just made me laugh out loud and spill my tea all over my new keyboard about job security. I was chatting to a guy I work 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)

December 4, 2019 at 9:40 pm

#3704532
Reply To: Slow deletes

vsamantha35 wrote:
Yes. I tried the shrinkfile but it doesnt release free space which is around 500MB. I dont know why!!

Ok... I'm humbled. NICE CALL MIKE!!! 😀
--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)

December 4, 2019 at 9:38 pm

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

Phil Parkin wrote:
I wonder whether I will be cast out from The Thread as a maverick grammar nutjob for suggesting that NSO would be a better abbreviation, given that 'verbal' means...
--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)

December 4, 2019 at 9:29 pm

#3704527
Reply To: How to speed up the query speed between different server tables

Jeff Moden wrote:
We combine OPENQUERY against a LinkedServer and it does appear to help performance quite a bit (especially when pointing at AS400s or IBM PowerSystems). I have no measured stats...
--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)

December 4, 2019 at 4:49 pm

#3704391

Viewing 15 posts - 8,206 through 8,220 (of 59,091 total)