Viewing 15 posts - 1 through 15 (of 18 total)
my post is already 3 years old ;-).
The "estimated number of rows" was consequently wrong for one table and i could not improve it by updating statistics. I had...
September 3, 2013 at 11:36 pm
please have a look at this article which should solve your problem:
We will also try to use "IBM OLEDB for DB2 provider" because for "Microsoft OLEDB for DB2...
August 4, 2011 at 1:57 am
Screenshot 9 is the same as Screenshot 8 🙂
June 29, 2011 at 1:48 am
Thanks for the advice, our server administrar has chosen to insert a new network card, let's if it helps.
May 6, 2011 at 7:41 am
In the execution plan i have seen that for the good server the estimated number of rows is 1 and on the bad server the estimated number of rows is...
July 27, 2010 at 6:53 am
yes i made a mistake which shows indeed that samething is wrong in the execution plan.
I have forgotten to limit the data in T_AD_ACTUAL_DATE (Where condition).
But as you can see...
July 26, 2010 at 6:45 am
- quite the same hardware ~ 20gb ram
- same amount of data in the source tables
- no other loads during my tests on the server
- same schema, etc.
Attached you'll find...
July 26, 2010 at 5:57 am
Here the remaining information:
October 19, 2009 at 3:44 am
is Oracle server local or remote?
- remote (Sql Server Europe, Oracle US)
how many network hops?
- T1 = 1,544 Mbit/sec.
how complex is the query reading from...
October 16, 2009 at 9:26 am
And what about if you have different servers: Test,Quality and Production. How do you know which version is on which server??
September 22, 2009 at 1:34 am
In syscomments and sys.sql_modules there is only the code of procedures and views stored, is there also a possibilty to see the definition of tables and indizes?
September 15, 2009 at 9:24 am
The problems with sourcesafe, subversion are:
1. Changes can be made outside of the source control because they are based on flat files and there is no link to the database
September 15, 2009 at 8:52 am
That's what i wanted to do. Every change to the database should be logged.
If you have source controll in subversion etc. there is still the possibility to make changes directy...
September 15, 2009 at 8:47 am
Thanks HowardW! Thats what i needed to know!
September 15, 2009 at 8:38 am
thanks for your quick reply. Unfortunately it does not work, if you copy and paste the source code out there are still no linebrakes 🙁
September 15, 2009 at 8:36 am