Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,081 through 10,095 (of 59,102 total)

RE: Log file and data file growth

Sal Young - Thursday, January 10, 2019 4:04 PM
Here is what I use to see data & log file 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)

January 10, 2019 at 10:25 pm

#2018663
RE: Files with larger disk consumption

Junior GalvÃ£o - MVP - Thursday, January 10, 2019 3:43 PM
Jeff Moden - Thursday, January 10, 2019...
--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)

January 10, 2019 at 10:21 pm

#2018662
RE: The Basics of iTVFs

The Dixie Flatline - Thursday, January 10, 2019 2:56 PM
Nico,
While I agree with Jeff's first two points about data duplication 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)

January 10, 2019 at 10:10 pm

#2018661
RE: Badly Trained AI

Rod at work - Thursday, January 10, 2019 2:56 PM
Eric M Russell - Thursday, January 10, 2019...
--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)

January 10, 2019 at 9:54 pm

#2018659
RE: Month T-1

girl_bj - Thursday, January 10, 2019 7:14 PM
pietlinden - Thursday, January 10, 2019 7:05 PM
--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)

January 10, 2019 at 9:50 pm

#2018658
RE: Month T-1

girl_bj - Thursday, January 10, 2019 9:01 AM
Jeff Moden - Thursday, January 10, 2019 8:57 AM
--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)

January 10, 2019 at 9:41 am

#2018569
RE: New SQL Saturday presentation ideas?

How about one on strategic and tactical persuasion? Like how to persuade Ray K to learn more about T-SQL and SQL Server so he has more subject matter to choose...
--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)

January 10, 2019 at 9:38 am

#2018568
RE: Badly Trained AI

xsevensinzx - Thursday, January 10, 2019 8:35 AM
Jeff Moden - Thursday, January 10, 2019 8:19 AM
--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)

January 10, 2019 at 9:31 am

#2018564
RE: SQL Quiz

Heh... Changing times, indeed. It's seems that cheating on assignments/interviews has become the norm.
--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)

January 10, 2019 at 9:24 am

#2018559
RE: Select convert to 2 decimal places, comma, right aligned

chad 62627 - Wednesday, January 9, 2019 10:01 AM
Jeff Moden - Tuesday, January 8, 2019 6:45 PM
--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)

January 10, 2019 at 9:19 am

#2018558
RE: Files with larger disk consumption

So.... how do you find out what's causing the problem?
--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)

January 10, 2019 at 9:11 am

#2018556
RE: Synonyms

t.franz - Thursday, January 10, 2019 12:55 AM
I think a problem with synonymes (as with several other "solutions") is SourceControl. When 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)

January 10, 2019 at 9:02 am

#2018554
RE: Month T-1

girl_bj - Thursday, January 10, 2019 1:05 AM
Jeff Moden - Friday, December 21, 2018 6:24 PM
--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)

January 10, 2019 at 8:57 am

#2018552
RE: The Basics of iTVFs

Great article on the Basics of iTVFs, Steve.
For those wondering about the performance of iTVFs that Steve mentioned, here's an article that discusses and demonstrates the performance advantage...
--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)

January 10, 2019 at 8:37 am

#2018548
RE: The Basics of iTVFs

n.dreyer - Thursday, January 10, 2019 7:19 AM
Good article Steve
What would the benefit then be using an iTVFs instead of a View?...
--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)

January 10, 2019 at 8:32 am

#2018546

Viewing 15 posts - 10,081 through 10,095 (of 59,102 total)