Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,676 through 27,690 (of 59,101 total)

RE: Better Way to Perform this Query

Yes.
It would also give the wrong answer, IMHO.
--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 9, 2013 at 9:58 pm

#1575575
RE: Better Way to Perform this Query

Alan.B (1/9/2013)
AndrewSQLDBA (1/9/2013)
Its worth noting that the following is sargable.
LIKE '%abc%'
Did you mean "NOT" SARGable because it sure doesn't look SARGable from here. 😉 And, I agree......
--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 9, 2013 at 9:54 pm

#1575573
RE: what type of database to use ?

fearghalreilly (1/9/2013)
In one of my tests I was asked this question
you are working as part of the database team for the zoro online company . a junior database developer approaches...
--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 9, 2013 at 9:42 pm

#1575568
RE: many to many join and union all

What's the PK of each of those tables?
--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 9, 2013 at 8:42 pm

#1575558
RE: Hey!

Heh... I was going to report this as spam but anyone who makes that kind of claim of service deserves to "live" in this day and age of the rather...
--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 9, 2013 at 8:33 pm

#1575556
RE: Need Deadlock Help

If by "update a report table" you mean inserting into it, the trigger is just fine. Something else is going and you just need to find it. Perhaps...
--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 9, 2013 at 8:26 pm

#1575555
RE: Copy Between 2 and 3 billion rows from a heap table with no key to a new partioned table.

I think you've made a mistake in chosing what to partition by. My recommenation would be to partition by month or year of the column that best represents 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)

January 9, 2013 at 8:10 pm

#1575553
RE: Are the posted questions getting worse?

dwain.c (1/8/2013)
Am I the only one that finds these kinds of SQL puzzles fun?
http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx
Come on! Surely some of you heavyweights can whip up a cool solution to it.
No, you're...
--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 9, 2013 at 10:40 am

#1575347
RE: Best way to Calculate Human Age from a Birthdate

AndrewSQLDBA (1/8/2013)
Hello Everyone
Happy New Year!!!
I am fooling around with some code, and was wondering if there is a really great function to calculate the birthdate of a person. One that...
--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 9, 2013 at 8:03 am

#1575273
RE: Assigning current date without time value to column

Cadavre (1/4/2013)
10e5x (1/4/2013)
omg i am losing the discussion over here... so the recommended solution to me is which? And is it a typo or? why there are two '??' sry...
--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 9, 2013 at 6:46 am

#1575219
RE: What Counts for a DBA: Amnesia

Ah... now I understand what you're trying to say. If someone has the wrong attitude about it, they'll consider it the "pain of learning". If someone has 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)

January 7, 2013 at 4:23 pm

#1574562
RE: What Counts for a DBA: Amnesia

Louis Davidson (@drsql) (1/7/2013)
@jeff moden,
So, I should note that I don't indicate that you should forget everything you know 🙂 Just that "we have to forget the pain 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)

January 7, 2013 at 3:59 pm

#1574557
RE: Using Results from one column to calculate another column

Sorry... double post removed...
--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 6, 2013 at 11:53 pm

#1574177
RE: Need help using the most efficient aggregation method in SQL Server 2008 R2 to sum up child rows in same table

steve.pantazis (1/5/2013)
I will definitely try out your code...thanks.
The reason for insert into ResultHistory is that we process large quantities of sales data from a detail table containing each account opening...
--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 6, 2013 at 11:47 pm

#1574175
RE: Translate rows in columns

I have to say that's one of the longer belated thank-you's I've seen in a while and I still think it's very cool that you came back to do so....
--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 6, 2013 at 11:30 pm

#1574171

Viewing 15 posts - 27,676 through 27,690 (of 59,101 total)