Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,686 through 47,700 (of 59,095 total)

RE: What is cursor's utility

deba_20032004 (10/18/2008)
Dear Sir,
I need a help regarding the aboved subjec. I can't clear my self after reading a sql server book.
Please help me regarding the above subject. what is 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)

October 18, 2008 at 10:59 am

#886779
RE: Extreme long UPDATE action, advice needed.

FreeHansje (10/18/2008)
Tnx for answering all.
I will try the suggestions given here.
The number of records having woonplaats IS NULL is exactly the number of records in the table T2: almost...
--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)

October 18, 2008 at 10:09 am

#886776
RE: Extreme long UPDATE action, advice needed.

Heh... not difficult to imagine at all if there are a dozen indexes on the table and no maintenance has been done either on the indexes or the statistics. 😉
--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)

October 18, 2008 at 10:07 am

#886774
RE: Cannot insert duplicate key row in object 'sysmergeschemachange' with unique index 'schemachangeversion'.

It's not the change from SQL Server 7 to 2000 that did it. It's the fact that you had to do a new snapshot to make it work in...
--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)

October 18, 2008 at 9:35 am

#886771
RE: What is difference between Inline Table-values Function and Multi-statement Table-vlued Function

Pravin Patel (10/18/2008)
Thanks for the valueable reply.
My requirement is to call this function approximately 2000 times in a hour from front end system, will it serve purpose, or still 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)

October 18, 2008 at 9:31 am

#886770
RE: Which Table-Values function is better?

Heh... it depends... what does the function do? And, why does it have to be a function?
--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)

October 17, 2008 at 11:40 pm

#886734
RE: Variable #of arguments to UDF/stored procedure

Article about how to pass 1, 2, and 3 dimensional arrays...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

October 17, 2008 at 10:37 pm

#886731
RE: Clustered index seek is ver very slow

arctica82 (10/17/2008)
But it is running very slow.Previously this Query was running very fast
Do you do any database maintenance? Like defragging or rebuilding indexes and statistics?
--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)

October 17, 2008 at 10:12 pm

#886729
RE: Pass array/csv into stored proc and doing LIKE statements

Sergiy is correct... and here's a link for a high speed and easy method to do just about any kind of single character delimiter split you might imagine...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

October 17, 2008 at 9:14 pm

#886721
RE: TRIM is driving me nut

Oh... and the thing about the BITMAPs is that it's bloody well impossible to copy'n'paste code from them. And, it's actually more difficult for you to make the bit...
--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)

October 17, 2008 at 9:12 pm

#886720
RE: TRIM is driving me nut

halifaxdal (10/17/2008)
Jack Corbett (10/17/2008)
According to http://ascii-table.com/ascii-extended-pc-list.php 160 is "á - latin small letter a with acute"
I know it's á, I just don't know why/how it is padded into my...
--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)

October 17, 2008 at 9:09 pm

#886719
RE: Query Analyzer sends 'Results to File'

Did you, by any chance, have the file you create with the @ECHO command open in a word processor or NotePad when you tried to run the BCP command?
--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)

October 17, 2008 at 8:25 pm

#886718
RE: Computation for running Difference

clint_pow (10/16/2008)
Jeff,
This is the link dont remember if this is the one http://articles.techrepublic.com.com/5100-10878_11-6158593.html.
I guess you didn't read the article I directed you to which says the method in 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)

October 16, 2008 at 8:35 pm

#886179
RE: Help needed filling in values based on previous row

bhovious (10/16/2008)
Hey Jeff, are you going to post your analysis here?
Absolutely!
--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)

October 16, 2008 at 8:12 pm

#886177
RE: Computation for running Difference

Hmmm... do you have a link to that article? I'd like to take a peek at what they're trying to do.
On your problem, I'm not sure what 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)

October 16, 2008 at 8:10 pm

#886176

Viewing 15 posts - 47,686 through 47,700 (of 59,095 total)