Viewing 15 posts - 2,281 through 2,295 (of 3,061 total)
Thank you Gianluca, very kind of you.
October 2, 2009 at 7:06 am
1- Please check cardinality on affected Oracle tables.
2- Please describe available indexes on affected Oracle tables.
3- Check execution plan on Oracle side.
4- Ask Oracle DBA to do a '10046 trace...
October 2, 2009 at 6:47 am
mmmhhh... scenario description it's not clear enough - depending on interpretation it may be working the way it's supposed to work.
Could you please simplify to just two tables and show...
October 2, 2009 at 6:41 am
ItalianOlgi (10/2/2009)I have very good memory,I can study and memorize everything, I want to find a good job, make look like I expert on SQL Server.
Build your own lab....
October 2, 2009 at 6:24 am
Unfortunatelly you will have to script credentials, jobs, etc. on source server then apply scripts on target server.
October 2, 2009 at 6:14 am
Roy Ernest (10/1/2009)
PaulB-TheOneAndOnly (10/1/2009)
Roy Ernest (10/1/2009)
Please keep in mind that just because it is primary key, it has to be clustered.
mmhh... not entirely true.
Statement holds true only if 1) No...
October 1, 2009 at 1:48 pm
Question would be... why you want to have FKs on those replicated tables pointing to a different server? Parent-Child relationships are already validated at the source 😉 ...
October 1, 2009 at 1:13 pm
Roy Ernest (10/1/2009)
Please keep in mind that just because it is primary key, it has to be clustered.
mmhh... not entirely true.
Statement holds true only if 1) No clustered index already...
October 1, 2009 at 1:09 pm
Good.
Take the ten top queries you expect to hit that table, look at the predicate a.k.a. where clause and build indexes based on what you see.
As a rule of thumbs...
October 1, 2009 at 9:35 am
Post suggests there are two different issues here.
1) "Sharing" a table in between different schemas or the same database.
2) "Sharing" a table in between different databases located in different servers.
In...
October 1, 2009 at 9:04 am
Viky (10/1/2009)
I have a doubt because the fields are varchar type, Does not generate problems if I have index of fields that are varchar type?
No. No problem at all.
How...
October 1, 2009 at 8:58 am
manohar-718845 (10/1/2009)
will size matter while rebuilding index ?
Yes, it does. A 300K index is really a small one.
October 1, 2009 at 8:55 am
http://msdn.microsoft.com/en-us/library/ms143506.aspx You gotta love Microsoft documentation, don't you?
September 30, 2009 at 2:52 pm
dsohal (9/30/2009)
I used to Backup the Database in SQL 2000 and then truncate the Log File and later shrink the log File to free up the space
:crying: shhhh... tell nobody,...
September 30, 2009 at 2:09 pm
:pinch: shall I understand you are asking how to build indexes on Server-B pointing to tables sitting on Server-A?
September 30, 2009 at 2:04 pm
Viewing 15 posts - 2,281 through 2,295 (of 3,061 total)