Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,106 through 42,120 (of 59,067 total)

RE: Removing Carriage Returns

vicky (9/2/2009)
Hi
Try this
Update tablename set columnname = replace(replace(substring(columnname,1,datalength(columnname)), char(13),''), char(10), ' ')
REPLACE doesn't work on the TEXT datatype, folks.
--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)

September 2, 2009 at 10:00 am

#1048269
RE: Removing Carriage Returns

rudy komacsar (9/1/2009)
oops ... did in in 2005 - well varchar(8192) will work - then one has to walk through the text ...
Heh... maybe VARCHAR(8000) or SQL_Variant (fixed at 8016)....
--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)

September 2, 2009 at 9:59 am

#1048266
RE: How To Get Table Row Counts Quickly And Painlessly

jvrakesh (9/2/2009)
I ran count(*) and got the count as 1048912 and when I ran sp_spaceused I get 1048613 , the count doesnt match . Any Comments?
Yes......
--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)

September 2, 2009 at 9:53 am

#1048264
RE: How To Get Table Row Counts Quickly And Painlessly

In order for the rowcounts found in sysIndexes in SQL Server 2000 to be anywhere close to accurate, you need to use DBCC UPDATEUSAGE on the table you're trying 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)

September 2, 2009 at 12:23 am

#1047950
RE: Slow select after update of records

cconnors (9/1/2009)
was the updates done on columns that are index? you did not mention if you ran update stats after the update.
That won't matter if it's the clustered index.
--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)

September 1, 2009 at 2:01 pm

#1047798
RE: WORD UP!

Steve Jones - Editor (8/31/2009)
Yep, dropped SS2K8 Dev on my desktop. Needs SP1 (for SQL)
Heh... Thanks but I know it works with that... My problem is that I support 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 31, 2009 at 6:03 pm

#1047245
RE: WORD UP!

mbricker (8/31/2009)
You do not (per chance) also have Office 2003 installed do you. I know there are issues starting up some of the programs if you do - specifically Word.
Thanks...
--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 31, 2009 at 5:59 pm

#1047243
RE: Are the posted questions getting worse?

CirquedeSQLeil (8/31/2009)
Corporate policy may decree it, but there should be some controls in place allowing end-users a little freedom to finish up the current task. It doesn't help 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)

August 31, 2009 at 5:23 pm

#1047231
RE: Record Length

gboyer,
Since you're brand new to the forum, you might want to take a look at the article at the following URL...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you follow those steps (yep... it takes just 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 31, 2009 at 5:17 pm

#1047230
RE: Are the posted questions getting worse?

Jan Van der Eecken (8/31/2009)
Why didn't anyone tell him that "since he has the email address, which is unique worldwide at any time" he should just use that?
Because, they 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)

August 31, 2009 at 5:10 pm

#1047229
RE: What Data Should You Protect?

Steve Jones - Editor (8/31/2009)
Hey, I came up first on Snitch! That doesn't happen often. Usually Steve Jones starts with the muscian, golfer, professor or basketball player.
Heh... Celko's picture came...
--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 31, 2009 at 12:23 pm

#1047038
RE: Are the posted questions getting worse?

Lynn Pettis (8/31/2009)
Jeff Moden (8/31/2009)
Bob Hovious (8/31/2009)
Is it just me, or has his grammar improved?
Heh... careful... there's two folks with the exact same handle on this forum. If he's...
--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 31, 2009 at 11:59 am

#1047023
RE: WORD UP!

Does SQL Server 2000 DevEd work on Win7?
--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 31, 2009 at 11:55 am

#1047022
RE: Twenty tips to write a good stored procedure

jacroberts (8/25/2009)
10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE...
--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 31, 2009 at 10:54 am

#1046985
RE: Are the posted questions getting worse?

Bob Hovious (8/31/2009)
Is it just me, or has his grammar improved?
Heh... careful... there's two folks with the exact same handle on this forum. If he's not touting the "Sr...
--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 31, 2009 at 10:51 am

#1046982

Viewing 15 posts - 42,106 through 42,120 (of 59,067 total)