Jeff Moden

Forum Replies Created

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

RE: Your Favorite Feature that Needs Work

Thom A - Friday, February 3, 2017 3:40 AM
Jeff Moden - Friday, February 3, 2017 1:01 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 3, 2017 at 7:10 am

#1926579
RE: Your Favorite Feature that Needs Work

That's just the top feature. What I'd really like is (to name a few)...
1. Make the ACE drivers more intelligent and useful.
2. Make FORMAT run at least as...
--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 3, 2017 at 1:01 am

#1926529
RE: High Memory Usage

If you sum up the "Size" column of sys.master_files for all of your MDF/NDF files and divide by 128, what do you get for a result?
--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 3, 2017 at 12:25 am

#1926525
RE: Your Favorite Feature that Needs Work

One of the oldest and higher voted active connect requests (10 years on 2/18) that I see no glimmer of even being worked on can be found at the following...
--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 11:20 pm

#1926522
RE: High Memory Usage

No... 12GB is too little for a database server. Buy some more memory for 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 2, 2017 at 9:54 pm

#1926518
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

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