Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,156 through 49,170 (of 59,099 total)

RE: How to upload 2mb file in text column

So, use something better like Bulk Insert.
--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 19, 2008 at 6:12 pm

#845364
RE: There is insufficient system memory to run this query - system.web

What are you trying to do with the CLR?
--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 19, 2008 at 6:05 pm

#845363
RE: nvarchar concatenation with 'foo' or N'bar'

Ya beat me to it, Chris. 🙂
--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 19, 2008 at 6:04 pm

#845362
RE: doubt

jayrsangani (7/18/2008)
i need this for text columns not for aggregates
thanx for the reply
Heh... trust me... with a little help from ROW_NUMBER(), aggregates are the way to go for this...
--===== Create...
--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 19, 2008 at 5:44 pm

#845361
RE: Things You Didn't Know About Temp Tables and Table Variables

By the way... Folks, say hi to Adam Mechanic... he's the guy that first introduced me to the idea of what I currently call a Tally table.
Thanks again for 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)

July 18, 2008 at 8:46 pm

#845307
RE: Things You Didn't Know About Temp Tables and Table Variables

Adam Machanic (7/18/2008)
Jeff Moden (7/18/2008)
Viswanath S. Dhara (7/18/2008)
I am trying to update a table using a correlated subquery.
Why? Correlated subqueries are a form of RBAR and can...
--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 18, 2008 at 7:44 pm

#845305
RE: Need to remove duplicate records and get distinct values

d_sysuk (7/16/2008)
Okay so the posters had part I published several times, with various answers... using min/max, a subquery, a temp-table.
The perfm. analysis can be made easily by Sam/others just run...
--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 18, 2008 at 5:38 pm

#845300
RE: Things You Didn't Know About Temp Tables and Table Variables

Thanks Christian...heh... yeah, I was just wondering if the OP understood that. Very strange sample code to begin with...
--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 18, 2008 at 5:27 pm

#845299
RE: ISQL/W

Vivien Xing (7/18/2008)
isql/w is something like this:
http://www.imranweb.com/freesoft/
"For more information on Enhanced ISQL/w, read this document. "
isql/w != isqlw
Aghhh... My apologies... you are correct. Could even see the slash for...
--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 18, 2008 at 5:23 pm

#845298
RE: Soft Skills

Steve Jones - Editor (7/18/2008)
I think Grant and Jeff must be related to Dwight Shroot. Sorry you guys lost your privileges to bring nunchakus and stars into the office.
Heh... who...
--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 18, 2008 at 4:45 pm

#845294
RE: Soft Skills

Grant Fritchey (7/18/2008)
Jeff, how do I get a bat?
Easy... use soft skills to get the managers to buy you one! 😛
I find it difficult to use soft skills when someone...
--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 18, 2008 at 9:19 am

#845130
RE: Soft Skills

Shaun McGuile (7/18/2008)
Sock with a roll of quaters - cos people are scared of change 😀
Now THAT's FUNNY! 😀
--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 18, 2008 at 8:47 am

#845110
RE: Things You Didn't Know About Temp Tables and Table Variables

Viswanath S. Dhara (7/18/2008)
I am trying to update a table using a correlated subquery.
Why? Correlated subqueries are a form of RBAR and can actually be worse than...
--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 18, 2008 at 8:21 am

#845086
RE: Soft Skills

Shaun McGuile (7/18/2008)
GSquared: Scientology?!?
What does that mean? Cruise and Travolta come over and talk at you? 😀
No the only truth is the "Theory of Constraints" - TOC.
And yes I'm like...
--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 18, 2008 at 8:13 am

#845073
RE: Need to remove duplicate records and get distinct values

karthikeyan (7/17/2008)
I have executed all these three methods more than 10 times, But i got the same result at all time.
1) update #t1
set #t1.Name = T.Name
from T , #t1
where #t1.ID...
--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 18, 2008 at 8:03 am

#845059

Viewing 15 posts - 49,156 through 49,170 (of 59,099 total)