Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,076 through 45,090 (of 59,095 total)

RE: Guest editorial: SQL Code Metrics

Phil Factor (2/19/2009)
Perl is great, and I've used it a fair bit, but it is a Smörgåsbord. You want something? It gets bolted on somehow. What you don't get 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 19, 2009 at 6:09 am

#946587
RE: String Comparison Explanation

I haven't had such a problem in a while, but for things like BULK INSERT and BCP, I seem to remember this type of thing happening with the file type...
--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 18, 2009 at 11:03 pm

#946478
RE: Are the posted questions getting worse?

Steve Jones - Editor (2/18/2009)
Since this thread seems to be the most popular, a question:
What features would really help you "high posters" here at SSC? Changes to the forums? 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 18, 2009 at 10:52 pm

#946476
RE: Are the posted questions getting worse?

BobAtDBS (2/18/2009)
Dear Learned Ones:
I need help with a SQL Server problem. I don't understand exactly what's going on, or what I should be expecting, but my co-worker said 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)

February 18, 2009 at 10:47 pm

#946474
RE: Are the posted questions getting worse?

Roy Ernest (2/18/2009)
For me this is how it goes... I at first had problem with BOL, because the functions were different from Oracle. So it was frustrating. Now 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 18, 2009 at 10:42 pm

#946472
RE: In way over my head

James A. Lawrence (2/18/2009)
Off topic...
Wow, Jeff....cool avatar!
Heh... Thanks, James. Everyone kept bugging me to do something in the Star Wars fashion... I ran into a clip of a guy...
--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 18, 2009 at 10:39 pm

#946471
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

jcrawf02 (2/18/2009)
Jeff, I just made myself feel a whole lot better today, since I was helping someone work through a Pivot, and ended up doing much of what you demonstrate...
--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 18, 2009 at 10:14 pm

#946465
RE: Guest editorial: SQL Code Metrics

Speaking of CLR's and Perl...
There's only two classes of CLR's that I haven't been able to beat for performance (so far), but I've come damned close... RegEx and certain types...
--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 18, 2009 at 9:52 pm

#946458
RE: how to split following string

Heh... p.s.
I know this is a 2k forum, but anyone want to challenge with a CLR? The only way I can see a CLR coming close on this one...
--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 18, 2009 at 9:22 pm

#946455
RE: how to split following string

Steve Jones - Editor (2/18/2009)
5 days is plenty. Sorry, missed the OP date.
I'm interested to see the benchmarks. I know doing this in C would be complicated, but not tremendously...
--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 18, 2009 at 9:04 pm

#946453
RE: how to split following string

Steve Jones - Editor (2/17/2009)
Give him or her time, might be on the other side of the world.
If you compare REVERSE with SUBSTRING or other string functions, how much slower...
--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 18, 2009 at 6:42 am

#945847
RE: The Value of Your Time

... and if you can't trust them, you probably hired the wrong person and should spend more time on personnel evals and the firing process than approving travel for someone...
--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 17, 2009 at 10:42 pm

#945672
RE: Do I need to index this table?

Ah... another "tweek"....
WHERE EmployeeID IS NOT NULL is a bit slower than WHERE EmployeeID > 0 assuming, of course, that you have no EmployeeID's <= 0... sometimes, quite a...
--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 17, 2009 at 10:33 pm

#945669
RE: Do I need to index this table?

Lynn's suggested changes are a great way to start. What he failed to mention is... why. Even if you added a pot wad of indexes to the original...
--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 17, 2009 at 10:30 pm

#945667
RE: Guest editorial: SQL Code Metrics

p.s. ... and we did it without {gasp} tool tips in SQL. Yes, there are some grand improvements that could be made to SQL, but we've seen 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 17, 2009 at 10:17 pm

#945664

Viewing 15 posts - 45,076 through 45,090 (of 59,095 total)