Viewing 15 posts - 1,456 through 1,470 (of 2,051 total)
Have you checked the consistency of the database (DBCC CHECKTABLE)?
When I had that error there were some consistency errors.
June 27, 2006 at 2:50 am
What operating system do both sql servers have?
In case of windows 2003 you have to be aware of:
June 27, 2006 at 2:47 am
You could also try sp_updatestats on your databases (updating statistics)
A query plan on a very large table changed from a clustered index scan to an index seek
June 22, 2006 at 3:27 pm
*msdb is largely a database for sql server agent, to store dts-definitions, scheduled jobs, backup history...
Sql server is quite selfconfiguring (buffers, updating statistics,recompiling,...).Chanches are that you have to tweak memory allocation...
June 21, 2006 at 2:07 pm
Seperate drives for the logs :ok
Seperate drives for the mdfs: ok
Seperate drives for the backups (the ATA drive) (could be on a removable drive as well so you don't have...
June 21, 2006 at 11:05 am
A great start is to have a look at http://www.sql-server-performance.com/sql_server_performance_audit.asp
about how to do a sql server performance audit.
Here is a list of all the waittypes:
http://www.sqldev.net/misc/waittypes.htm
Since it is pageIOlatch_sh ...
June 21, 2006 at 10:55 am
Too bad I don't have the books online at hand at the moment. The text field like an image/binary field. It is stored separately from the record.
Have a look at...
June 21, 2006 at 10:46 am
You can loop the recordset and execute the stored procedure for each record.
June 21, 2006 at 10:39 am
How is the security delegation for linked sql server configured?
Always login using with the user context, always connect with this account ....?
June 18, 2006 at 9:14 am
Both are sql server 2000?
Same collation?
Are you sure that col3 on A isn't a timestamp?
June 8, 2006 at 10:33 am
That made me curious since we use also Oracle at work.
How do you set the option "Nested Queries" to on?
May 16, 2006 at 2:55 am
You could use openquery.
Create a view on oracle that combines both tables?
May 15, 2006 at 1:26 pm
Are you local client tools also patched to sp4?
May 15, 2006 at 1:20 pm
select companyid,staffname
from
(select companyid,staffname,1 as sequence
from tblA
where companyid='ABC123'
union
select companyid,stafname,2 as sequence
from tblB
where companyid='ABC123'
) AS mynewtable
order by companyid,stafname,sequence
May 15, 2006 at 1:01 pm
see http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx
it depends on OS & edition
from 32mb of memory to 128
April 25, 2006 at 12:32 pm
Viewing 15 posts - 1,456 through 1,470 (of 2,051 total)