Help on linked server

Hi All,
I need your expertise comments for using linked server in WAN
environment. I need to suggest it to my client.
Here is the scenario:
My client is having 20 retail shops across US. He got a Central office
located in OHIO state.
All the stores are connected through WAN.
Now we are developing a transaction system for store's. All stores are
going to use MSDE.
One Enterprise SQL server is going to be installed in central office.
In this scenario will linked server work for distributing transaction
across stores?.
For example,
The gift card transaction happened in one store should be immediately
updated (or in frequent interval)
to central server. This enables other store to pickup the transaction
on need basis.
I used linked server in LAN environment and it works. But I could not
think of WAN environment.
What ports need to be opened for these SQL transaction?
What environement is required to enable linked server (including
security)?
How do I create an environment in my Office itself, so that I will be
confirtable on suggesting it or any other way to acheive the immediate
update and retrieval (other than replication).
Please help.
With thanks,
VishHi
Your best bet would be SQL Server Replication. The central SQL Server would
pull data from the MSDE instances.
Have a look at the links off
http://www.microsoft.com/technet/pr...crosoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vish" <vichumca@.gmail.com> wrote in message
news:1127131645.102228.245660@.f14g2000cwb.googlegroups.com...
> Hi All,
> I need your expertise comments for using linked server in WAN
> environment. I need to suggest it to my client.
> Here is the scenario:
> My client is having 20 retail shops across US. He got a Central office
> located in OHIO state.
> All the stores are connected through WAN.
> Now we are developing a transaction system for store's. All stores are
> going to use MSDE.
> One Enterprise SQL server is going to be installed in central office.
> In this scenario will linked server work for distributing transaction
> across stores?.
> For example,
> The gift card transaction happened in one store should be immediately
> updated (or in frequent interval)
> to central server. This enables other store to pickup the transaction
> on need basis.
> I used linked server in LAN environment and it works. But I could not
> think of WAN environment.
> What ports need to be opened for these SQL transaction?
> What environement is required to enable linked server (including
> security)?
> How do I create an environment in my Office itself, so that I will be
> confirtable on suggesting it or any other way to acheive the immediate
> update and retrieval (other than replication).
>
> Please help.
> With thanks,
> Vish
>|||Dear Mike,
Replication is a good choice. But I am not going to replicate
everything. Only customized transactions are used.
Please reply
Regards
Vish
*** Sent via Developersdex http://www.codecomments.com ***|||you can select which articles to replicate
"viswanathan somasundaram" <vichumca@.rediffmail.com> wrote in message
news:O0pJfxRvFHA.2880@.TK2MSFTNGP12.phx.gbl...
>
> Dear Mike,
> Replication is a good choice. But I am not going to replicate
> everything. Only customized transactions are used.
> Please reply
> Regards
> Vish
> *** Sent via Developersdex http://www.codecomments.com ***

Help on linked server

Hi All,
I need your expertise comments for using linked server in WAN
environment. I need to suggest it to my client.
Here is the scenario:
My client is having 20 retail shops across US. He got a Central office
located in OHIO state.
All the stores are connected through WAN.
Now we are developing a transaction system for store's. All stores are
going to use MSDE.
One Enterprise SQL server is going to be installed in central office.
In this scenario will linked server work for distributing transaction
across stores?.
For example,
The gift card transaction happened in one store should be immediately
updated (or in frequent interval)
to central server. This enables other store to pickup the transaction
on need basis.
I used linked server in LAN environment and it works. But I could not
think of WAN environment.
What ports need to be opened for these SQL transaction?
What environement is required to enable linked server (including
security)?
How do I create an environment in my Office itself, so that I will be
confirtable on suggesting it or any other way to acheive the immediate
update and retrieval (other than replication).
Please help.
With thanks,
VishHi
Your best bet would be SQL Server Replication. The central SQL Server would
pull data from the MSDE instances.
Have a look at the links off
http://www.microsoft.com/technet/prodtechnol/sql/2000/technologies/replictn.mspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vish" <vichumca@.gmail.com> wrote in message
news:1127131645.102228.245660@.f14g2000cwb.googlegroups.com...
> Hi All,
> I need your expertise comments for using linked server in WAN
> environment. I need to suggest it to my client.
> Here is the scenario:
> My client is having 20 retail shops across US. He got a Central office
> located in OHIO state.
> All the stores are connected through WAN.
> Now we are developing a transaction system for store's. All stores are
> going to use MSDE.
> One Enterprise SQL server is going to be installed in central office.
> In this scenario will linked server work for distributing transaction
> across stores?.
> For example,
> The gift card transaction happened in one store should be immediately
> updated (or in frequent interval)
> to central server. This enables other store to pickup the transaction
> on need basis.
> I used linked server in LAN environment and it works. But I could not
> think of WAN environment.
> What ports need to be opened for these SQL transaction?
> What environement is required to enable linked server (including
> security)?
> How do I create an environment in my Office itself, so that I will be
> confirtable on suggesting it or any other way to acheive the immediate
> update and retrieval (other than replication).
>
> Please help.
> With thanks,
> Vish
>

