Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,721 through 15,735 (of 59,063 total)

RE: Deciding on being Developer or DBA

Xedni - Thursday, February 2, 2017 1:12 PM
I'm interested in anyone's thoughts on this sort of move, although my main question is...
--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 2, 2017 at 9:28 pm

#1926516
RE: The New DBA is a Developer

Sue_H - Thursday, February 2, 2017 12:53 PM
Yet Another DBA - Thursday, February 2, 2017 2:45 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 2, 2017 at 2:00 pm

#1926471
RE: DUPLICATING A ROW BY NUMBER OF OCCURENCE OF A PARTICULAR FIELD IN ANOTHER TABLE

JALLY - Thursday, February 2, 2017 12:53 PM
Thanks everyone,
I figured it out and used a while loop in a cursor.
Thanks
Jally, post some...
--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 2, 2017 at 1:55 pm

#1926470
RE: The New DBA is a Developer

Yet Another DBA - Thursday, February 2, 2017 6:56 AM
Jeff Moden - Thursday, February 2, 2017 6:34 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 2, 2017 at 12:19 pm

#1926434
RE: Merge multiple .sql files into one single file

David Burrows - Thursday, February 2, 2017 6:58 AM
FOR %%f IN (*.sql) DO ....
They have an even easier method now...
https://technet.microsoft.com/en-us/library/cc753551(v=ws.11).aspx
--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 2, 2017 at 7:54 am

#1926342
RE: Delete the duplicate records of table having only one column

Chris Harshman - Thursday, February 2, 2017 6:58 AM
John Mitchell-245523 - Thursday, February 2, 2017 4:05 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 2, 2017 at 7:21 am

#1926328
RE: Delete the duplicate records of table having only one column

Bharat21 - Thursday, February 2, 2017 3:57 AM
Hi all,
Kindly suggest or share such query to me , How we can delete 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 2, 2017 at 6:35 am

#1926302
RE: The New DBA is a Developer

Yet Another DBA - Thursday, February 2, 2017 2:45 AM
Wow, there is so much hair splitting on this thread that it would...
--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 2, 2017 at 6:34 am

#1926301
RE: Age as of January 1st

thomashohner - Tuesday, January 31, 2017 5:20 PM
ScottPletcher - Monday, January 30, 2017 2:14 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 1, 2017 at 8:19 pm

#1926240
RE: Age as of January 1st

Shifting gears back to this part of the original post...
So if I have a BirthDate = 11/30/1951 there age as a whole number as of January 1st of...
--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 1, 2017 at 8:13 pm

#1926238
RE: Merge multiple .sql files into one single file

lewisdow123 90045 - Wednesday, February 1, 2017 4:42 PM
Hi,
Does anyone have a program or utility that can merge multiple .sql files in...
--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 1, 2017 at 8:04 pm

#1926236
RE: Any way to guesstimate internet needs for remote DBA?

I'm just curious... if you normally have the "unlimited" and "high speed" thing, why is it that you will have less than that for a period of time? Hopefully, it...
--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 1, 2017 at 8:01 pm

#1926235
RE: The New DBA is a Developer

Steve Jones - SSC Editor - Wednesday, February 1, 2017 5:59 PM
Jeff, that's just not true.
It was not a scripting issue. It...
--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 1, 2017 at 7:44 pm

#1926233
RE: The New DBA is a Developer

This is just poor administration, regardless of job title.
Databases don't just live in SQL Server. Just like job titles, databases come in many forms. And "Just poor...
--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 1, 2017 at 5:18 pm

#1926220
RE: Are the posted questions getting worse?

Koen Verbeeck - Wednesday, February 1, 2017 3:03 PM
Happy, delighted, humbled and overall gleeful to announce that I'm awarded the Microsoft Data...
--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 1, 2017 at 4:04 pm

#1926212

Viewing 15 posts - 15,721 through 15,735 (of 59,063 total)