Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,751 through 9,765 (of 59,102 total)

RE: Week of 1st day of Year

omelo - Saturday, March 2, 2019 9:10 AM
Hi, This post is old but it is related to the question I have.
I'm using ...
--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)

March 4, 2019 at 5:58 am

#2023421
RE: Compare Two Row in the table and find what columns are changed based on idno and date

I have to admit to being strongly confused because your test data doesn't match your desired output.
For example, here's your desired output... I've pointed to two rows for...
--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)

March 2, 2019 at 8:20 am

#2023374
RE: DBA left and they shut off his AD account

DataAnalyst011 - Friday, March 1, 2019 11:29 AM
You all are a life-saver. Thank you so much for all the advice. I've switch...
--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)

March 1, 2019 at 5:15 pm

#2023360
RE: DBA left and they shut off his AD account

DataAnalyst011 - Thursday, February 28, 2019 1:51 PM
Our DBA left and they shut off his account. Of course, things started failing all...
--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)

March 1, 2019 at 10:30 am

#2023314
RE: Are the posted questions getting worse?

Jack Corbett - Thursday, February 28, 2019 1:53 PM
Jeff Moden - Monday, February 25, 2019...
--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)

March 1, 2019 at 8:01 am

#2023296
RE: Last DB Usage

DBA_007 - Thursday, February 28, 2019 5:46 AM
How to check DB last used or how to remove orphaned databases based on 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)

February 28, 2019 at 7:43 am

#2023203
RE: List edition and version of all SQL Server machines over the Network ...

I am by no means a Windows Ninja but it seems to me that the Domain Controller would be aware of all machines on the network. Perhaps interrogating the Domain...
--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)

February 28, 2019 at 7:33 am

#2023199
RE: How to determine what percent of a varchar column is a valid numeric?

allan.ford17 - Wednesday, February 27, 2019 3:11 PM
Lots of excellent advice and answers .. thank you all ..
Appreciate warnings from Jeff about...
--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)

February 27, 2019 at 4:25 pm

#2023144
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, February 27, 2019 4:31 AM
I'm sorry for your loss, Jeff. You, your brother, and his wife have my...
--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)

February 27, 2019 at 1:44 pm

#2023134
RE: Are the posted questions getting worse?

David Burrows - Wednesday, February 27, 2019 9:03 AM
Jeff Moden - Monday, February 25, 2019 12:16 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)

February 27, 2019 at 1:43 pm

#2023133
RE: Are the posted questions getting worse?

TomThomson - Wednesday, February 27, 2019 9:12 AM
Jeff Moden - Monday, February 25, 2019 12:16 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)

February 27, 2019 at 1:40 pm

#2023132
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, February 27, 2019 10:36 AM
Jeff Moden - Wednesday, February 27, 2019 8:03 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)

February 27, 2019 at 1:39 pm

#2023131
RE: Migrating jobs does not create the maintenance plans

keanyukas - Wednesday, February 27, 2019 6:33 AM
Is there a way to migrate maintenance plans
Yes. Please see the following link. ;-)...
--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)

February 27, 2019 at 8:24 am

#2023081
RE: Are the posted questions getting worse?

ZZartin - Wednesday, February 27, 2019 6:26 AM
Jeff Moden - Wednesday, February 27, 2019 5:31 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)

February 27, 2019 at 8:03 am

#2023078
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Wednesday, February 27, 2019 5:54 AM
Jeff Moden - Monday, February 25, 2019 12:16 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)

February 27, 2019 at 8:01 am

#2023077

Viewing 15 posts - 9,751 through 9,765 (of 59,102 total)