Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,796 through 36,810 (of 59,072 total)

RE: Replacing substring with a substring

rabisco (9/15/2010)
I have resolved this with the following statement
update bodyTextTable
set bodyText = cast(replace(cast(bodyText as nvarchar(max)),'/themes/old/', '/themes/new/') as ntext)
I had to cast ntext to nvarchar and cast it back to ntext...
--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 15, 2010 at 6:15 pm

#1221809
RE: Dynamic Quer in UDF

Heh... yeah... I know all the "reasons" people and MS give. I still think it's a little bit odd that I can execute dynamic SQL in a stored procedure...
--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 15, 2010 at 6:06 pm

#1221805
RE: Finding the two highest values for a criteria

Jeff Moden (9/15/2010)
FelixG (9/15/2010)
Let's assume that I have the following table tables:
Orders (orderdate, ordernumber, productcode)
- ordernumber is an identity column
I need to get the two highest values...
--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 15, 2010 at 5:49 pm

#1221797
RE: OK This is a weird one

jeff.mason (9/15/2010)
Yeah, I know, I feel stupid too. What can I say, it was 11:30 PM, we are tired, and stuck in a rut for troubleshooting. We attacked...
--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 15, 2010 at 5:46 pm

#1221796
RE: VARCHAR(MAX) and limitations

Sorry... I'd started to respond before your second post. Ships passing in the night, as it were...
--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 15, 2010 at 5:39 pm

#1221793
RE: VARCHAR(MAX) and limitations

Correct me if I'm wrong,please, but I don't see anything that pops over 8K 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)

September 15, 2010 at 5:26 pm

#1221790
RE: Advice on importing multiple txt files with different file structures

jcrawf02 (9/15/2010)
Cross-posted from The Thread:
Looking for advice on the best way to import multiple fixed-width txt files (50+) with different file structures into SQL Server (separate table for each...
--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 15, 2010 at 5:19 pm

#1221789
RE: Alternatives for nested cursors

brian_winzeler (9/15/2010)
Ahh that fixed it. My whole point was to be pointed in the right direction (which this most certainly did!). I will definitely keep that in mind for future...
--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 15, 2010 at 2:06 pm

#1221668
RE: Finding the two highest values for a criteria

FelixG (9/15/2010)
Let's assume that I have the following table tables:
Orders (orderdate, ordernumber, productcode)
- ordernumber is an identity column
I need to get the two highest values (orderdate and...
--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 15, 2010 at 2:01 pm

#1221665
RE: OK This is a weird one

jeff.mason (9/15/2010)
He's in training today so I have to wait. Actually I will be happy to get him to buy lunch or something....
I strongly recommend pork chops for lunch....
--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 15, 2010 at 1:55 pm

#1221658
RE: increment string in vchar column

scott.pletcher (9/15/2010)
Do both CTEs in the same statement with the UPDATE; you can have more than one CTE in a statement. That way it will all implicitly be 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)

September 15, 2010 at 1:52 pm

#1221655
RE: Very slow query with only 2 joins

frharkonnen (9/13/2010)
That query takes 16 seconds for 921954 lines returned
Returned to WHERE???? Find ANY table with almost a million lines in it and see how long it takes 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 15, 2010 at 9:25 am

#1221448
RE: To get a DBA Job

Ali Tailor (9/15/2010)
Hi All
I'm a MCTS SQL server 2008,on 10th sept 2010, Having 5 + years working experience in IT as 'Software Support Engineer' my Job involve Software (my company'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)

September 15, 2010 at 9:21 am

#1221437
RE: Blocking on tempdb system tables

Derrick Smith (9/15/2010)
Jeff Moden (9/14/2010)
Derrick Smith (9/14/2010)
It's the combination of that and creating it in a transaction thats causing the issue here. SQL needs to keep the lock on those...
--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 15, 2010 at 9:17 am

#1221428
RE: How to handle non-DBA or non-IT Boss

Reo (9/15/2010)
Hi All,
I would like to know how to handle a non-DBA Boss or non-IT Boss
Thanks
Like any other boss...
They're in charge.
Since they don't know about IT stuff, YOU will need...
--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 15, 2010 at 9:11 am

#1221418

Viewing 15 posts - 36,796 through 36,810 (of 59,072 total)