Jeff Moden

Forum Replies Created

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

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
RE: 64 bit

SQLkiwi (12/20/2010)
I was hoping Denali (SQL11) would be 64-bit only, but at least they have clarified its target usage by removing 32-bit AWE, so 32-bit OS servers will only 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 28, 2010 at 9:08 pm

#1267001
RE: Paranthesis alignment and Negative Number

ry.sqldev (12/27/2010)
I am representing negative number within parenthesis , but as I am working on reporting service, it is possible to make the exact alignment of the number and...
--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 8:56 pm

#1267000
RE: Question on Database Design

Core6430 (12/26/2010)
This is really troubling me, and I've been beating my head against a wall for 2 and a half weeks attempting to research/find logical arguments for or against 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)

December 28, 2010 at 8:52 pm

#1266998

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