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...
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...
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?
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 ----------...
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...
Can I move the log file of a database to a different partition with no downtime?
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...
Hey, <br />I have yet another strange query that takes 20 seconds to run. I've beaten my head against the wall for a few days with this one too, and...
Hi, I have a stored procedure that for some reason takes 24 seconds to complete. I called it using the following code in query analyzer: exec...
Hi, I have a database with a few hundred tables. What's a quick and easy way to see the top tables in terms of size (In KB and/or number of rows)?
What's the best way to add an index on a production server? If I add them in the design table interface, will they actually be added and used soon...
How can I dbcc indexdefrag all indexes in a database?
Hi, I have a production database that has about 6GB of data. I would like to create a test DB, that will be a replica of that production database on...
Actually, the title may be misleading, because I am not certain a trigger is involved. Here is the situation: I had a table that acted as if it had...
Separate names with a comma.