Help on linked server

Hi All,
I need your expertise comments for using linked server in WAN
environment. I need to suggest it to my client.
Here is the scenario:
My client is having 20 retail shops across US. He got a Central office
located in OHIO state.
All the stores are connected through WAN.
Now we are developing a transaction system for store's. All stores are
going to use MSDE.
One Enterprise SQL server is going to be installed in central office.
In this scenario will linked server work for distributing transaction
across stores?.
For example,
The gift card transaction happened in one store should be immediately
updated (or in frequent interval)
to central server. This enables other store to pickup the transaction
on need basis.
I used linked server in LAN environment and it works. But I could not
think of WAN environment.
What ports need to be opened for these SQL transaction?
What environement is required to enable linked server (including
security)?
How do I create an environment in my Office itself, so that I will be
confirtable on suggesting it or any other way to acheive the immediate
update and retrieval (other than replication).
Please help.
With thanks,
Vish
Hi
Your best bet would be SQL Server Replication. The central SQL Server would
pull data from the MSDE instances.
Have a look at the links off
http://www.microsoft.com/technet/pro.../replictn.mspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vish" <vichumca@.gmail.com> wrote in message
news:1127131645.102228.245660@.f14g2000cwb.googlegr oups.com...
> Hi All,
> I need your expertise comments for using linked server in WAN
> environment. I need to suggest it to my client.
> Here is the scenario:
> My client is having 20 retail shops across US. He got a Central office
> located in OHIO state.
> All the stores are connected through WAN.
> Now we are developing a transaction system for store's. All stores are
> going to use MSDE.
> One Enterprise SQL server is going to be installed in central office.
> In this scenario will linked server work for distributing transaction
> across stores?.
> For example,
> The gift card transaction happened in one store should be immediately
> updated (or in frequent interval)
> to central server. This enables other store to pickup the transaction
> on need basis.
> I used linked server in LAN environment and it works. But I could not
> think of WAN environment.
> What ports need to be opened for these SQL transaction?
> What environement is required to enable linked server (including
> security)?
> How do I create an environment in my Office itself, so that I will be
> confirtable on suggesting it or any other way to acheive the immediate
> update and retrieval (other than replication).
>
> Please help.
> With thanks,
> Vish
>
|||Dear Mike,
Replication is a good choice. But I am not going to replicate
everything. Only customized transactions are used.
Please reply
Regards
Vish
*** Sent via Developersdex http://www.codecomments.com ***
|||you can select which articles to replicate
"viswanathan somasundaram" <vichumca@.rediffmail.com> wrote in message
news:O0pJfxRvFHA.2880@.TK2MSFTNGP12.phx.gbl...
>
> Dear Mike,
> Replication is a good choice. But I am not going to replicate
> everything. Only customized transactions are used.
> Please reply
> Regards
> Vish
> *** Sent via Developersdex http://www.codecomments.com ***

help on indices

are there any thumb rules to follow to set up indices on tables and to set the fill factor. can somebody suggest any link where I can read about this.
thanks in advance.
RohitSQL Server Central has some real good articles. Unfortunately, I haven't found any standard guidlines for creating indexes and setting fill factors. It realy depends how your system is designed and what you're trying to do. I found testing is the key and learning simply by trial and error.

Heer's the link:
http://www.sqlservercentral.com/|||The biggest factor I have found is the placement of the clustered index. I typically place the clustered index on the identity column (if I have one) so I don't have to worry about pagesplitting as new data always falls at the bottom of the leaf level. You're big thing with fill factors is you are paying a price in storage to reduce or eliminate page splits during operations. Kalen Delaney's Inside SQL Server 2000 is good for researching indexing and page splits.

