Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,871 through 39,885 (of 59,072 total)

RE: Remove non printable characters

My apologies, Ramesh. I should have qualified my statement. Instead of saying...
"I believe you'll find it's a wee bit more difficult to do than just using 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)

February 6, 2010 at 11:47 am

#1115040
RE: DBCC Timewarp

The Dixie Flatline (2/5/2010)
Jeff, is that new in 2008, or would it work for 2005 as well?
If memory serves, parameter one is PI to 8k decimal places.
It was deprecated 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)

February 6, 2010 at 8:55 am

#1115013
RE: Converting data with apostrophes in it

Luke L (2/5/2010)
what I would do is create a stored procedure...
Heh... sorry Luke. I missed what you said above. Good to have a backup, though. 🙂
--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)

February 6, 2010 at 8:54 am

#1115012
RE: Table Variable Issue

The Dixie Flatline (2/5/2010)
You got me, Jeff. Me and table variables were just a summer thing, y'know. That said, any time someone has the ah-hah!...
--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)

February 6, 2010 at 8:52 am

#1115011
RE: limit of data in select stored procedure

I believe there might be a bit of a language barrier problem here... I believe the OP is saying that, yes, he has thousands of tables and millions of rows,...
--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)

February 6, 2010 at 8:39 am

#1115009
RE: TSQL Help - Calculate Months

Please see the following article... it has code to do nearly precisely what you want and will also zero fill any missing data. The best part is, you won't...
--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)

February 5, 2010 at 9:46 pm

#1114923
RE: Remove non printable characters

Grinja (2/5/2010)
That could work ... thanks for the suggestion!
Which unprintable characters? Just any character less than CHAR(32)???
--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)

February 5, 2010 at 9:32 pm

#1114920
RE: Remove non printable characters

Ramesh Saive (2/5/2010)
I don't think so there is any equivalent function in SQL Server. But you can create you own function using the existing REPLACE function.
Heh.. Let's see some...
--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)

February 5, 2010 at 9:31 pm

#1114919
RE: Speeding up a fast forward cursor proc

Don't even try to salvage the code. Sit down and write a new set of requirements for the code without thinking about how to code it. Then, sit...
--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)

February 5, 2010 at 9:28 pm

#1114918
RE: Dynamic Order by - is there any way to sort Dates correctly

lmu92 (2/4/2010)
Duplicate post.
Please continue discussion here.
I guess you guys kind of missed that one, huh? 😀
--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)

February 5, 2010 at 9:26 pm

#1114917
RE: Weird RTRIM applied when querying string columns, is there a setting for this?

Stefan Krzywicki (2/4/2010)
If you want to compare the strings and ensure trailing whitespace is taken into account, check the field with a REVERSE.
REVERSE will make the trailing whitespace into leading...
--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)

February 5, 2010 at 9:24 pm

#1114916
RE: sql script assistance

BaldingLoopMan (2/5/2010)
drop table #temp
create table #temp
(
offerid int
, Catg varchar(100)
)
insert into #temp( offerid, Catg )
select 1, 'health' union all
select 1, 'fitness' union all
select 1, 'weights' union all
select 2, 'personal' union...
--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)

February 5, 2010 at 9:22 pm

#1114915
RE: SQL Timeout

It sounds like the optimizer is using a cached plan which doesn't necessarily meet the needs of the criteria for the current query. If you're using a stored proc...
--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)

February 5, 2010 at 9:20 pm

#1114914
RE: Is sort order important in index?

David McKinney (2/5/2010)
Often I will put a descending sort order on a clustered index, so that when I do a select I generally see the latest rows inserted first (depending...
--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)

February 5, 2010 at 9:10 pm

#1114912
RE: Display values in row wise

WayneS (2/5/2010)
Does this do what you want?
select top 26 replicate(char( row_number() over (order by object_id)+64),3)
from sys.objects
Heh... I can't tell if they want a split function or what you...
--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)

February 5, 2010 at 9:06 pm

#1114911

Viewing 15 posts - 39,871 through 39,885 (of 59,072 total)