Showing related tags and posts across the entire site.
-
Hi, I'm having a problem where a User which is granted SUPER roles in Navision gets an error when doing a transaction. The following SQL Server error(s) occured while accessing hte PW Inventory - Lot table: 1088, "42000", [Microsoft][ODBC Sql Server Driver][Sql Server]Cannot find the object...
-
dear friends i have to convert the navision 4.0 database to SQL DataBase (i have run max test in navision and took a back up in Navision) then i tried to restore the Navision DB to SQL Database(wich i have created using SQL sever option in Navision) then i am getting the following error massage. Table...
-
My plan is: Job 1: DBCC REINDEX [Table] x (n = processing tables) - daily Job 2: DBCC REINDEX [Table] x (n = entry tables) - weekly Job 3: DBCC REINDEX [Table] x (n = other tables) - monthly Job 4: DelZeroSift - daily (ref: http://www.mibuso.com/dlinfo.asp?FileID=812 ) Job 5: Update Stats - daily (as...
-
[quote user="DenSter"]You need to keep the statistics on the indexes current though. sp_updatestats will update the index statistics, and in turn will make the query analyzer more accurate. [/quote] Yes, Good statistics are critical to query optimizer. But there are several ways to update statistics...