HTH|||Page splitting is really what can eat time. But that only happens when a new key-value is inserted or changed "at random" or when a record-delete occurs. It really depends on your data and your application. In an awful lot of applications, deletions and even key-changes occur "almost never."

I'd suggest that you make no changes at all unless, after quite some time of running the database, you can establish that insert/delete/change-key activity is really creating a "human noticeable" performance problem. Establish that; don't "fiddle and tweak and guess."

Another thing to really bear in mind is that every index you place on the database ought to have a clear purpose for being there. It's real easy to have too many, and I think that's what really munchie-munchies the time away for any database. Some indexes might need to exist only for certain purposes, e.g. once-a-month, in which case it might be profitable to drop or deactivate them except when they're needed. (A computer can rebuild an index "from scratch" uncommonly quickly. Obviously if you are dealing with "billions and billions" of records, you might not... etc.)

An index will never be "optimal." Not at any time; not if it's being used. :p They don't need to be reorganized frequently... they will maintain themselves. Let them do that! This means that they will always have fairly-empty pages, somewhat lopsided record-counts in the tree... and "who cares." You should really only plan to take action when, and if, you factually establish the presence of unacceptable pain in the current status quo.|||The reason you would care about the amount of empty space in your indices are that it makes your queries have higher logical IO than neccessary.

To see if you have page splits issues, run perfmon and check your page splits/sec. To check your fragmentation level of your tables run dbcc showcontig, to see your logical IO and how you can tune your queries, use "set statistics IO on"

HTH|||Now I know where to start from, thank you all for the inputs.
Rohit

Help Needed!

Hi,
I have been SQL developer for past 2 yrs, want to get into Administration(DBA) can any one suggest me some good articles on net and good books for this.
TIA,
sudheer.Best book on the planet: Inside SQL Server 2000 by Kalen Delaney.

Also:

SQL Server Performance Tuning Technical Reference (Microsoft Press)
Articles on:
sql-server-performance.com
sqlteam.com
sqljunkies.com

That should take you a long way.

Learn to use profiler, performance monitor, and traces really, really well.

Learn how to analyze execution plans, the locking and transaction processes for SQL Server, and when you're comfortable with that, come back for more.

There's always more to learn. :)|||Drop $49.00 for the full blown developer edition from M$

Install it and use it...

Nothing like hands on...

And remeber, it's a matter of when, not if...

Always be able to recover within minutes...

That said...being a pure DBA is boring...

Target being a systemn architect...whatever that means...

Or wash windows...

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=7198|||They call them Data Architects here. But from what I saw they have very little understanding of administration, mostly talk about database federation and project prosecution. Understanding internals of the engine they leave to us, but more often than none lack of understanding of the above leads to bigger things failing. Example of it would be as simple as selection of the wrong datatype, but it's so common, even in this forum.|||Ya mean like...

