Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,276 through 13,290 (of 59,095 total)

RE: An Introduction to PowerShell for a DBA

kevaburg - Tuesday, January 2, 2018 12:37 AM
To be honest I would love to see your answer written as an article 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)

January 2, 2018 at 6:01 am

#1974048
RE: Understanding Your Value

BWAAA-HAAAA!!!! I wonder how many people that respond to the survey know how to get the current date and time in SQL Server. 😉
--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)

January 1, 2018 at 11:30 pm

#1974014
RE: An Introduction to PowerShell for a DBA

kevaburg - Sunday, December 31, 2017 7:55 AM
Jeff Moden - Saturday, December 30, 2017 6:47 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)

January 1, 2018 at 11:15 pm

#1974013
RE: An Introduction to PowerShell for a DBA

kevaburg - Saturday, December 30, 2017 1:52 AM
Jeff Moden - Friday, December 29, 2017 7:51 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)

December 30, 2017 at 6:47 pm

#1973990
RE: BULK INSERT ERROR

shaikwaseem888 - Saturday, December 30, 2017 3:24 PM
Dear Friends,
i am new in this forum and i hope that i will get 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)

December 30, 2017 at 3:41 pm

#1973989
RE: Happy New Year 2018

I'm going to leave all aspects of work, bug fixes, moving to better hardware, upgrades, etc, etc, out of this and simply say, Mr. Jones, thank you for what you...
--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)

December 30, 2017 at 3:20 pm

#1973987
RE: How to convert kilograms to pounds and ounces

TomThomson - Saturday, December 30, 2017 4:50 AM
Jeff Moden - Friday, December 29, 2017 7:35 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)

December 30, 2017 at 6:36 am

#1973940
RE: Index Fragmentation

jarmendadmin - Monday, December 4, 2017 6:11 PM
Jeff Moden - Monday, December 4, 2017 4:23 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)

December 29, 2017 at 10:00 pm

#1973928
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Friday, December 29, 2017 11:48 AM
Hmmm.... they're overdue... I wonder when they're going to throw SSIS on...
--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)

December 29, 2017 at 7:51 pm

#1973927
RE: Login less users in sql ?

vsamantha35 - Thursday, December 28, 2017 2:23 PM
(i mean what are the use cases for login less users)?
It's great for testing...
--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)

December 29, 2017 at 7:49 pm

#1973926
RE: How to convert kilograms to pounds and ounces

J Livingston SQL - Friday, December 29, 2017 10:48 AM
NineIron - Friday, December 29, 2017 8:48 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)

December 29, 2017 at 7:35 pm

#1973924
RE: How to convert kilograms to pounds and ounces

Much easier solution is to simply weigh it on a pounds scale. 😉
--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)

December 29, 2017 at 7:16 pm

#1973923
RE: Splitting TempDB across multiple files

DimPerson - Thursday, December 28, 2017 1:36 AM
I think it's up to you, and it depends what you are using the UAT...
--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)

December 28, 2017 at 6:27 am

#1973693
RE: The Case of the Shrinking CFO, err Database

Cody Konior - Wednesday, August 19, 2015 8:52 AM
Jesus this article is downright dangerous. Follow at your own peril and only after...
--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)

December 27, 2017 at 8:27 pm

#1973664
RE: Want to know what process revert a change of a value in a column

imran-k - Wednesday, December 27, 2017 7:14 PM
Thanks all for the inputs. The date field is a datetime field. Ok what i...
--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)

December 27, 2017 at 8:20 pm

#1973662

Viewing 15 posts - 13,276 through 13,290 (of 59,095 total)