Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,091 through 15,105 (of 59,101 total)

RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, May 2, 2017 9:21 AM
Jeff Moden - Monday, May 1, 2017 4:10 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)

May 2, 2017 at 2:21 pm

#1940785
RE: Questions for me to ask during a job interview

Since it came up... I've seen many companies that try to make a DBA decision based on 1/2 hour interviews and those people are absolutely nuts. Yes, it IS easily...
--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)

May 2, 2017 at 1:50 pm

#1940776
RE: Export data in XML to import into Word

kevaburg - Tuesday, May 2, 2017 11:44 AM
Matt Simmons - Tuesday, May 2, 2017 8:32 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)

May 2, 2017 at 1:41 pm

#1940775
RE: Are the posted questions getting worse?

Lynn Pettis - Monday, May 1, 2017 3:28 PM
Some day, Jeff, we need to setup a Skype "interview" and see just how...
--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)

May 1, 2017 at 4:10 pm

#1940622
RE: Need Logic

That being said, please see the first link under "Helpful Links" in my signature line below for how to post readily consumable data to help us help you more quickly.
--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)

May 1, 2017 at 3:51 pm

#1940620
RE: Sync Prod to Non-Prod

Rechana Rajan - Monday, May 1, 2017 7:13 AM
Jeff Moden - Friday, February 10, 2017 7:11 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)

May 1, 2017 at 2:16 pm

#1940607
RE: Are the posted questions getting worse?

Getting back to the original question that started "The Thread"...
No need to pile on but the following link is what this world has come to and why so...
--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)

May 1, 2017 at 2:10 pm

#1940606
RE: Table Changes

danielnunez86 - Friday, April 28, 2017 1:27 PM
I have a table with Personnel Records.
Those records have information on a a table 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)

May 1, 2017 at 1:58 pm

#1940602
RE: Encrypting the data

Heh.... I just scribble over the data with two different ball point pens. 😉
--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)

May 1, 2017 at 1:42 pm

#1940601
RE: Find and Replace a value across all tables in database

Devendra Thakur - Sunday, April 30, 2017 10:51 PM
Jeff Moden - Saturday, April 29, 2017 4:03 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)

May 1, 2017 at 1:39 pm

#1940600
RE: Query Performance Standards - Overall Per DB

chris.munsell - Monday, May 1, 2017 8:11 AM
Jeff Moden - Wednesday, April 26, 2017 9: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)

May 1, 2017 at 1:01 pm

#1940594
RE: Export data in XML to import into Word

kevaburg - Sunday, April 30, 2017 1:48 AM
Jeff Moden - Saturday, April 29, 2017 5:02 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 30, 2017 at 3:31 pm

#1940514
RE: Keeping up to, and down with, Date

TomThomson - Friday, April 28, 2017 5:28 PM
Eric M Russell - Monday, January 9, 2017 3:33 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 29, 2017 at 9:47 pm

#1940502
RE: Export data in XML to import into Word

kevaburg - Saturday, April 29, 2017 11:19 AM
So, I have altered the BCP export to include elements and the root element:
[code...
--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 29, 2017 at 5:02 pm

#1940498
RE: Importing only certain named columns from CSV

achilleid - Friday, April 28, 2017 3:25 PM
I have a client that is terrible about giving me consistent data sets, so there...
--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 29, 2017 at 4:44 pm

#1940497

Viewing 15 posts - 15,091 through 15,105 (of 59,101 total)