what is SQL Server 2005 reporting service?SQL Server Reporting Services is a comprehensive, server-based solution that enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft Business Intelligence framework, Reporting Services combines the data management capabilities of … [Read more...] about SQL Server – 2005 Reporting Services
SQL Server
Navision Slow on SQL Server
Dynamics NAV(Navision) Slow on SQL Server Many users experienced Navision getting slower and slower as time goes by. There are many factors that can affects performance of Navision on SQL Server. It can be hardware bottleneck, database design problem or even coding design problem. Below are the few areas that you can look into if your Navision on SQL Server is getting … [Read more...] about Navision Slow on SQL Server
SumIndexFields and SQL Server In Navision
SumIndexFields and SQL ServerWhen you add SumIndexFields to a key in Navision table, Navision will create additional table in SQL Server, which is known as SIFT table to store the pre-calculated value for the SumIndexFields. SIFT table is a term used in Navision. In fact, the SIFT table is just an ordinary table in SQL Server. The SIFT table is named with the following naming … [Read more...] about SumIndexFields and SQL Server In Navision