CREATE TABLE Person (SSN int NOT NULL, ect|||That, and also:

create...PhonePrefix int not null, PhoneSuffix int not null...
YesNoFlag char(3) not null...

3 TEXT fields in the middle of the table, followed by a dozen of INT's...|||Another reason for cross-over knowledge for both Admins and Architects, as well as for cooperation between the two.

By the way, my rule for developers is: "If you don't add it, subtract it, multiply it, or divide it, it ain't a number."|||My rule is (which nobody here agrees with), - you can't be a DBA without a good solid background in development, a couple of "real" systems still running and your name popping in the "About" dialog box.|||I'd say you can be a decent DBA without development experience, but not a good DBA or a great DBA.|||Originally posted by rdjabarov
They call them Data Architects here. But from what I saw they have very little understanding of administration, mostly talk about database federation and project prosecution. shoot 'em

they may be "data architects" in title, but they are not in fact
Example of it would be as simple as selection of the wrong datatype, but it's so common, even in this forum. hang 'em, then shoot 'em|||That is so cruel. Being a knee-jerk liberal, I believe that everyone can be reformed. I think some sort of long-term institutionalized treatment, possibly in conjunction with electro-shock therapy, might be effective.|||I'd rather have a bottle in front of me than a frontal lobotomy

But that's just me...|||no way

data architects have to be able to think

i oughta know, i are one

put these guys out of their misery, i say

where i do have compassion, though, is for DBAs trying to climb the evolutionary ladder to Data Architect

first of all, most of them can make the step up easily, being able to think and all, and secondly, you give them a break for wanting to

but as you may suspect from phrases like "database federation and project prosecution" there is a much higher bullsh1t factor in data architecture, being, as it unfortunately is, closer to management, which is permeated with the stuff

one thing i'll say for DBAs, they usually enjoy a life far removed from management, to the detriment of neither and the greater good of all concerned|||Well, the reason why I said that development background is a must, because before one can administer anything, they need to be able to say that they own it. Without knowing how to develop it you can't say that it's "your baby". And without it being "your baby" I, for example, can't care less how it works and whether it works at all.
But even before all this comes to play, one needs to be able to understand the business that an application is running for, and a specific business need that it serves. blah-blah-blah (place holder for words that the author can't come up with to express what he "really" thinks about it, - a lot of passion ;))|||I have another question along the lines of the original post. I just accepted a job as a Data Analyst/Computer Programmer Friday. I begin my new job April 22nd after 16 very long months of looking. The technologies they will use are SQL Server, MS Access(which they are outgrowing, hence SQL Server) and VB. I am not sure if it is VB.net or VB6 but when I spoke to the owners they mentioned that as I advance there are possibilities for an eventual DBA position. It is a small company that deals w/ a ton of healthcare related data. I see it as a great opportunity. Anyway, the issue is when I see posts from the Oracle DBA's their suggestion is to be able to "break and recreate the database". What does that mean exactly?

Thanks again. I really love this board.

ddave|||Break and recreate? I guess for practice purposes, and also to demonstrate that they can do it ;)

Where's your job at with healthcare?|||Yeah, never heard of break and recreate....

What exactly is the requirement...

Is it Full time? Consulting?

16 months...ouch

Where in the world are you located?

Did a lot of health care back in the day...

designed a health care provider database long tim agao...

That was actually a business analyst/data modeler position...|||Healthcare provider database? You meant provider credentialing?|||Nah...doctors, their managed medical contracts, offices, hospitals. ect|||Hi Guys,

I am in Los Angeles County. It is not for a healthcare company. It is consulting related to healthcare. You know, analyzing medical costs etc.

Yeah, 16 months of filing, making phone calls, etc w/ 2 bachelor's degrees was painful.

ddave|||DDave, if you need a road warrior, - let me know. We'll get them (this place really starts getting on my nerves :mad: )|||Your in the states huh...

maybe we hit bottom and are starting the climb back up...

When I thought we were down, we were actually still up and on the way down some more...

Hell Fleets buying BOA and BOA is going to fire 10,000

Man we're going to have 1 bank in the end....|||road warrior? like, telecommuter?

i've only had a job 5 months out of the past 3 1/2 years...|||Telecommuter would be great, but for some bizarr reason companies want a warm body...|||Originally posted by r937
road warrior? like, telecommuter?

i've only had a job 5 months out of the past 3 1/2 years...

Wow....what'dya do the rest of the time?|||Come to think of it, a recruiter contacted me about a job with Northrup Gruman in Rancho Bernardo. I guess that is their HQ. If you guys are interested I will get the contact info. Rates are up to 95/hour but you gotta be pretty senior for them.

ddave|||Originally posted by Brett Kaiser
Wow....what'dya do the rest of the time?
hang out on database forums, answering questions

many are simple (the questions, not the forums), but i answer them anyway

many are complex, richly rewarding for the effort of solving them, as i get to learn some more about the nuances of sql

approx 10,000 posts of that nature

of which a few, such as this, are not strictly about sql

i'm also writing an sql course at the moment...|||I think what he meant was: what'dya do the FOR MONEY? Five months out of six years? I shudder to think what your hourly rate must have been.|||3 1/2 years...6 1/2 would be like a prison sentence

ddave|||5 months fulltime since january 2001

otherwise, very little

some web development clients, small stuff

oh, and my Ask the Expert (http://r937.com/sqlate.cfm) column, they pay me (modestly) for that

keeping one eye open for data modelling contracts, but it's hard to place a data architect these days, especially one without skillz0rz using all the latest slick data modelling t00lz, and especially one who has a low tolerance for the management bullsh1t i mentioned earlier

i don't let being out of work bother me, though

and the frequent (and dare i say, substantive) posts i make on database forums like this one has brought me a few part-time contracts, so that's good...

like jack horkheimer, i just keep on looking up!!