Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,701 through 47,715 (of 59,102 total)

RE: Pass array/csv into stored proc and doing LIKE statements

Sergiy is correct... and here's a link for a high speed and easy method to do just about any kind of single character delimiter split you might imagine...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

October 17, 2008 at 9:14 pm

#886721
RE: TRIM is driving me nut

Oh... and the thing about the BITMAPs is that it's bloody well impossible to copy'n'paste code from them. And, it's actually more difficult for you to make the bit...
--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)

October 17, 2008 at 9:12 pm

#886720
RE: TRIM is driving me nut

halifaxdal (10/17/2008)
Jack Corbett (10/17/2008)
According to http://ascii-table.com/ascii-extended-pc-list.php 160 is "á - latin small letter a with acute"
I know it's á, I just don't know why/how it is padded into my...
--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)

October 17, 2008 at 9:09 pm

#886719
RE: Query Analyzer sends 'Results to File'

Did you, by any chance, have the file you create with the @ECHO command open in a word processor or NotePad when you tried to run the BCP command?
--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)

October 17, 2008 at 8:25 pm

#886718
RE: Computation for running Difference

clint_pow (10/16/2008)
Jeff,
This is the link dont remember if this is the one http://articles.techrepublic.com.com/5100-10878_11-6158593.html.
I guess you didn't read the article I directed you to which says the method in the link...
--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)

October 16, 2008 at 8:35 pm

#886179
RE: Help needed filling in values based on previous row

bhovious (10/16/2008)
Hey Jeff, are you going to post your analysis here?
Absolutely!
--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)

October 16, 2008 at 8:12 pm

#886177
RE: Computation for running Difference

Hmmm... do you have a link to that article? I'd like to take a peek at what they're trying to do.
On your problem, I'm not sure what you mean....
--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)

October 16, 2008 at 8:10 pm

#886176
RE: Query Analyzer sends 'Results to File'

Thanks for the feedback, Seggerman.
--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)

October 16, 2008 at 7:56 pm

#886172
RE: Computation for running Difference

It's been a couple of days, Clint, and I'm just following up... are you all set on this?
--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)

October 16, 2008 at 7:49 pm

#886171
RE: Rebilding Indexes on a table with 100Million + rows

Extent Fragmentation is unreliable... read about it in the BOL listing for DBCC SHOWCONTIG.
The best thing to go for, IMHO, is a very high scan density (95+) and a low...
--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)

October 16, 2008 at 7:38 pm

#886169
RE: How to find a table existed or not?

krayknot (10/16/2008)
Use the script below
IF EXISTS (SELECT 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_NAME='tablename')
...
--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)

October 16, 2008 at 7:19 pm

#886165
RE: Where should the DBA Team exist?

I just keep reloading the ol' bucket of pork chops and I replace the bands in the sling shot every 500 shots or every week... whichever comes first. Right...
--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)

October 16, 2008 at 7:11 pm

#886163
RE: CPU 100% and critical

oraculum (10/16/2008)
here are the results from the two querys...
am wondering whether to restart sql agent....umm..
have also just noticed something has changed with my tempdb config (i have been off work...
--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)

October 16, 2008 at 7:07 pm

#886162
RE: How to.....

Fraggle (10/16/2008)
So funny story. The very next day, I was offered a position as a SQL Server 2005 Developer/Analyst/Administrator. 45/45/10% work respectively. I figured it was 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)

October 16, 2008 at 6:58 pm

#886161
RE: Fill factors, index fragmentation and indexing strategy

Marios Philippopoulos (10/16/2008)
I think it's settled. I will ask the developer to create the non-cl. idxs with 60% fill factor.
Thanks for your help.
Based on the fact that you have now...
--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)

October 16, 2008 at 6:56 pm

#886160

Viewing 15 posts - 47,701 through 47,715 (of 59,102 total)