Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,781 through 48,795 (of 59,099 total)

RE: Wax off... wax on...

Oh yeah... almost forgot... the reason why I don't do the copy, delete, and rename thingy is because I don't know if it'll break replication or any of the associated...
--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)

August 14, 2008 at 2:49 pm

#858418
RE: Wax off... wax on...

rbarryyoung (8/14/2008)
OK, there are several places that you can do this from, but the best place is: "Replication Monitor/Agents/Log Reader Agent" which will all of the LogReaders and only 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)

August 14, 2008 at 2:47 pm

#858416
RE: Wax off... wax on...

GilaMonster (8/14/2008)
Having fun as an administrator today?
Oh hell no! 🙂 I'm not a "systems" type of DBA and I've never used replication before. I'm one of them...
--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)

August 14, 2008 at 2:38 pm

#858408
RE: Wax off... wax on...

Ok... thanks Gail. And, heh... thanks for not killing the OP for his ignorance in this area. 🙂
--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)

August 14, 2008 at 2:25 pm

#858400
RE: Wax off... wax on...

Aw crap! They've scheduled a job for every blood Log Reader Agent!!! I'm going to need to disable those buggers, too, 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)

August 14, 2008 at 2:08 pm

#858382
RE: Wax off... wax on...

GilaMonster (8/14/2008)
Jeff Moden (8/14/2008)
Oh dear... I think I've found what you're talking about... it's in EM under {Replication Monitor}{Agents}{Log Reader Agents}... they've really really overdone it... there are 70 of...
--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)

August 14, 2008 at 2:04 pm

#858375
RE: Wax off... wax on...

Oh dear... I think I've found what you're talking about... it's in EM under {Replication Monitor}{Agents}{Log Reader Agents}... they've really really overdone it... there are 70 of the blighters... :blink:
--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)

August 14, 2008 at 1:49 pm

#858358
RE: Wax off... wax on...

rbarryyoung (8/14/2008)
If it is Transactional Replication, then you (Stop & Disable) the LogReader job (from the Replication Interface, not the SQL Agent). This is the job that scrapes 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)

August 14, 2008 at 1:43 pm

#858346
RE: Is it possible to turn off replication?

Matt Klein (7/30/2008)
Thank you - actually I found (from the vendor notes) a reference to linked servers, which led me back, eventually, to the replication area where right-clicking I saw...
--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)

August 14, 2008 at 1:31 pm

#858337
RE: My 3rd party softwares uses tons of cursors.

Hehe. I always seem to pop by just when there's a throwdown about to go down....
All right all right. If you're going to challenge to a dual, 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)

August 13, 2008 at 11:41 pm

#857834
RE: Replace non numeric characters in string

What do you get for the following value?
'XA1 1AA'
--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)

August 13, 2008 at 10:52 pm

#857827
RE: SQL Year and Week numbers

Since Day "0" was a Monday, I believe you'll find that the code I made also compensates for Monday. 🙂
--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)

August 13, 2008 at 9:57 pm

#857821
RE: My 3rd party softwares uses tons of cursors.

andrew gothard (8/13/2008)
But, there's even a way around that (and many similar problems not listed) without an explicit cursor or While loop OR UDF using a single set-based update...
--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)

August 13, 2008 at 9:39 pm

#857820
RE: Replace non numeric characters in string

David Jackson (8/13/2008)
Peso
many, many thanks. I owe you a beer. 😀
declare @TestTab Table (add1 varchar(50) null, postcode varchar(50) null)
Insert @TestTab values('Glossop', 'SK13 8LY') --Valid
Insert @TestTab values('M1 1AA',NULL) --Valid but wrong...
--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)

August 13, 2008 at 9:04 pm

#857816
RE: SQL Bulk Insert - using " to wrap text fields

I need to see a couple of lines of what you expect the output to be and the CREATE statement for the source 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)

August 13, 2008 at 6:01 pm

#857796

Viewing 15 posts - 48,781 through 48,795 (of 59,099 total)