Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,991 through 46,005 (of 59,101 total)

RE: The T-SQL Quiz

How odd... here we're talking about portability between releases of SQL Server... the ANSI-only folks would have a ball with this. Of course, then I'd have to launch some...
--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 13, 2009 at 6:13 am

#925792
RE: The T-SQL Quiz

Grant Fritchey (1/13/2009)
Jack Corbett (1/12/2009)
Sergiy (5/28/2007)
If you don't specify the version that means it must work on EVERY version, not only the one you know.
Of course these means that CTE's...
--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 13, 2009 at 6:09 am

#925789
RE: Virtualization forum section

GilaMonster (1/12/2009)
That was about a week before he referred to me as a "clueless idiot" in a mail to my manager after I had requested RAID 10, dedicated disks for...
--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 12, 2009 at 1:28 pm

#925546
RE: Separate full name into diff fields

Steve Jones - Editor (1/12/2009)
You could grab the prefix like this
case
when substring( namefield, 1, charindex(' ', namefield) = 'Mr'
then prefix = 'Mr'
when substring( namefield, 1,...
--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 12, 2009 at 1:26 pm

#925541
RE: Where 1 = 1

GSquared (1/12/2009)
Agree with you on most points.
I like the Inner Join syntax. Makes it easier for me to read (not for you, but it does for me).
That would...
--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 12, 2009 at 1:14 pm

#925532
RE: Inserting a value in an ordered string

Sergei Ely (1/12/2009)
John,
The code worked perfectly. 😀 Thanks again.
Sergei
Heh... actually, it's "Jeff" but I appreciate the feedback anyway. Thanks, Sergei. 🙂
--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 12, 2009 at 12:48 pm

#925504
RE: One database per customer or One DB for all customers

On the other hand, Backups and Restores work very well for individual databases and also allows for a multi-server environment which has both it's own pains and advantages.
The bottom line...
--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 12, 2009 at 9:57 am

#925380
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

gvsriramakrishna (1/11/2009)
Oops.. there seems to be an error in th SQL query at the over keyword.
Incorrect syntax near the keyword 'OVER'.
No... I wanted to know how the UPDATE solution works....
--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 12, 2009 at 6:32 am

#925223
RE: highest unused ID

Grant Fritchey (1/11/2009)
Beating accepted. 😀
I just remember seeing the solution in his book. It's not something I played with a lot myself, mainly because I long stopped worrying about gaps...
--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 12, 2009 at 6:24 am

#925215
RE: highest unused ID

Hmmmm... is there a way for you to turn of the hyperthreading long enough to run another MAXDOP 1 test? I've got a feeling and would like to find...
--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 11, 2009 at 9:18 am

#924991
RE: Database running very slow

Was it ever fast? If so, what changed? If not, then it's probably 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)

January 10, 2009 at 11:46 pm

#924957
RE: Separate full name into diff fields

There are way too many variations of how a name may be entered to write some "simple" SQL for this. Instead of trying to reinvent the wheel, why don't...
--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 10, 2009 at 11:38 pm

#924956
RE: Don't Let the Economic Downturn Get You Down

majorbloodnock (1/8/2009)
He, he
I can just see the new posts being typed right now
"Dear SSC
Plz tell me what makes a good DBA and what else I need to know to become...
--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 10, 2009 at 11:35 pm

#924955
RE: One database per customer or One DB for all customers

Yogi Berra had a saying... "When you come to a fork in the road, take it!" In other words, given a choice, take all choices.
A partitioned table would work...
--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 10, 2009 at 11:26 pm

#924954
RE: to rename a file by attaching datestamp at the end of filename using SSIS File task

Heh... nah... I just hate GUI's... too limiting... can only do what they were designed to do using only the ways they were designed to do it... unless you write...
--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 10, 2009 at 11:02 pm

#924953

Viewing 15 posts - 45,991 through 46,005 (of 59,101 total)