Jeff Moden

Forum Replies Created

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

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
RE: PL_SQL compares with T_SQL

PL\SQL is not a procedural language. It's used a lot that way but still seriously benefits from set-based coding.
--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 12:17 pm

#1959167
RE: comma separated values

newdba2017 - Tuesday, September 12, 2017 12:02 PM
It worked. Thanks Sue.
Now, do you understand how and why it works? Do you also...
--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 12:11 pm

#1959166
RE: Microsoft SQL Server Utilities and Tools

Thom A - Tuesday, September 12, 2017 8:57 AM
Jeff Moden - Tuesday, September 12, 2017 8: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 12, 2017 at 9:25 am

#1959145
RE: Suspect production database

Heh... I posted while Gail was posting. Great minds think alike.
--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 9:21 am

#1959142

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