Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,196 through 15,210 (of 59,097 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

david.holley - Tuesday, April 11, 2017 11:27 AM
Ed Wagner - Tuesday, April 11, 2017 9:24 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)

April 11, 2017 at 8:42 pm

#1937746
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Hugo Kornelis - Tuesday, April 11, 2017 2:59 PM
david.holley - Tuesday, April 11, 2017 11:27 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)

April 11, 2017 at 8:40 pm

#1937745
RE: Numeric as primary key

jcelko212 32090 - Tuesday, April 11, 2017 11:27 AM
Jeff Moden - Monday, April 10, 2017 7:16 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)

April 11, 2017 at 12:47 pm

#1937706
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jetboy2k - Tuesday, April 11, 2017 7:58 AM
Jeff, thanks for the explanation regarding why the query to generate the Tally table...
--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)

April 11, 2017 at 9:12 am

#1937649
RE: EXCEL HELL!!!

grovelli-262555 - Tuesday, April 11, 2017 8:27 AM
I was trying to run Sub Test()
but I get an error at the line
ConnString =...
--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)

April 11, 2017 at 9:07 am

#1937645
RE: Improving performance using partitioning

nadersam - Tuesday, April 11, 2017 6:42 AM
May be i didn't elaborate on that, what i did is get a query...
--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)

April 11, 2017 at 7:39 am

#1937608
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jetboy2k - Monday, April 10, 2017 8:04 PM
I stumbled across this article, and it's definitely at a level above my current abilities....
--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)

April 10, 2017 at 8:38 pm

#1937534
RE: how to determine who change the schema ownership?

kristoledo - Monday, April 10, 2017 1:51 PM
Hi,
I am quite new in SQL Server Administration and we recently have some changes in 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)

April 10, 2017 at 8:33 pm

#1937533
RE: Numeric as primary key

jcelko212 32090 - Monday, April 10, 2017 3:10 PM
No, of course not. A primary key is in the identifier; and we...
--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)

April 10, 2017 at 7:16 pm

#1937530
RE: i have problem with installation in windows 7 ultimate

And remember that you must not use the Developers Edition for production instances.
--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)

April 10, 2017 at 7:00 pm

#1937529
RE: Parse numbers from Column

dba-512085 - Friday, April 7, 2017 4:16 PM
I have a sql table that stores weight in one column. How would I go...
--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)

April 10, 2017 at 6:58 pm

#1937528
RE: How do you define employee satisfaction?

dietztm - Monday, April 10, 2017 2:04 PM
IowaDave - Monday, April 10, 2017 1:53 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)

April 10, 2017 at 6:41 pm

#1937527
RE: EXCEL HELL!!!

h540663 - Monday, June 22, 2015 3:08 AM
Jeff Moden (6/19/2015)Heh... I agree. Compared to the ACE driver, the Jet driver was...
--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)

April 10, 2017 at 5:46 pm

#1937524
RE: Alternating Cursors?

bmg002 - Monday, April 10, 2017 4:26 PM
As an alternate to using a cursor for each DB, could you use:
EXEC sp_Msforeachdb 'INSERT...
--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)

April 10, 2017 at 5:30 pm

#1937523
RE: Improving performance using partitioning

Grant Fritchey - Monday, April 10, 2017 8:00 AM
Partitioning of data is meant to be a management tool, not a query performance...
--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)

April 10, 2017 at 8:49 am

#1937453

Viewing 15 posts - 15,196 through 15,210 (of 59,097 total)