Hi,We recently migrated out MSSQL 2000 servers to another system.We have both systems working in parallel for the next few weeks, at which point our...
Hi,We are in the process of migrating our system which is currently using a Data Center to Amazon EC2. Our current system architecture is as such: -...
Hi,I work with MSSQL 2000. When creating tables I never paid attention to the order and type of columns. Last week a co-worker mentioned that it is...
Hi,We have transactional replication set up on our MSSQL 2000 servers. I am trying to add a new article to the publisher, but it does not seem to...
Hi,Recently our company began considering an increase in the amount of content we house in our MSSQL 2000 database. One of the obvious questions...
Hello,We have recently moved a database to Amazon EC2 instance. We chose the server with identical configurations. The performance on the new...
Hello,We are using SQL Server 2000. We have a database which has been growing for for the last 3 years, and is currently at 64GB. Upon...
Hello,We have SQL Server 2000 Enterprise Edition. From time to time we rebuild indexes on one of our databases, which follows a Full Recovery Model....
Guys,How can I find out a list of users with DELETE privilege to a certain table?Thanks a lot!
Hello, I have a stored procedure which is running slowly. Looking at the execution plan in the query analyzer I saw that the subtree cost is 3.5...
Hello, We are currently in the process of data migration from EMC Sandisk to 3 Par. We are using SQL Server 2000 machines with the following...
Guys, We have recently added a new SQL Server 2000 instance, which has identical database structure as a few other servers we had. We have...
Hello, I have database with many tables. The backup file size of the database is approximately 27GB. However, when I add up all the sizes of all...
Guys, We are using MSSQL Server 2000, with the following version: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17...
Guys, I am using MSSQL Server 2000. My current version is shown below: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17...
Hello, I am using MS SQL Server 2000. I have created a table with the following structure: CREATE TABLE [dbo].[x] ( [UID] [bigint] NOT NULL...
Guys, How can I find out "automatically" [i.e. via a query] how many times a transaction log was backed up for a specific database within the last...
Guys, I have a table with the following structure: CREATE TABLE [dbo].[CTA] ( [CID] [int] NOT NULL , [AID] [int] NOT NULL , [NumOcc]...
Guys, We have many tables in our environment [SQL Server 2000] with UID field of INTEGER data type, which are running out of numbers. That is, the...
Guys, I started getting the following errors recently. They happen every day, at the same time, and last 5-10 minutes. During the time of this...
Separate names with a comma.
