Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,736 through 48,750 (of 59,093 total)

RE: Beginner Question about CLR

So far, the only place I've seen CLR's beat T-SQL is in the area of RegEx Replace...
--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)

August 17, 2008 at 6:10 pm

#859206
RE: Risk Of Enabling CLR

Denby (7/21/2008)
Also, is the anything i should be monitoring from a DBA's perpective if feature is enable.
Absolutely! First, I'd make bloody sure that the source code was in 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)

August 17, 2008 at 6:09 pm

#859205
RE: IdentityColumn is Duplicated ?

dolly (7/30/2008)
In my web based application Identity column is duplicated when simultaneously record are inserted by different machine
(i think so) i will solution for handling...
--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)

August 17, 2008 at 6:01 pm

#859204
RE: XML

Without a whole lot more information ;), my answer would be... change it so it doesn't do that anymore. 🙂
You might want to conscribe any XML to the VARCHAR(MAX)...
--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)

August 17, 2008 at 5:16 pm

#859201
RE: How to use stored procedure instead of cursors?

It's a paradigm shift... with Cursors, you think "rows"... with setbased programming, you must learn to think "columns"... as in "What do I need to do to this column 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)

August 17, 2008 at 5:12 pm

#859200
RE: Debugger For SQL

Lemme get this straight, Carl... you think it's better for the app to write and pass data in the forum of Unioned SELECT statements than to pass a comma seperated...
--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)

August 17, 2008 at 5:04 pm

#859199
RE: Recommendations on LinkedIn

I'm thinking it could help employers notice me if they see who I've had forum discussions with.
Heh... WHICH forum discussions would you be talking about? You have precisely 1...
--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)

August 17, 2008 at 4:20 pm

#859197
RE: Can't install sql server 2005:(

Which edition of SQL Server 2005 are you trying to install?
--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)

August 17, 2008 at 4:12 pm

#859196
RE: Need query in SQL server 2000

Venkatesan Prabu (8/17/2008)
create table FirstTable(Attrib1 varchar(10), Attrib2 varchar(10),Attrib3 varchar(10))
insert into FirstTable values('Doc1','Attrib1','val1')
insert into FirstTable values('Doc2','Attrib2','val2')
insert into FirstTable values('Doc3','Attrib3','val3')
insert into FirstTable values('Doc4','Attrib4','val4')
select * from FirstTable
create table SecondTable(Attrib2 varchar(10),Attrib22 varchar(10))
insert into SecondTable...
--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)

August 17, 2008 at 3:49 pm

#859195
RE: Need query in SQL server 2000

GilaMonster (8/17/2008)
SQL 2000-related questions should rather be posted in the SQL 2000 forums in future please.
FirstTable has 1 lakh record , Second table has 2 Lakh record and Third...
--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)

August 17, 2008 at 3:35 pm

#859194
RE: Difference between SQL Server Standard edition - OEM version , retail and Promo version

Please post the link where you found the pricing so we can figure out what you mean by the "OEM" version because, to the best of my knowledge, nothing is...
--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)

August 17, 2008 at 3:33 pm

#859193
RE: update query append number in start of all rows

masood24 (8/17/2008)
hello dear 1st thank you very much for help but I have tried the query but it is not working message is successful with 1 row changed but actually...
--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)

August 17, 2008 at 3:27 pm

#859192
RE: Loading text file to SQL Server 2005 using bulk insert

Heh... that's known as a "Headerless Ragged Right" file and they're a bugger to import correctly. BCP and BULK insert require that all the rows have the same 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)

August 16, 2008 at 8:47 pm

#859149
RE: setting the recovery model

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)

August 16, 2008 at 8:01 pm

#859144
RE: Query Question

Jeffrey Williams (8/16/2008)
Oops - forgot the temp table, thanks Jeff.
No problem... it's the beauty of a forum... world's biggest team. 😉
--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)

August 16, 2008 at 8:00 pm

#859143

Viewing 15 posts - 48,736 through 48,750 (of 59,093 total)