Kraks, Okay, that helps. Are you using the same version of SQL on both boxes? ie., both boxes are running SQL Server 2000 Standard Edition. Have tried running perfmon on the slow server, checking for disk i/o, processor and memory usage? wavie davie 🙂
2003-06-10
1 reads
Hello Todd, another thought that came to my mind is, that - assuming a 'good' programming - all stuff that is needed to built the new db should be placed in one single file. As Jay suggested, if possible you should post some code here. Cheers, Frank
2003-06-10
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-09
coverston you want the select to honor locks - but you want to read the locked data?? - that seems like a bit of contradiction to me .. In case i've got you wrong - would READPAST help - this would just skip the locked rows???
2003-06-07
1 reads
if you have a unique key in the results then yes USE PUBS SELECT ( SELECT COUNT(*) FROM Titles T2 WHERE T1.Title_id <= T2.Title_id) As RowNo , * FROM Titles T1 ORDER BY 1 but try this on a bigger table , and it will probably kill your server .. stick to the temporary table […]
2003-06-06
2003-06-06
1 reads
I have the same problem as described by Phillip Kelly. I chose (for the clustering question) the correct answer in MS Outlook which took me to a webpage saying that it was my last chance to correct my choice... So I figured I must've been wrong and chose a different response, only to be told […]
2003-06-05
1 reads
You can try this. You will obviosuly need to uncomment the exec at the end for it to do anything. CREATE proc search_tables @table sysname = 'ALL', @string varchar(8000) as declare @sql varchar(8000), @separator varchar(10), @current_table sysname IF @table = 'ALL' BEGIN DECLARE loop_tables CURSOR FOR SELECT name FROM sysobjects WHERE type = 'U' END […]
2003-06-05
As NPeeters mentioned, look at the default locking done by the VB logic. We had a similar situation with a sproc doing large calculations on a table used for simultaneous reporting. Turned out that the calculation piece was doing a delete on the table with criteria. This placed an exclusive lock on the entire table, […]
2003-06-05
1 reads
I have the exec commented out in my example. It produces a query that has an accurate where clause without all the other extraneous stuff. All you have to do to get it to run is uncomment out the exec and change it to match your structure.
2003-06-03
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers