Jeff Moden

Forum Replies Created

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

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
RE: Fill factors, index fragmentation and indexing strategy

Marios Philippopoulos (10/16/2008)
Thank you both for your replies.
I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once, in 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:52 pm

#886159
RE: Cannot insert duplicate key row in object 'sysmergeschemachange' with unique index 'schemachangeversion'.

At this point, I agree... something is "dirty" in the data... my recommendation would be to delete the data at the subscriber and do a fresh snapshotl.
--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:49 pm

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

Garadin (10/15/2008)
While my subquery seems to fit all that criteria, I'm not sure that it's creating a triangular join in this case. The subquery method is blazingly fast, 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)

October 16, 2008 at 6:23 pm

#886154

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