Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,536 through 35,550 (of 59,102 total)

RE: Are the posted questions getting worse?

ALZDBA (12/31/2010)
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congratulations for the 10K barrier.
Thank you for your support,...
--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)

December 31, 2010 at 12:38 pm

#1268173
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Langston Montgomery (12/29/2010)
You've outdone yourself with this one Jeff. This article is fantastic. I guess the thing for me to remember, and the reason why some call it an unreliable...
--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)

December 31, 2010 at 7:10 am

#1268099
RE: Are the posted questions getting worse?

LutzM (12/31/2010)
Jeff Moden (12/31/2010)
...
Still, I missed the article when it came out. What's the link, please?
The easiest way: HOME->Previous headlines->Top 1.
Or even easier: http://www.sqlservercentral.com/articles/T-SQL/71950/
I wish you and your family...
--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)

December 31, 2010 at 5:50 am

#1268082
RE: Are the posted questions getting worse?

Gianluca Sartori (12/30/2010)
jcrawf02 (12/30/2010)
Great job on the short-circuit article, Gianluca!
Thank you, Jon! It would have been a hill of crap without the help of Gus, Jeff and Paul (in strict...
--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)

December 31, 2010 at 5:41 am

#1268077
RE: Are the posted questions getting worse?

jcrawf02 (12/30/2010)
Great job on the short-circuit article, Gianluca!
I missed it... what's the link?
--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)

December 31, 2010 at 5:32 am

#1268075
RE: First time semi-complex query - its slow!!!

Ok... forgot a question I was going to ask you, Joe. If you're so set against "mag tape" technology, why do you always recommend converting an Adjacency List to...
--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)

December 30, 2010 at 2:26 pm

#1267954
RE: First time semi-complex query - its slow!!!

CELKO (12/29/2010)
>> mag tape processing and IDENTITY columns works a charm even in an RDBMS! <<
LOL! I keep seeing people who never worked with tapes re-discovering them in SQL....
--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)

December 30, 2010 at 2:17 pm

#1267951
RE: Denali CTP1

Eralper (12/24/2010)
You know now the RTM products are released with SP1 🙂
Did that actually happen with 2k5?
--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)

December 30, 2010 at 1:53 pm

#1267947
RE: Remove non printable characters

telastruct (12/30/2010)
Actually, I did test it and it works great. I tested it on a table with almost 4 million rows and it only took a minute or two.
As Paul...
--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)

December 30, 2010 at 1:21 pm

#1267932
RE: Are the posted questions getting worse?

Craig Farrell (12/29/2010)
Hey guys. Blogging/articles and the like are relatively new to me, so I'd like your educated opinions on how I should look at this:
http://balapalani.blogspot.com/2010_12_01_archive.html
It's roughly a copy/paste...
--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)

December 30, 2010 at 6:27 am

#1267643
RE: Are the posted questions getting worse?

Roy Ernest (12/29/2010)
Today is my last working day for this year. There fore I want to wish everyone a very happy and prosperous new year, 2011.
On another note, 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)

December 30, 2010 at 6:20 am

#1267642
RE: First time semi-complex query - its slow!!!

CELKO (12/27/2010)
Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. yada-yada-yada
You're a day late and a dollar short,...
--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)

December 28, 2010 at 9:34 pm

#1267007
RE: Pivot

kevin4u06 (12/28/2010)
Never mind....i got it.....i was on 2000 server...thanks all
Heh... scary stuff that we've all done. Glad it wasn't something like dropping a table from a dev server... or...
--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)

December 28, 2010 at 9:25 pm

#1267005
RE: t-sql

wendy elizabeth (12/28/2010)
Thanks! This sql works very well!
It may not matter but it looks like that code will find table and view names in comments, as well, which may produce...
--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)

December 28, 2010 at 9:22 pm

#1267004
RE: for each in a query on SQL 2000

Heh... no need to curse(or) in public, Gus... 😛
Here's a real old example of how to do it in SQL Server 2000... if you want code for your data, please...
--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)

December 28, 2010 at 9:17 pm

#1267002

Viewing 15 posts - 35,536 through 35,550 (of 59,102 total)