Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,206 through 11,220 (of 59,102 total)

RE: How do I write a record for each day in a date range???

Jonathan AC Roberts - Friday, September 14, 2018 9:10 AM
andycadley - Friday, September 14, 2018 9:03 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)

September 14, 2018 at 9:13 pm

#2005861
RE: How do I write a record for each day in a date range???

drew.allen - Friday, September 14, 2018 10:03 AM
andycadley - Friday, September 14, 2018 9:03 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)

September 14, 2018 at 9:11 pm

#2005860
RE: How do I write a record for each day in a date range???

sgmunson - Friday, September 14, 2018 8:04 AM
Jonathan AC Roberts - Saturday, September 8, 2018 7:04 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)

September 14, 2018 at 8:56 am

#2005788
RE: Why such a big log size?

Eric Mamet - Friday, September 14, 2018 7:41 AM
There is a Clustered Index on a composed Primary Key plus a non...
--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)

September 14, 2018 at 8:16 am

#2005773
RE: Are the posted questions getting worse?

DinoRS - Friday, September 14, 2018 5:39 AM
Sergiy - Thursday, September 13, 2018 10:56 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)

September 14, 2018 at 8:13 am

#2005772
RE: Are the posted questions getting worse?

Sergiy - Thursday, September 13, 2018 10:56 PM
It's eqally true about pretty much every new feature in SQL Server introduces since...
--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)

September 14, 2018 at 8:11 am

#2005770
RE: Today's Random Word!

Ed Wagner - Thursday, September 13, 2018 1:43 PM
below86 - Thursday, September 13, 2018 12:13 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)

September 13, 2018 at 8:16 pm

#2005704
RE: Are the posted questions getting worse?

drew.allen - Thursday, September 13, 2018 2:32 PM
Jeff Moden - Thursday, September 13, 2018 11: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)

September 13, 2018 at 8:13 pm

#2005703
RE: Are the posted questions getting worse?

Michael L John - Thursday, September 13, 2018 2:42 PM
I just deployed a 14000 line update statement. The code needed to...
--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)

September 13, 2018 at 8:09 pm

#2005702
RE: Are the posted questions getting worse?

Sean Lange - Thursday, September 13, 2018 1:25 PM
ZZartin - Thursday, September 13, 2018 12:10 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)

September 13, 2018 at 8:05 pm

#2005701
RE: Are the posted questions getting worse?

ZZartin - Thursday, September 13, 2018 12:10 PM
The biggest problem i see people doing with TRY/CATCH and this isn't just in...
--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)

September 13, 2018 at 1:12 pm

#2005669
RE: Are the posted questions getting worse?

drew.allen - Thursday, September 13, 2018 11:44 AM
OMG. I'm working on a stored procedure that references an EAV table and it has...
--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)

September 13, 2018 at 11:57 am

#2005654
RE: Dissertation theme in MS SQL Server for a DBA

Grant's suggestion is a good one but a keynote in the dissertation should include the fact that automation should never be used as a substitute for knowledge because if you...
--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)

September 13, 2018 at 11:44 am

#2005651
RE: Are the posted questions getting worse?

jonathan.crawford - Thursday, September 13, 2018 9:35 AM
Short why?
Sure but my system at work won't allow me to post what 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)

September 13, 2018 at 11:40 am

#2005648
RE: CrossTab in SQL

andycadley - Thursday, September 13, 2018 12:40 AM
Given the choice, I'd opt for a Table Valued Function over a Stored Procedure if...
--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)

September 13, 2018 at 8:41 am

#2005610

Viewing 15 posts - 11,206 through 11,220 (of 59,102 total)