Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,176 through 8,190 (of 59,072 total)

Reply To: Are the posted questions getting worse?

Thom A wrote:
I don't think it helps that there are many, on certain websites (cough Stack overflow cough) that don't help the situation by answering the questions for these people, just...
--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 6, 2019 at 2:45 pm

#3705399
Reply To: What's a forgivable mistake?

I've got mixed emotions here. First, I do agree that the best of us will make mistakes. No question about that.
But that's also why we have certain procedures at work...
--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 6, 2019 at 6:15 am

#3705240
Reply To: Query runs for days when upgrading to 2017

I don't recall the syntax off of the top of my head but there's some code to tell SQL Server to use the old cardinality estimator, which is what this...
--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 6, 2019 at 4:02 am

#3705220
Reply To: Replace TABLE with STAGING_TABLE. Approach?

I guess we need to back this truck up a bit. I made the mistake of assuming that since you said you wanted to replace the table, that there wouldn'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)

December 6, 2019 at 2:54 am

#3705211
Reply To: Tempdb Growth

Admingod wrote:
Thanks! Sorry, I want to take it back what i said previously, it's a vendor product but it does have some user dbs and vendor db's. Under the heavy...
--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 6, 2019 at 12:12 am

#3705197
Reply To: Database file size question

Mike Scalise wrote:
Then again, given my current t-log activity, perhaps it won't even go beyond the 2GB size...
That, good Sir, is precisely what I'm thinking. If it does grow, 1GB growth...
--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:29 pm

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

Thom A wrote:
Jeff Moden wrote:
p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get...
--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:24 pm

#3705035
Reply To: Database file size question

jasona.work wrote:
Mike Scalise wrote:
Jeff, I did miss that second part, so my apologies. So you're suggesting shrinking it to 0 to clear up any fragmentation issues, then resize it to 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 3:38 pm

#3705019
Reply To: Pre Staging Data

I learned very early on that NOTHING should ever go directly from file (or whatever) to table because of the crap factor that every mentions. I also use a staging...
--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 3:35 pm

#3705015
Reply To: Database Backup Types

Stewart "Arturius" Campbell wrote:
Nice one, sergey
Agreed. I'm not sure why 3 people's votes came out at a low "3". I gave it a 5.
The unexpected good thing about it is that 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 3:15 pm

#3705005
Reply To: A varchar(MAX) STRING_SPLIT function for SQL 2012 and above

I'm not sure who or what marked the post by fgrodriguez as spam but I'm reposting it here so that the de-spaminator doesn't delete it.
I'll also state I'm a bit...
--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 3:00 pm

#3704997
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

Viewing 15 posts - 8,176 through 8,190 (of 59,072 total)