Jeff Moden

Forum Replies Created

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

RE: CLR TYPES AND SQL TYPES

MarlonRibunal (10/18/2008)
GilaMonster (10/18/2008)
The error message is fairly clear. The data types don't match. A VARCHAR(max) is not the same as a DirectoryInfo. What are you expecting to be passing to...
--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 5:46 pm

#886820
RE: What is cursor's utility

Debasis,
That seems to bring us right along with what I was talking about and back to your question about the "utility of cursors"... how WOULD you do a running total...
--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 5:41 pm

#886819
RE: What is cursor's utility

GilaMonster (10/18/2008)
The optimiser's pretty good with correlated subqueries these days. I was doing some tests for a presentation a month or so back, and I was looking for an example...
--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 5:30 pm

#886816
RE: Help Needed with TSQL

The problem with this whole thing is the original form of the data. It's in the same form as the report... it's "horizontal" and the column names represent time....
--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 3:21 pm

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

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