Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,586 through 12,600 (of 59,095 total)

RE: Removing stored procedures to move to cloud

Luis Cazares - Friday, April 6, 2018 11:11 AM
Steve Thompson-454462 - Friday, April 6, 2018 10:49 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 7, 2018 at 12:39 pm

#1985889
RE: SQL Server 2016 Job running long

c.bhuvaneswari - Tuesday, April 3, 2018 2:27 PM
Hi,
We have a job(SSIS package) running in our datawarehouse environment. It usually runs in 40...
--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 7, 2018 at 12:28 pm

#1985888
RE: Service Account in Registry

Awesome... You asked the question and you're answering it with some pretty good stuff. Thanks for taking the time, Jeff!
--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 6, 2018 at 4:49 pm

#1985867
RE: taking very long time to execute

sgmunson - Friday, April 6, 2018 12:49 PM
Sean Lange - Thursday, April 5, 2018 9:44 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 6, 2018 at 2:09 pm

#1985859
RE: The SQL Joke Thread

sgmunson - Friday, April 6, 2018 1:57 PM
Jeff Moden - Friday, April 6, 2018 1:54 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 6, 2018 at 2:06 pm

#1985858
RE: Download 3rd Party S3 Files

RTaylor2208 - Tuesday, April 3, 2018 8:32 AM
This is one way to do it:
$aws_profile = 'MyAWSProfile'
$awskey = 'XXXXXXXXXXXXX'
$awssecretkey = 'XXXXXXXXXXXXXX'
$bucket = "MyBucket"
$keyPrefix...
--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 6, 2018 at 2:05 pm

#1985856
RE: The SQL Joke Thread

below86 - Friday, April 6, 2018 9:43 AM
Do you know why Jeff had to get out of the construction business?
He refused to...
--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 6, 2018 at 1:54 pm

#1985852
RE: OPENQUERY error: An unexpected NULL value was returned

crmitchell - Friday, April 6, 2018 8:53 AM
Jeff Moden - Friday, April 6, 2018 6:10 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 6, 2018 at 9:23 am

#1985820
RE: Is the DBA Title Dying?

ZZartin - Friday, April 6, 2018 8:10 AM
Jeff Moden - Friday, April 6, 2018 7:42 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 6, 2018 at 8:58 am

#1985813
RE: Is the DBA Title Dying?

roger.plowman - Friday, April 6, 2018 8:03 AM
Jeff Moden - Friday, April 6, 2018 7:42 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 6, 2018 at 8:57 am

#1985812
RE: Help with dertermining number of days between dates

LeeFAR - Friday, April 6, 2018 6:33 AM
Jeff Moden - Friday, April 6, 2018 6:22 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 6, 2018 at 8:23 am

#1985810
RE: Is the DBA Title Dying?

roger.plowman - Thursday, April 5, 2018 8:54 AM
Jeff Moden - Thursday, April 5, 2018 8:26 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 6, 2018 at 7:42 am

#1985803
RE: Help with dertermining number of days between dates

LeeFAR - Friday, April 6, 2018 6:04 AM
Jeff, this is the method I was looking for and the results in are in...
--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 6, 2018 at 6:22 am

#1985790
RE: OPENQUERY error: An unexpected NULL value was returned

crmitchell - Friday, April 6, 2018 4:45 AM
A few things to consider
Ensure you are using the correct datasource provider - there are at...
--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 6, 2018 at 6:10 am

#1985789
RE: Index rebuilt/Reorganize script didn't remove fragmentation

Also, as further proof that the bong water I'm drinking through two straws actually tastes pretty good, here's the diagram of supposed "Best Practice" methods when the bad page splits...
--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 5, 2018 at 9:49 pm

#1985761

Viewing 15 posts - 12,586 through 12,600 (of 59,095 total)