Satya,I did not check the stored procedure execution plans yet. I was hoping to get the global view by stress testing and observing duration. There...
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...
In order for replication to work 3 stored procedures need to be created on the subscribers (sp_MSins_ ... sp_MSdel ... sp_MSupd). When everything is...
ghemant,Will any of these 2 steps create the necessary (insert/delete/update) stored procedures on the subscribers?Thank you!
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,On amazon EC2 we got MSSQL 2000, just as we had it. So we moved from 2000 to 2000 via backup and restore.I checked and SQL Server is taking...
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,I decided to simplify my problem a bit, and just find out if a given user is a sysadmin.This was achieved using the following script:SELECT...
Guys,How can I find out a list of users with DELETE privilege to a certain table?Thanks a lot!
Hello, Thank you for the information about Index Intersection. I guess I have been misinformed before. My impression was based on Tip 1 here:...
Preethiviraj, I am actually using SQL Server 2000, not 2005, so I don't think I can take advantage of the include you mention. As for the multiple...
The stored procedure does not have WITH RECOMPILE with its definition, but I do recompile it every time before testing its speed improvement using...
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...
Separate names with a comma.
