Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,336 through 40,350 (of 59,072 total)

RE: Remove Duplicates in Data grid using Stored procedure

The devil's in the data. Please read and heed the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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:27 pm

#1100029
RE: Performance issue on a udf - Better way to rewrite?

Ya beat me to it on the POWER thing. Nicely done, Lynn.
--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:25 pm

#1100028
RE: A New Beginning

real_cals (1/6/2010)
SSRS is probably the at the top of the list. We have only recently moved to 2008, so there are a bunch of new things...but that seems to be...
--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:21 pm

#1100026
RE: Tally Table

The Tally table is not a panacea and isn't good for this. Dynamic SQL would be good for this. So would an (ugh!) cursor.
--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:20 pm

#1100025
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

Viewing 15 posts - 40,336 through 40,350 (of 59,072 total)