1 - 11 of 11
PREVIOUS 1 NEXT
Error copying indexes in DTS package
I have a DTS package in SQL Server 2000 that copies data from one database to another. The copy indexes option is checked. For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over. At first it was maybe once or twice a...
I have a DTS package in SQL Server 2000 that copies data from one database to another. The copy indexes option is checked. For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over. At first it was maybe once or twice a...
45 pts.
Database Issues - Trying to prove that something has to be done
Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...
Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...
Indexes and abstracts in SQL Server
In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?
In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?
designing indexes
I have a question regarding database design. Lets assume that there is a table with 10 columns. I don't have any single column which I can choose as candidate for Primary key. Though, combination of 5 columns can uniquely identify records. Here, I created an identity column as a PK and added...
I have a question regarding database design. Lets assume that there is a table with 10 columns. I don't have any single column which I can choose as candidate for Primary key. Though, combination of 5 columns can uniquely identify records. Here, I created an identity column as a PK and added...
Analyzing Existing Indexes
Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...
Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...
Backing up and restoring a LIVE database in SQL Server 2000
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
DB2 indexes and Crystal Reports
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Why is the query using the index even though the perecentage of unique values is 52%?
I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity ratio), the table has a ratio of 52% unique values. I thought an index should be at least 90% unique in order for it to be used. Yet when I run the...
I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity ratio), the table has a ratio of 52% unique values. I thought an index should be at least 90% unique in order for it to be used. Yet when I run the...
execution plan is same even though it takes 10 times longer to run
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!
Stored Procedure for dropping indexes
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name...
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name...
1 - 11 of 11
PREVIOUS 1 NEXT
