Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,471 through 22,485 (of 59,099 total)

RE: Group by question

rash3554 (11/16/2014)
Thanks for the reply. I had one more question. I added a field called 'Ignoreflag' to the table with default value= -1.
It is set to one if Name,Address...
--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)

November 16, 2014 at 4:46 pm

#1758852
RE: Unpivoting multiple columns.

Eirikur Eiriksson (11/16/2014)
Jeff Moden (11/15/2014)
Very clever.
😀
As you know, I'm one of those people that absolutely love Tally-Table-like constructs but, as I've also said, it's not a panacea 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)

November 16, 2014 at 4:10 pm

#1758851
RE: Best Practices

ramana3327 (10/23/2014)
Thanks for the replies.
Yes, they are ready for the budget. They want 3 replicas for some other purpose also. One is specially for reports.
Some how now just one simple...
--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)

November 15, 2014 at 5:49 pm

#1758817
RE: Are the posted questions getting worse?

Something REALLY bad just happened. There are no posts from today on recent posts for today. The only thing that's left is SPAM.
--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)

November 15, 2014 at 4:25 pm

#1758816
RE: converting datetime to 112 type

Sure there are. For example, if you convert a Money data-type to VARCHAR so that you get commas and then store that back in a Money data-type, the commas...
--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)

November 15, 2014 at 9:19 am

#1758811
RE: Bulk database refactoring: how do you do it?

Phil Parkin (11/14/2014)
I've been working on a task to consolidate three databases down to two...
That sounds like a lot of work. My question would be WHY? What 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)

November 15, 2014 at 9:03 am

#1758809
RE: Heap or clustered, What to do ...

Jeff Moden (11/15/2014)
SeanNerd (11/14/2014)
Well - I sure feel silly. I thought all these replies (above) were going to reference the original posters. Sadly, I am a bit new to posting...
--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)

November 15, 2014 at 8:53 am

#1758807
RE: Heap or clustered, What to do ...

SeanNerd (11/14/2014)
Well - I sure feel silly. I thought all these replies (above) were going to reference the original posters. Sadly, I am a bit new to posting here. 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)

November 15, 2014 at 8:52 am

#1758806
RE: Unpivoting multiple columns.

Very clever.
As you know, I'm one of those people that absolutely love Tally-Table-like constructs but, as I've also said, it's not a panacea of performance. In this...
--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)

November 15, 2014 at 8:38 am

#1758805
RE: can you have too many rows in a table

Thanks for the plug, Ed! 🙂
--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)

November 15, 2014 at 7:21 am

#1758801
RE: Error creating temp table based on IF logic

sqldriver (11/14/2014)
Jeff Moden (11/14/2014)
Is this, by any chance, for an "eDiscovery" system for use during litigation?
Well, I can guarantee you that no one hands over their Outlook data files because...
--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)

November 14, 2014 at 8:41 pm

#1758778
RE: Scalability Question

Agreed. I should have stated that I was emphasizing the problem of scalability that you brought up.
--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)

November 14, 2014 at 8:37 pm

#1758777
RE: can you have too many rows in a table

Lowell (11/14/2014)
and the issue is often not really related to the number of rows, but if it can be accessed effectively and with reasonable speed.
that starts bringing in things like...
--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)

November 14, 2014 at 7:14 pm

#1758774
RE: Scalability Question

Gosh, be really careful folks. I'm no purist when it comes to EAVs but there are some serious problems with them to consider. First, putting such an EAV...
--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)

November 14, 2014 at 6:35 pm

#1758771
RE: Error creating temp table based on IF logic

Is this, by any chance, for an "eDiscovery" system for use during litigation?
--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)

November 14, 2014 at 6:15 pm

#1758769

Viewing 15 posts - 22,471 through 22,485 (of 59,099 total)