Przełącznik języka
Select your language
BUY COFFEE
If you like the website and want to support the project!
Tools
Mining
Security
CMS
Hardware
Backup
Windows Server
Uncategorised
useful sites
Databases
Emulators
Powershell
Storage Array
Active Directory
SEO
MSSQL
DNS
Antivirus program
Linux
Foto
Forcing refresh access speed to shares from Windows 7
SMB2 Client Redirector Caches Explained
the slow refresh the contents of shared folders.
solution:
Copy the following contents and enter it in the register.
| Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanWorkstation\Parameters] "DirectoryCacheLifetime"=dword:00000000 |
Axapta Error
Axapta Error
Navision Axapta Network COmmunication
No Navision Axapta Object servers could be located using the current client configuration.
solution:
It was probably running an older version of the client incompatible with the database check that you have installed all the service pack.
Limits SQL Server Express 2008 R2
Limits SQL Server Express 2008 R2
SQL Server Express 2008 R2 is running free - it is a truncated version of the full MS SQL has a number of limitations that distinguish it from the full product.
Has a limit on the size of the formerly 4GB current limit has been raised to 10 GB - refers to the R2 version of SQL Server Express 2008 limit remains at 4 GB per database.
This version is designed for small businesses that do not will expand a database of over a certain threshold
The following table shows the restrictions on SQL Server Express 2008 R2
| Name | LIMIT |
| Number of CPUs | 1 |
| Maximum utilization of memory | 1 GB |
| The maximum database size | 10 GB |
| The number of cores | no restrictions |
System requirements to install MS SQL Express 2008 R2:
Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista or Windows XP
.NET Framework 2.0 SP2
For 32-bit systems with Intel or compatible 1GHz or faster (over 2 GHz recommended)
For 64-bit systems 1.4 GHz processor or faster
512 MB of RAM (2 GB or more recommended)
2.2 GB of free disk space
How to check the size of MS SQL database
How to check the size of MS SQL database
enter the command
sp_spaceused - shows the total database size
sp_spaceused 'MyTable' - shows the size of the table
Page 71 of 93