Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,141 through 37,155 (of 59,098 total)

RE: Normalize a table query

jayraj0071 (8/24/2010)
Try soemthing like this!!!
select ID, [Description], Field =
case when ID = 1 then Field1
...
--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)

August 24, 2010 at 6:18 pm

#1211388
RE: Decoupling in Relational Databases

Shawn.Shi (8/24/2010)
SQL ServerCentra.com should validate new posts.
Articles like this waste space and readers' time, and of course should be filtered out.
I've seen many sites (some quite famous and quite popular...
--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)

August 24, 2010 at 5:56 pm

#1211385
RE: array & multilist

harshinderkaur (8/24/2010)
thanx for replying jeff. i want to create a table named book & an array to store the name of authors(maximum 10) of any book . each author name...
--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)

August 24, 2010 at 5:47 pm

#1211383
RE: The Semantics of NULL in SQL Server 2008

Hugo Kornelis (8/24/2010)
Alex-668179 (8/24/2010)
Yes, I find that a lot of the confusion goes away by not calling NULL a "value" but seeing as a state (or state indicator).
Agreed. I think...
--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)

August 24, 2010 at 6:41 am

#1210962
RE: The Semantics of NULL in SQL Server 2008

Hugo Kornelis (8/24/2010)
I rated this article "poor". A lot of the information is correct, and relevant - but there is a very important error, right at the start of 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)

August 24, 2010 at 6:14 am

#1210950
RE: XP_cmdshell DIR

chrs-513176 (8/23/2010)
The file size is greater than 2GB. Is that the max this method can return? Unfortunately, I'm still on 2000 so CLR is not an option for me.
The code...
--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)

August 23, 2010 at 10:01 pm

#1210778
RE: tsql retrieve records on date

Thanks, Kingston. 🙂
--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)

August 23, 2010 at 9:56 pm

#1210775
RE: Today's Random Word!

dbowlin (8/23/2010)
Ray K (8/23/2010)
Brandie Tarvin (8/23/2010)
flood
"Noah . . . I want you to build an ark . . . "
Lord...What's an ark? (From an old Bill Cosby stand...
--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)

August 23, 2010 at 9:54 pm

#1210774
RE: SQL for normalizing repeating groups in a text file

marerose888 (8/23/2010)
I created a table in Access (don't have access to SQL server today) with the repeating fields of colors, then ran sql in my ETL tool and I got...
--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)

August 23, 2010 at 9:49 pm

#1210773
RE: Search part of string within part of string

Gosh... I just wouldn't do this, folks. Too many possible problems. For example, there's just no guarantee that the following orgs are the same org...
The Society for Back...
--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)

August 23, 2010 at 9:48 pm

#1210772
RE: Linking to the Previous Row

niyinks (8/23/2010)
ItemID OldPrice RangePrice ...
--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)

August 23, 2010 at 9:39 pm

#1210770
RE: Finding Unique Non-Repeating Random Numbers

Brandie Tarvin (8/23/2010)
jcrawf02 (8/23/2010)
Brandie Tarvin (8/23/2010)
I had no idea what that comment was supposed to mean. Since you replied, maybe you can explain it to me? @=)
Related to the PS...
--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)

August 23, 2010 at 9:34 pm

#1210768
RE: Disk configuration for TempDB

Nadrek (8/23/2010)
One other trick is to put TempDB on, say, a pair of local SSD's in RAID1; keep it off the SAN.
Given the price per SAN spindle, 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)

August 23, 2010 at 9:30 pm

#1210767
RE: Dates from Calendar control

Riskworks (8/23/2010)
and c.rd between @start and dateadd(hh,-1,dateadd(dd,1,@end))
Gosh... that seems like "Death by SQL" because you're actually missing a whole hour in the day. Try this, instead...
and c.rd >=...
--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)

August 23, 2010 at 9:14 pm

#1210765
RE: Data Type and Length

paul.knibbs (8/23/2010)
There is sometimes a HUGE performance penalty (2:1) to be paid for using VARCHAR(MAX) depending, of course, on what you're doing. Correct sizing is always important. I'd...
--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)

August 23, 2010 at 9:09 pm

#1210763

Viewing 15 posts - 37,141 through 37,155 (of 59,098 total)