Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,466 through 12,480 (of 59,095 total)

RE: Recovery mode reverting to Full

sharky - Thursday, April 26, 2018 6:25 AM
Thom, Erikur, Thanks for the help.. Understand a bit more how AWS works.. thanks.. 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 27, 2018 at 4:24 pm

#1988533
RE: designing portal so we don't run into performance issues.

NewBornDBA2017 - Friday, April 27, 2018 12:35 PM
Sue_H - Thursday, April 26, 2018 3:36 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 27, 2018 at 4:01 pm

#1988532
RE: Are the posted questions getting worse?

Jason A. Long - Friday, April 27, 2018 11:14 AM
Steve Jones - SSC Editor - Thursday, April...
--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 27, 2018 at 11:26 am

#1988496
RE: Packaged-Application Database Nightmares - A Horror Story.

Eric M Russell - Thursday, April 26, 2018 7:42 AM
Jeff Moden - Wednesday, April 25, 2018 4:17...
--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 26, 2018 at 8:23 am

#1988359
RE: Packaged-Application Database Nightmares - A Horror Story.

p.s. I'm going through the drill right now. Our telephone system vendor has asked for a login with "sa" privs for their new reporting system. They're into that "Well other...
--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 25, 2018 at 4:17 pm

#1988278
RE: Packaged-Application Database Nightmares - A Horror Story.

Ray Herring - Wednesday, April 25, 2018 1:13 PM
Jeff Moden - Wednesday, April 25, 2018 7:56 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 25, 2018 at 4:14 pm

#1988277
RE: Auditing

Sue_H - Wednesday, April 25, 2018 3:45 PM
AndrewL65 - Tuesday, April 24, 2018 4:35 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 25, 2018 at 4:02 pm

#1988275
RE: Getting 10,000 rows of SQL code into SSRS

jeffshelix - Wednesday, April 25, 2018 7:48 AM
I wrote 10,000 lines of SQL (several temp tables) and i would like to move...
--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 25, 2018 at 8:05 am

#1988187
RE: Stored Proc Permissions

Sounds like an interview question.
--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 25, 2018 at 8:03 am

#1988184
RE: Transferring data between tables

richardmgreen1 - Wednesday, April 25, 2018 7:51 AM
To be honest, it wasn't very scientific.
We split them into 300 column "lumps".
We've quite of...
--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 25, 2018 at 7:58 am

#1988182
RE: Packaged-Application Database Nightmares - A Horror Story.

Eric M Russell - Wednesday, April 25, 2018 7:47 AM
If a software application is hard coded to use the "SA" account,...
--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 25, 2018 at 7:56 am

#1988180
RE: Database Administration Team Reporting Hierarchy

alex.sqldba - Wednesday, April 25, 2018 4:49 AM
Morning Guys,
I have an organisational question and dilemma I am trying to work through; and...
--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 25, 2018 at 7:49 am

#1988176
RE: Transferring data between tables

richardmgreen1 - Wednesday, April 25, 2018 3:42 AM
We've decided to split the table into sections (with _1, _2, etc. where necessary).
We kept...
--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 25, 2018 at 7:38 am

#1988173
RE: Packaged-Application Database Nightmares - A Horror Story.

andrew gothard - Wednesday, April 25, 2018 4:01 AM
And, having worked with numerous third party packages I'm supposed to be surprised by...
--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 25, 2018 at 7:35 am

#1988172
RE: Calculating Date Difference

tinausa - Tuesday, April 24, 2018 9:00 AM
Jeff Moden - Tuesday, April 24, 2018 7: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)

April 24, 2018 at 12:36 pm

#1988099

Viewing 15 posts - 12,466 through 12,480 (of 59,095 total)