Thanks. I ran that stored procedure and these were the results: TB_SSHsignature762.55MB Half as much as it actually takes.
I have the following table: <code> CREATE TABLE [dbo].[TB_SSHSignature] ( [ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [ContentID]...
I have two tables. Example data for Table ATable B 11 11 11 21 22 33 33 34 34 44 44 I would like to measure how similar table A is to table B in...
quote:Originally posted by mmarovic Be aware that: select Count(Signature) as num from Table WITH (NOLOCK) where ContentID = ### and deleted = 0...
I have a simple table: ID int 4, ContentID int 4, Signature Decimal 20, Deleted bit. A simlpe query: select Count(Signature) as num from Table...
The database is in simple recovery mode. I don't know abuot checkpoints, but I changed the recovery interval to 15 minutes. I'll see if it helps....
Am using sql 2000 sp3a on windows 2003 server. Using perfmon, it seems that the DB is constantly waiting on disk writes (Always doing about 7MBytes...
Anyone have a script for altering table structure in one database to match another database?
That's not an option. I cannot stop detection. what I'm trying right now is the following: Each time the table gets to 5,000,000 rows I create a...
I have a table containing hashes. I have one stored procedure that inserts new hashes, and one store procedure that detects if a certain hash is in...
I run the following SQL statement using query analyzer on a windows 2003 server with sql 2000 SP3 installed: --------- Begin paste code ----------...
Thanks, That did the trick!
Hi, We're migrating to a newer SQL server tonight and I was wondering if there's an easy way to copy Data Transformation Services from the old SQL...
I have an application that usually works with a 2-3 seconds response time, and once in a while (Every ~30 mins or so) it slows down to a grind (1-2...
You can't delete a primary log file. The question is how do you make the secondary log file you create primary.
Can I move the log file of a database to a different partition with no downtime?
The server has 12 databases totalling 14.6GB. I am fairly certain that the database is not stored in the memory as it has very poor performance and...
Does it actually work? I tried using it to increase the performance of a 50MB DB that is IObounded. I DBCC pintabled all the tables in the DB and it...
Hi, I'd like to move a 150MB to a different partition on the same server during production (Without disconnecting users). Is this possible? Is it...
Hi,<br /><br />A month ago I was given responsibitliy of a certain SQL server that is in need of a significant performance increase. I was, and still...
Separate names with a comma.
