I have a SQL Server 2000 database. When I run the following command select * from sysindexkeys This display the appropriate records.
I\'ve read the definition of logical reads from: http://msdn.microsoft.com/en-us/library/ms184361.aspx
I have a table name Overtime Hours which have the following columns Ot_ID, Shift_Date, Employee_ID, Hours.
I would like to know what is the maximum size of varchar in SQL Server 2000. While I was googling somewhere it was开发者_StackOverflow written 8000 characters and somewhere it was written 8060 bytes.
Ive been working all day on optimizing a SQL Server 2000 db table with ~9million rows. My only db experience has been with tables with a few hundred rows, so I\'ve never really had to deal with optimi
What technical issues am I likely to encounter when migrating a database from SQL Server 2000 to SQL Server 2005? Are there any common problems I should be aware of?
I have tried to connect to SQL Server 2000 through TCP/IP. I followed these steps and enabled SQL Server 2000 on port 1433.
SQL SERVER 2000: I have a table with test data (about 100000 rows), I want to update a column value from another table with some random data from another table. According to this question, This is wh
My ERP system has a half baked deletion tracking system which inserts the following info into a table called M2MDeleteLog. I have left out unnecessary columns such as RecordId for simplicity.
I have a table that describes a hierarchy: NameMemberName AB AC BD DE FG MemberName references the Name column of the same table.From this table, I can easily query to see that B and C are members
加载中,请稍侯......