Jeff Moden

Forum Replies Created

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

RE: Stumbling over Words

Great article, Phil. It should be required reading for anyone writing a blog or article or giving a presentation.
I'll also add that articles or blog entries shouldn't be...
--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 8, 2018 at 1:01 pm

#1985908
RE: Table Row Count

VastSQL - Sunday, April 8, 2018 4:53 AM
Hi Experts,
We have a very Large table which hold almost 185GB of data.
When ran...
--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 8, 2018 at 8:33 am

#1985905
RE: Are the posted questions getting worse?

Michael L John - Saturday, April 7, 2018 5:46 PM
A few weeks back, we were all sharing our "can you top this"...
--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 5:55 pm

#1985898
RE: SELECTing a hierachy

Apparently, the OP has left the building.
--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 5:54 pm

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

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