Jeff Moden

Forum Replies Created

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

RE: Is it possible to increase the number of partitions in an existing database ?

stevenmillward - Wednesday, January 3, 2018 10:01 AM
Hi
I am working with a database that has multiple file groups (1 file per file...
--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 12, 2018 at 7:27 am

#1975712
RE: CREATE RULE

t.franz - Friday, January 12, 2018 1:22 AM
Why is usefull stuff as this deprecated?
Heh... you sound like a kindred spirit.
My...
--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 12, 2018 at 7:21 am

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

bswhipp - Friday, January 12, 2018 5:30 AM
Jeff Moden - Thursday, January 11, 2018 9:41 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 12, 2018 at 7:06 am

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

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