Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,366 through 40,380 (of 59,098 total)

RE: CASE, WHEN, THEN!

ToddJames (1/6/2010)
What am I doing wrong? Grr.
select *,mycolumn=
CASE
WHEN mycolumn= 'PSI' THEN mbrproductcode
WHEN mycolumn= 'PPO' THEN 10001912
WHEN mycolumn= 'PP1' THEN 10001910
WHEN mycolumn= 'NOT'...
--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 6, 2010 at 11:17 pm

#1100024
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

If you really are using 2k5, then NVARCHAR(MAX) will give you up to a billion characters. And MAX is not a number... NVARCHAR(MAX) with the word MAX is 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)

January 6, 2010 at 11:15 pm

#1100023
RE: Create one record for each in quotient

Nice, fast, little numbers table... Nice job, Arun.
--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 6, 2010 at 11:13 pm

#1100022
RE: TSQL SELECT and TABLOCK

I have to admit, Jason... you've confused even me on this one 😛 The query runs in about 13 ms according to the op... how will query tuning...
--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 6, 2010 at 9:52 pm

#1100012
RE: One big "ragged right" text file!

You say it has no delimiters... but does each row end with something like a carriage return or line feed?
--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 6, 2010 at 9:46 pm

#1100010
RE: Are the posted questions getting worse?

GSquared (1/6/2010)
GilaMonster (1/6/2010)
Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing that...
--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 6, 2010 at 9:01 am

#1099668
RE: Import Slow

Heh... probably the same as me... found something slightly interesting and didn't read the date... 😛
--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 5, 2010 at 5:52 pm

#1099324
RE: Normalize data using Pivot WITHOUT using Aggregate function

lmu92 (1/4/2010)
Thanx again, Jeff
Anytime, Lutz... thanks for the feedback.
--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 4, 2010 at 3:56 pm

#1098689
RE: Normalize data using Pivot WITHOUT using Aggregate function

The reason why it took so long is because, in the presence of a triangular join, it must spawn over 405,000,450,000 rows. To put it more succinctly, it spawned...
--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 4, 2010 at 9:24 am

#1098504
RE: Cummulative Totals By Dynamic Month Range

Step one would be to prove my conjecture on the problem wrong... print out the dynamic SQL using PRINT @SQL1+@SQL2+@SQL3 and copy the results (will be SQL) to another query...
--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 4, 2010 at 9:19 am

#1098500
RE: Cummulative Totals By Dynamic Month Range

tm3 (1/3/2010)
Jeff:
After further testing, I have found the following strange situation with the procedure edits you provided:
1) if I use a date range of start date: 10/03/2005 end...
--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 4, 2010 at 1:05 am

#1098298
RE: A New Beginning

Jeff Moden (1/2/2010)
I've been "talking" with one of the proprieters of a web site that claims...
I got an update on that today. It turns out they have 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)

January 3, 2010 at 5:45 pm

#1098265
RE: A New Beginning

David Portas (1/3/2010)
SQL is pretty poorly equipped for writing set-based queries. For example I would suggest that the "recursive CTE" syntax exists only because SQL never had any equivalent of...
--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 3, 2010 at 5:36 pm

#1098263
RE: Query on CTEs

lmu92 (1/1/2010)
Jeff Moden (1/1/2010)
... Also remember that the definition of high performance "Set Based" code should not be confused with "doing it all in a single query" which may...
--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 2, 2010 at 11:15 pm

#1098216
RE: Interview Question

venktsrinivas.gv (1/1/2010)
Pls refer any books with good authour
Already did that... see Books Online. As a side bar, step one on finding the answer to any interview question for DBA'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 2, 2010 at 11:12 pm

#1098215

Viewing 15 posts - 40,366 through 40,380 (of 59,098 total)