Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,451 through 15,465 (of 59,063 total)

RE: How to overcome the identity column "jump 1000" issue

spaghettidba - Thursday, January 15, 2015 4:40 AM
It's a known issue. The TF resolves it, but IMHO a gap or jump 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)

March 6, 2017 at 9:12 pm

#1931969
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Monday, March 6, 2017 8:00 PM
Jeff Moden - Monday, March 6, 2017 6:51 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)

March 6, 2017 at 8:46 pm

#1931968
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Monday, March 6, 2017 12:34 PM
>>I am using the date / time from a view to join on...
--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)

March 6, 2017 at 6:51 pm

#1931964
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 12:57 PM
Jeff Moden - Monday, March 6, 2017 12:30 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)

March 6, 2017 at 4:07 pm

#1931956
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 12:20 PM
The original article.
I'd recommend avoiding the rCTE in the original article. Please refer 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)

March 6, 2017 at 12:30 pm

#1931904
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 11:56 AM
Interesting read - greatly appreciated.
One point to note: since the second query in the CTE...
--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)

March 6, 2017 at 12:17 pm

#1931900
RE: Usage of CTE - Trick with Dates

SoCal_DBD - Monday, March 6, 2017 8:58 AM
Awww Jeff..... I hang my head in SHAME!!! :crying: Original post revised 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)

March 6, 2017 at 10:37 am

#1931875
RE: Help with % calculation please

Luis is spot on about how this occurred. As a simplification of what he posted, unless the SUM of a.fieldmissed will create a number larger than 13 significant digits, 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)

March 6, 2017 at 8:28 am

#1931830
RE: All Columns as Included

VastSQL - Sunday, March 5, 2017 10:32 PM
Jeff Moden - Sunday, March 5, 2017 12: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)

March 6, 2017 at 8:03 am

#1931816
RE: Please explain difference between these terms

Neil Burton - Monday, March 6, 2017 1:53 AM
I think you mean database principals rather than principles here Jeff. A search for...
--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)

March 6, 2017 at 7:59 am

#1931811
RE: Create sql login for reporting activity

Eric M Russell - Monday, March 6, 2017 7:31 AM
Jeff Moden - Sunday, March 5, 2017 1:41...
--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)

March 6, 2017 at 7:56 am

#1931808
RE: Very large Indexes (~3TB) and need to rebuild fast

The OP has left the building! 😉
--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)

March 5, 2017 at 4:54 pm

#1931721
RE: moving several large databases from old hardware Live to new hardware

Eirikur Eiriksson - Saturday, March 4, 2017 2:47 AM
sqlguy80 - Friday, March 3, 2017 8: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)

March 5, 2017 at 2:02 pm

#1931720
RE: SQL query which returns a single aggregate metric indicating how well actuals met forecast for a given week

jeswar - Saturday, March 4, 2017 12:18 AM
Table: UnitsSold
Columns:
â€¢    ProductID
â€¢    Quantity
â€¢    Date
â€¢    ForecastOrActual â€“ can be â€œAâ€ for actual and â€œFâ€ for forecast.
Sample Data would look...
--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)

March 5, 2017 at 1:54 pm

#1931719
RE: Use date and time in sql statement for join, but not required in the output

Luis Cazares - Friday, March 3, 2017 11:07 AM
Change the * to include the columns you need separated by commas.
Avoid using FORMAT...
--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)

March 5, 2017 at 1:44 pm

#1931718

Viewing 15 posts - 15,451 through 15,465 (of 59,063 total)