Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,171 through 13,185 (of 59,099 total)

RE: SQL Azure - What next

Sorry. Posted on wrong thread.
--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 11, 2018 at 9:44 pm

#1975669
RE: Row inserts for groups of rows (Totals for groups of like data).

bswhipp - Thursday, January 11, 2018 12:46 PM
Jeffrey Williams 3188 - Thursday, January 11, 2018 12:34 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 11, 2018 at 9:41 pm

#1975668
RE: Row inserts for groups of rows (Totals for groups of like data).

It also works with GROUP BY WITH ROLLUP and GROUP BY WITH CUBE.
--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 11, 2018 at 12:00 pm

#1975590
RE: Are the posted questions getting worse?

RandomStream - Wednesday, January 10, 2018 5:10 PM
Jeff Moden - Wednesday, January 10, 2018 4:55 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 11, 2018 at 11:54 am

#1975585
RE: Divide column data into equal parts

drew.allen - Thursday, January 11, 2018 9:48 AM
Jeff Moden - Thursday, January 11, 2018 8:40 AM
Also, let's consider...
--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 11, 2018 at 11:36 am

#1975580
RE: Divide column data into equal parts

drew.allen - Thursday, January 11, 2018 7:33 AM
Jeff Moden - Wednesday, January 10, 2018 7:11 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 11, 2018 at 8:40 am

#1975524
RE: Ola's maintenance solution taking too long on VLDB's

Eric M Russell - Thursday, January 11, 2018 7:23 AM
Does anyone here besides me implement partitioning on indexes just for taking 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 11, 2018 at 8:11 am

#1975510
RE: Ola's maintenance solution taking too long on VLDB's

TheSQLGuru - Wednesday, January 10, 2018 8:16 PM
Jeff Moden - Wednesday, January 10, 2018 4:17 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, 2018 at 9:44 pm

#1975443
RE: SQL Developer Edition - Training

SQLSACT - Wednesday, January 10, 2018 12:38 AM
Thanks all for the responses.
Just to clarify - It's for internal demonstration purposes for some...
--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, 2018 at 9:22 pm

#1975441
RE: Divide column data into equal parts

Papil - Tuesday, January 9, 2018 1:58 PM
Can someone pls help with the following data. currently my data is as below 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)

January 10, 2018 at 9:12 pm

#1975440
RE: Divide column data into equal parts

subramaniam.chandrasekar - Monday, January 8, 2018 11:40 PM
Papil - Wednesday, January 3, 2018 2:52 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, 2018 at 7:16 pm

#1975433
RE: Divide column data into equal parts

drew.allen - Wednesday, January 10, 2018 9:17 AM
He has a columnar report that fills the columns top-to-bottom then left-to-right. He wants 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)

January 10, 2018 at 7:11 pm

#1975432
RE: Pivot Row to Columns

Charles_P - Wednesday, January 10, 2018 5:48 AM
I have a table "tblPerson" that only has three columns hder, hderOrder and key. The hderOrder...
--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, 2018 at 7:02 pm

#1975431
RE: Which job is running?

Does someone have a Windows job scheduled? Do you have a system "monitor" piece of software somewhere that's trying to login? Also, you need to figure out who "userx" is. ...
--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, 2018 at 6:57 pm

#1975430
RE: How to achieve this in the cube?

Charmer - Wednesday, January 10, 2018 3:52 AM
Hi Friends,
Last week I got a interesting task which is projecting some sales.
My task is...
--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, 2018 at 6:52 pm

#1975429

Viewing 15 posts - 13,171 through 13,185 (of 59,099 total)