Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,326 through 14,340 (of 59,101 total)

RE: Determining Memory Pressure

Arsh - Thursday, September 14, 2017 2:44 AM
GilaMonster - Wednesday, September 13, 2017 11:28 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)

September 14, 2017 at 6:52 am

#1959411
RE: Running total with reset condition

Steve Jones - SSC Editor - Wednesday, September 13, 2017 8:37 AM
Please mark Jeff's answer as correct, if you wouldn't mind.
Thank 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)

September 13, 2017 at 4:48 pm

#1959351
RE: SQL 2012 file processing from Access

I'm thinking the ACE drivers might let you do such a thing directly.
--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)

September 13, 2017 at 4:44 pm

#1959350
RE: Determining Memory Pressure

GilaMonster - Wednesday, September 13, 2017 11:28 AM
Jeff Moden - Wednesday, September 13, 2017 6:33 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)

September 13, 2017 at 1:24 pm

#1959324
RE: PL_SQL compares with T_SQL

Chris Harshman - Wednesday, September 13, 2017 10:59 AM
If I remember correctly, in Oracle everything is a cursor behind the scenes, even...
--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)

September 13, 2017 at 11:12 am

#1959296
RE: Determining Memory Pressure

ScottPletcher - Wednesday, September 13, 2017 10:27 AM
Jeff Moden - Wednesday, September 13, 2017 6:33 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)

September 13, 2017 at 11:04 am

#1959293
RE: No Data in a table when database is restored

Sydknee - Wednesday, September 13, 2017 8:42 AM
The original table has data in it and still has, that was one of 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)

September 13, 2017 at 10:30 am

#1959288
RE: No Data in a table when database is restored

Sydknee - Wednesday, September 13, 2017 7:59 AM
Got a bit of an unusual one that's got me scratching my head.
I'm covering a...
--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)

September 13, 2017 at 8:20 am

#1959255
RE: Are the posted questions getting worse?

BrainDonor - Wednesday, September 13, 2017 7:50 AM
Lynn Pettis - Tuesday, September 12, 2017 12:38 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)

September 13, 2017 at 8:18 am

#1959254
RE: Are the posted questions getting worse?

Thom A - Wednesday, September 13, 2017 7:54 AM
BrainDonor - Wednesday, September 13, 2017 7:50 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)

September 13, 2017 at 8:17 am

#1959252
RE: Problem with parameterized query

nadersam - Wednesday, September 13, 2017 2:36 AM
bmg002 - Tuesday, September 12, 2017 1:29 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)

September 13, 2017 at 6:43 am

#1959233
RE: Determining Memory Pressure

Arsh - Wednesday, September 13, 2017 5:33 AM
Dear Experts,
I'm trying to figure out if my SQL server is facing any memory pressure...
--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)

September 13, 2017 at 6:33 am

#1959232
RE: The struggle to renormalize data

xsevensinzx - Wednesday, September 13, 2017 1:09 AM
Jeff Moden - Monday, September 11, 2017 11:04 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)

September 13, 2017 at 6:02 am

#1959228
RE: Running total with reset condition

Talvin Singh - Wednesday, September 13, 2017 2:32 AM
This works very well!
i was able to test it on a large dataset, works...
--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)

September 13, 2017 at 5:23 am

#1959227
RE: PL_SQL compares with T_SQL

sqlfriends - Tuesday, September 12, 2017 1:28 PM
I see on this page: https://en.wikipedia.org/wiki/PL/SQL

PL/SQL (Procedural Language/Structured Query Language
I think the "PL" part...
--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)

September 12, 2017 at 10:03 pm

#1959197

Viewing 15 posts - 14,326 through 14,340 (of 59,101 total)