Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,441 through 37,455 (of 59,072 total)

RE: Deterministic UDF slower than Non-Deterministic?

Can't help in the CLR area but if you demonstrate the string manipulation you're trying to do in a CLR, I can try to beat it in T-SQL. I've...
--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)

July 29, 2010 at 11:07 pm

#1200123
RE: CrossTab or Pivot

You need some tools for that. Fortunately, you can find them all in one place. Please see the following link...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

July 29, 2010 at 11:04 pm

#1200122
RE: Toubles With User defined split function and while loop

tmlawlo (7/29/2010)
Thank you both very much! Last night i got it to work with the loop, but like you said it was much much slower. This worked perfectly. I...
--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)

July 29, 2010 at 10:43 pm

#1200116
RE: Sum Daily Data Into Weekly Data

Novicejatt (7/26/2010)
Hi
This is how my Table Looks like with 3 weeks of data on daily basis for two CP Codes:
I have data for 30 such Codes.
CP CodeDateTotal Pageviews
510142010-06-272623221
510142010-06-281985718
510142010-06-291815712
510142010-06-302126104
510142010-07-011702672
510142010-07-021666468
510142010-07-032019123
510142010-07-041783373
510142010-07-051890672
510142010-07-062424314
510142010-07-072197743
510142010-07-082097884
510142010-07-092029226
510142010-07-101989296
510142010-07-111833109
510142010-07-122398424
510142010-07-132365550
510142010-07-141810926
510142010-07-152483211
510142010-07-162327007
510142010-07-171758154
530372010-06-276059
530372010-06-286310
530372010-06-296394
530372010-06-304627
530372010-07-013402
530372010-07-023115
530372010-07-033032
530372010-07-042995
530372010-07-053122
530372010-07-073040
530372010-07-083638
530372010-07-093767
530372010-07-103745
530372010-07-113576
530372010-07-123860
530372010-07-133123
530372010-07-143458
530372010-07-153516
530372010-07-163233
530372010-07-173176
After converting 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)

July 29, 2010 at 10:38 pm

#1200114
RE: how to update millions of records quickly........

Bhuvnesh (7/28/2010)
Jeff Moden (7/28/2010)
you'd need a loop for that.
or may be batch approach can make work smoother
The loop would control "batches". That being said, what do you mean...
--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)

July 29, 2010 at 10:29 pm

#1200113
RE: Are the posted questions getting worse?

Lynn Pettis (7/28/2010)
[ Bragging Rights = ON ]
Many of you know that my daughter Kassondra enlisted in the Army last year. She enrolled in an on-line college to begin...
--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)

July 29, 2010 at 10:07 pm

#1200111
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

ta.bu.shi.da.yu (7/29/2010)
Jeff, I'm also interested, but before I even start looking I'm getting up to speed on set theory. In particular, understanding cartesian products, relations, functions, function composition, function limitations,...
--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)

July 29, 2010 at 8:32 pm

#1200102
RE: Using Ranking Functions to Deduplicate Data

PravB4u (7/29/2010)
Hi,
I think we can achieve the same without rank function.
SELECT * FROM GetMissingItems WHERE RowNumber = 1
Ummm.... Not without the "Partition By" part of the OVER clause for ROW_NUMBER...
--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)

July 29, 2010 at 7:27 am

#1199785
RE: sql script assistance

BaldingLoopMan (7/28/2010)
sorry, didnt realize u had question.,
I dont recall what it was for. i think i was generating a file and the end user consuming this file wanted the categories...
--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)

July 29, 2010 at 7:23 am

#1199780
RE: Cursor Output

Paul White NZ (7/29/2010)
There is a (very nasty) one-step global cursor + dynamic sql workaround, which Jeff is just going to love:
Heh... I AM curious why you'd show someone how...
--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)

July 29, 2010 at 7:16 am

#1199772
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

I've heard such things of Date which is surprising since Codd and Date were business partners at one time (IIRC). I'll have to take a look at 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)

July 29, 2010 at 7:07 am

#1199762
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

mirzafahad1409 (7/29/2010)
Hi every1, i am extremely new to SQL.Can any1 show an example using a column instead of @parameter.
for the fetching of data between the commas.???(spliting the data).
email me plzz...
--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)

July 29, 2010 at 6:37 am

#1199738
RE: SQL server scans table even if TOP 1 * is used?

Yeah... but you have two different tables here. Which table is the index actually on?
If you want help with a performance problem, you might want to take a look...
--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)

July 28, 2010 at 11:30 pm

#1199609
RE: Is there any way to find it out or extract the original unicode character

If it's been converted to a VARCHAR or CHAR, then no.
--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)

July 28, 2010 at 11:24 pm

#1199606
RE: Feedback for IT

So how could you let IT know? You could call customer service, but I have a hard time thinking that a low-wage CS person would pass this along to 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)

July 28, 2010 at 11:16 pm

#1199603

Viewing 15 posts - 37,441 through 37,455 (of 59,072 total)