Jeff Moden

Forum Replies Created

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

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
RE: How to determine what percent of a varchar column is a valid numeric?

allan.ford17 - Tuesday, February 26, 2019 7:38 PM
I have a data profiling type of question :
I'm interesting in a query to determine...
--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 7:36 am

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

Grant Fritchey - Wednesday, February 27, 2019 1:40 AM
Personally, I don't put numbers in varchar if I want them to be numbers....
--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 7:31 am

#2023074
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, February 27, 2019 4:40 AM
Since when is an email address PII? Even associated with a name, 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)

February 27, 2019 at 5:31 am

#2023063

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