Viewing 15 posts - 1,486 through 1,500 (of 2,086 total)
The added latency could have increased the time the locks are held. Do you close your recordsets as soon as possible?
Is it possible to have the printing done not by...
July 3, 2006 at 5:38 am
You can also figure it out with sp_who,sp_who2,sp_lock.
The client tools version matches the sql server version (in terms of servicepacks)?
July 3, 2006 at 4:50 am
Have a look at http://www.connectionstrings.com/ for all possible connection strings.
Things to check:
Servername htm is known on the other pc.
Is your sql server configured for windows or mixed mode? If windows...
July 3, 2006 at 4:47 am
Care to elaborate a bit?
Is this about using the identity datatype or using a default value?
July 2, 2006 at 4:14 am
Have you checked security delegation for the linked servers?
A guess in the dark, have you rebooted the machines to make sure that MSDTC is started before sql server?
The windows servers have...
June 28, 2006 at 2:30 pm
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
Viewing 15 posts - 1,486 through 1,500 (of 2,086 total)