Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,841 through 42,855 (of 59,098 total)

RE: Sort a string in a stored procedure: not order by

chandrika5 (7/22/2009)
Thanks Jeff. I l am learning something new: tally tables. For now, I prefer the simple ASCII add solution suggested by Weasley: I will not have ABBC ...
--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 22, 2009 at 10:37 am

#1028509
RE: Unexpected Growth in one DB

luckysql.kinda (7/22/2009)
Steve,
Does it mean that when we rebuild the index for large DB as 1000GB, we should make the recovery model = SIMPLE
-LK
That might break your backup chain 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)

July 22, 2009 at 10:21 am

#1028494
RE: Pulling Filename from Windows directory into table

tjm (7/22/2009)
Nope. Worked Great! Thanks for all your help!
Implemented and is already on production server. 😀
-tjm
Wow... you folks don't waste any time. Thanks 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 22, 2009 at 10:19 am

#1028489
RE: Pulling Filename from Windows directory into table

Again... as a reminder... sp_OA* procs tend to be quite slow at things like this. If it turns out to be too slow, post back and I'll throw 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)

July 22, 2009 at 8:28 am

#1028349
RE: Pulling Filename from Windows directory into table

tjm (7/22/2009)
Thank you. This looks interesting and I will implement into our development environment today and play around with it. When I copy your code, it pastes...
--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 22, 2009 at 8:26 am

#1028347
RE: CLR Fail to load

jqd2001 (7/21/2009)
There are a lot of business rules regarding output that are difficult to express in T-SQL.
Unless it has to do with effecient RegEx, I've not known that to be...
--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 22, 2009 at 6:26 am

#1028243
RE: SQL View

frecal (7/22/2009)
I am using it as one to many ..one parent can have multipe relationships.
the query only really will indicate that the record has a relationship with another record 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)

July 22, 2009 at 6:17 am

#1028238
RE: order by alphanumeric value

Thanks for the feedback... heh... wish I caught it before the first time I got burned by it. 😛
--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 22, 2009 at 6:09 am

#1028233
RE: split field into numbers and join to table

My humble apologies... looking back at this thread, I was wrong because I misread the intention. I allowed my fervor against having a CSV column in a table...
--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 22, 2009 at 6:05 am

#1028227
RE: Pulling Filename from Windows directory into table

The following method is a bit slow so far as I'm concerned, but it's also pretty safe. Let me know if you need something a whole lot faster 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 21, 2009 at 10:40 pm

#1028086
RE: CLR Fail to load

jqd2001 (7/21/2009)
Jeff,
The CLR Function, exec select statement, using datareader to iterate through, return result set in a table. The assembly marked SAFE.
Server is 64bit developer edition. We have 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)

July 21, 2009 at 10:07 pm

#1028082
RE: SQL View

frecal (7/20/2009)
I have been trying to work this out from some of the other requests but havnt had much luck so thought id post another one.
I have Name table 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 21, 2009 at 8:48 pm

#1028065
RE: Return Value = 0, should be newly inserted primary key

I've never used PowerShell but I'm interested in it... anyone got an idea on this problem? 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)

July 21, 2009 at 7:45 pm

#1028055
RE: Data getting deleted automatically

You might also want to make that trigger an "Instead of" trigger so that not only are you capturing the information you want to catch the culprit, you're also preventing...
--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 21, 2009 at 7:38 pm

#1028054
RE: order by alphanumeric value

Using code very similar to Dave's otherwise great example, try this...
create table #temp
(
Response varchar(500)
);

insert into #temp values(0)
insert into #temp values(1)
insert into #temp values(2)
insert into #temp values(10)
insert into #temp values(3)
insert into...
--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 21, 2009 at 7:32 pm

#1028053

Viewing 15 posts - 42,841 through 42,855 (of 59,098 total)