Jeff Moden

Forum Replies Created

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

RE: EXCEL HELL!!!

pharryecoenen - Wednesday, April 12, 2017 7:48 AM
Does you update "Excel Hell" also work in later versions of SQL (the column...
--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 12, 2017 at 8:14 am

#1937848
RE: Parse numbers from Column

jcelko212 32090 - Tuesday, April 11, 2017 12:23 PM
dba-512085 - Friday, April 7, 2017 4: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 12, 2017 at 7:47 am

#1937840
RE: EXCEL HELL!!!

pharryecoenen - Wednesday, April 12, 2017 4:58 AM
My heart jumped, as for a moment I thought MS had created new JET...
--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 12, 2017 at 7:38 am

#1937837
RE: Are the posted questions getting worse?

jasona.work - Tuesday, April 11, 2017 1:46 PM
Just was looking in the topic on using Numeric as a Primary Key...
I know I'm...
--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:52 pm

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

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