Jeff Moden

Forum Replies Created

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

RE: Best way to determine to Clustered index keys

One of the most informative videos I've ever seen on the subject is by Kimberly Tripp and can be found at the following URL...
https://www.youtube.com/watch?v=QjCEkI8Qm5c
It should...
--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 8:31 am

#1926626
RE: Interview Question

susmitha117 - Friday, February 3, 2017 7:48 AM
Hi. Recently I have attended a couple of interviews. I have faced a similar question...
--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 8:27 am

#1926621
RE: Are the posted questions getting worse?

djj - Friday, February 3, 2017 6:14 AM
Thank you, everyone.
Not a lot of postings with my skill level as I have...
--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:21 am

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

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