Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,806 through 47,820 (of 59,095 total)

RE: Moving replicated "servers"

Micheal, Noeld... thank you very much for the help. You guys are the best. 🙂 I'll let you know how it all turns out if they actually follow...
--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 10, 2008 at 1:58 pm

#883625
RE: Moving replicated "servers"

Michael Earl (10/10/2008)
My suggestion is to stop the services on the original servers, copy the databases (including the system databases) to the new servers, and start the services on 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)

October 10, 2008 at 1:33 pm

#883619
RE: Moving replicated "servers"

noeld (10/10/2008)
or cook your own scripts to do it.
Cool... I can do that. Thanks for the heads up on that.
--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 10, 2008 at 1:17 pm

#883615
RE: Moving replicated "servers"

noeld (10/10/2008)
I would do it this way:
1. Take a full backup of each DB, Compress it and start log shipping it. You can d that "NOW".
2. After you are...
--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 10, 2008 at 11:12 am

#883562
RE: Moving replicated "servers"

Michael Earl (10/10/2008)
The servers are physically different, but can you convince them to retain the original server names and IP addresses?
If so, keep everything simple. Stop the services on...
--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 10, 2008 at 10:59 am

#883555
RE: Moving replicated "servers"

My apologies... I forgot to say that they're all SQL Server 2000 Enterprise Edition servers which also means that I just posted to the wrong bloody forum... :blush: I don'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)

October 10, 2008 at 8:45 am

#883462
RE: Creating Functions for Stored Procedures

jcrawf02 (10/10/2008)
Just curious, if you are working in an environment where DBA's DON'T know not to use sp_, is there another way to filter out the system procs and keep...
--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 10, 2008 at 6:20 am

#883367
RE: Delete Duplicate values

Just to give physical representation of Kenny's suggestions...
--===== Create a temporary demonstration table and populate it with duplicated info
-- This is not part of 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)

October 10, 2008 at 5:54 am

#883358
RE: Job processing all views in DB

Thanks for the feedback, Michal. Heh.. No... no searches for the word "cursor" or "while"... that would easily become a full time job on this forum alone. 🙂
--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 10, 2008 at 5:13 am

#883351
RE: Suggest me on tables

jacob sebastian (10/10/2008)
Look for the following in BOL
DBCC INDEXDEFRAG
DBCC DBREINDEX
One more... DBCC SHOWCONTIG. It produces a report on whether the index(s) on a table actually need to be defragged....
--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 10, 2008 at 5:09 am

#883347
RE: 'N' number of usage - Tally Table

Chris Morris (10/10/2008)
Hi chaps, this might sound a little blasphemous, but have you tried Visual Foxpro for importing the data? I worked with the product extensively in the 90's (MCP...
--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 10, 2008 at 5:04 am

#883343
RE: 'N' number of usage - Tally Table

Sergiy (10/9/2008)
One day some developer will read a conversation like this and decide it's good to use "thorn" character as a replacement for CR/LF.
He/she will agree it with other side...
--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 10, 2008 at 5:00 am

#883341
RE: Job processing all views in DB

Heh... I agree with that, Seth... that's why I'll always print it out and try a couple of pieces first, just to be sure. Thanks for the feedback.
--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 9, 2008 at 11:30 pm

#883261
RE: Passing array To Stored Procedure

Thanks for the feedback, Richard. 🙂
--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 9, 2008 at 11:28 pm

#883259
RE: Did you buy SQL Server for home use?

If you have the DVD version of MSDN, you probably already have the Developer's Edition just waiting for you on one of those disks.
--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 9, 2008 at 11:24 pm

#883258

Viewing 15 posts - 47,806 through 47,820 (of 59,095 total)