Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,756 through 7,770 (of 59,098 total)

Reply To: Update Statistics is causing DB file to grow in always on envrionment

PJ_SQL wrote:
I used sp_spaceused to find size of index and it is 40 GB and free space on the DB is around 19 GB.
Will adding additional 40 GB or more...
--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)

February 17, 2020 at 4:37 pm

#3726500
Reply To: Update Statistics is causing DB file to grow in always on envrionment

John Mitchell-245523 wrote:
That's not (just) updating statistics - it's index maintenance. When you rebuild an index, you should plan to have at least the same amount of free space in your...
--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)

February 17, 2020 at 4:29 pm

#3726489
Reply To: Developer Time is More Valuable Than Ever

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
NUMERIC(18,0) for an Age column.
Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a...
--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)

February 17, 2020 at 3:56 pm

#3726475
Reply To: Convert column values into single row comma separator

Steve Collins wrote:
Oh wait Jeff you changed it. Ok cool
Yeah... my bad. I've only got 2 cups of coffee under my belt and totally misread the code.
--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)

February 17, 2020 at 3:39 pm

#3726469
Reply To: Running VBS Script through SQL Agent Job

When you ran the code, it was probably from your desktop, which probably has a copy of Office on it (at least Excel). When the job runs, it runs as...
--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)

February 17, 2020 at 3:33 pm

#3726454
Reply To: Convert column values into single row comma separator

Never mind. Misread something.
--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)

February 17, 2020 at 3:08 pm

#3726449
Reply To: tempdb shrinking

Getting back to your original post above, stop trying to return stuff to the operating system by shrinking TempDB. It's not returning anything because, presumably and based on the fact...
--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)

February 17, 2020 at 3:05 pm

#3726448
Reply To: A New World of Data

I think it's funny... way back when a 1GB disk was the "ultimate", people filled them up. Now we have easy access to inexpensive disks that measure in TeraBytes 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)

February 17, 2020 at 2:49 pm

#3726442
Reply To: The Importance of Testing

Speaking of automated testing, you should write a followup article about who tests the automated test software? I can't speak for anyone else but we've had the occasional "whoops" occur...
--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)

February 17, 2020 at 2:42 pm

#3726438
Reply To: Developer Time is More Valuable Than Ever

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
NUMERIC(18,0) for an Age column.
Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long time...
--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)

February 17, 2020 at 2:32 pm

#3726434
Reply To: Developer Time is More Valuable Than Ever

First, to be sure, I'm not taking a shot at anyone for whatever methodology they use... I'm just talking about what we did in the various places I've worked 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)

February 16, 2020 at 4:54 pm

#3726252
Reply To: Looking for recommendation on "cost threshold value"

To Frederico's point, here's my entry on the post he provided a link to above...
Just my entry on this post…
When I first laid eyes on the servers at where I...
--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)

February 16, 2020 at 2:49 pm

#3726247
Reply To: How to write query on column with list of delimited categories

MVDBA (Mike Vessey) wrote:
ChrisM@Work wrote:
MVDBA (Mike Vessey) wrote:
Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead
again...
--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)

February 16, 2020 at 12:23 am

#3726215
Reply To: A quick search without an index

Yep... I got that. It's not a problem if you know about it. I just wanted to be sure that people knew about it. Perhaps stripping the time would eliminate...
--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)

February 15, 2020 at 4:17 am

#3726136
Reply To: Find and Copy Data from Another Table

WILLIAM MITCHELL wrote:
Jeff, it sounds like the OP has a permanent table Customers, and Info is a staging table that has updates & corrections.
Understood. The OP said as much in 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)

February 15, 2020 at 2:57 am

#3726120

Viewing 15 posts - 7,756 through 7,770 (of 59,098 total)