Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,191 through 11,205 (of 59,095 total)

RE: Rewrite query

jcelko212 32090 - Tuesday, September 11, 2018 7:45 PM
Iâ€™m not sure how to get that list of seller_idâ€™s, but I do...
--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 16, 2018 at 9:40 am

#2005891
RE: Julian Date again ...sorry

jcelko212 32090 - Saturday, September 15, 2018 11:40 AM
Jeff Moden - Saturday, September 15, 2018 11:02 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 16, 2018 at 9:29 am

#2005890
RE: Are the posted questions getting worse?

TomThomson - Sunday, September 16, 2018 4:47 AM
That tends to depend on the langage. There is no use whatever for GOTO...
--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 16, 2018 at 9:11 am

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

Steve Jones - SSC Editor - Saturday, September 15, 2018 5:40 PM
Jeff Moden - Friday, September 14,...
--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 16, 2018 at 9:01 am

#2005887
RE: Julian Date again ...sorry

jcelko212 32090 - Thursday, September 13, 2018 4:31 PM
To maintain my image as a pedantic poster, the yyyy-ddd display format Is called the ordinal...
--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 15, 2018 at 11:02 am

#2005873
RE: Will backup contain those transactions

coolchaitu - Friday, September 14, 2018 7:34 PM
Good morning experts
There are some transactions that start before the backup runs. These transactions end...
--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 15, 2018 at 10:45 am

#2005872
RE: Long running Stored Procedure

Harold Buckner - Saturday, September 15, 2018 6:44 AM
Another interesting find. On my SQL 2014 instance were the SP takes 66 min...
--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 15, 2018 at 10:06 am

#2005870
RE: Are the posted questions getting worse?

DinoRS - Friday, September 14, 2018 8:26 AM
Sergiy - Friday, September 14, 2018 7:46 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 10:58 pm

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

Viewing 15 posts - 11,191 through 11,205 (of 59,095 total)