Showing related tags and posts across the entire site.
-
Will the DB performance be affected by inserted views? And how about data-manipulation? Will the MS SQL Server (2005) automatically adjust/update the VSIFTs if I insert data manually through a sql-queries? Somebody told me to use the C/ODBC-driver instead but if I got it right it's just for the native...
-
I am looking for a recommendation or an overview for the memory settings in the OS and SQL-Server in different versions. What do I have to activate in the boot.ini when I have 4 GB or 8GB Memory, when I have Windows-Server 2003 Standard, Enterprise in 32 or 64 bit. What do I have to avtivate in SQL-Server2005...
-
Imcurrently working on a project to integrate a mobile solution to Navision. We have decided on a stagin table route directly into the underlying SQL database. I an currently having an issue with the Nav Time field, which is seen as datetime on the sql server table. This issue i have is using sql insert...
-
I've a problem, who can help me? I've a SQLServer table sorted by a type code field that show the following records A A2 A3 B B2 C Why the same table called like a temporary table, containing the same record and ordered with the same key, show records ordered like the following? A B C A2 A3 B2...