Error message when creating a table in SQL
Whenever I try to create a table in SQL, I receive the error, "No disk space." How do I create more disk space on my Oracle server?
Whenever I try to create a table in SQL, I receive the error, "No disk space." How do I create more disk space on my Oracle server?
2445 pts.
how to delete dup records from a table to ?
basically i want to remove dups in a table. i have a table called productincludes it has a few fields listed here: ParentProductID ChildProductID SummarizedRowID IncludeStatus LastUpdateDate DisplayOrderByID i ran a update for a business request that made many dup rows and want to clean this up....
basically i want to remove dups in a table. i have a table called productincludes it has a few fields listed here: ParentProductID ChildProductID SummarizedRowID IncludeStatus LastUpdateDate DisplayOrderByID i ran a update for a business request that made many dup rows and want to clean this up....
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...
Lowering a high average disk queue length on a SQL Server
We have a small table on our SQL Server with a high Avg. Disk Queue Length. The typical methods to fix this, such as fragmentation for the indexes and reorganizing the indexes, do not help. What other solutions are there?
We have a small table on our SQL Server with a high Avg. Disk Queue Length. The typical methods to fix this, such as fragmentation for the indexes and reorganizing the indexes, do not help. What other solutions are there?
Multiple users with access to a table in SQL Server 2005
If more than one user can put in a BEGIN TRAN statement, along with being able to update records, of the same table on SQL Server 2005, what will be the rollback results?
If more than one user can put in a BEGIN TRAN statement, along with being able to update records, of the same table on SQL Server 2005, what will be the rollback results?
