Howtos / Articles

Microsoft SQL Server 2008 Express Limitations

Microsoft SQL Server 2008 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2008 Express Edition. (Note: This information is not for SQL Server 2008 R2. If you are after the details for the limitations on SQL Server 2008 R2, please check out Microsoft SQL Server 2008 R2 Express Limitations). CPU: 1 CPU (based on a…

Read more [...]

Microsoft SQL Server 2008 R2 Express Limitations

Microsoft SQL Server 2008 R2 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2008 R2 Express Edition. CPU: 1 CPU (based on a socket). No limit on cores. Memory: Maximum of 1GB for the database engine. (Note: SQL 2008 R2 Express Edition with Advanced Services includes reporting features, and has a limit of 4GB for…

Read more [...]

Microsoft SQL Server 2012 Express Limitations

Microsoft SQL Server 2012 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2012 Express Edition. CPU: 1 CPU (based on a socket) or 4 cores. The lesser of the two is used. Eg: If you have 1 CPU that contains 8 cores, it will only use 4 cores. or If you have a system with…

Read more [...]

Restore Microsoft SQL Database Using T-SQL

This guide will show you how to restore a Microsoft SQL database using T-SQL commands rather than using the wizards in SQL Management Studio. This has the added benefit of being able to be scripted if needed. Restoring a Microsoft SQL database: RESTORE DATABASE [database_name] FROM DISK=’c:\path\to\backup\file.bak’ Replace ‘database_name’ with the name of the database you want to restore to. Eg: RESTORE DATABASE [testing] FROM DISK=’C:\temp\testing.bak’ Sample output: Processed 312 pages for database ‘testing’, file ‘Testing’ on file 1. Processed…

Read more [...]

Backup Microsoft SQL Database Using T-SQL

This guide will show you how to backup a Microsoft SQL database using T-SQL commands rather than using the wizards in SQL Management Studio. This has the added benefit of being able to be scripted if needed. Backing up a Microsoft SQL database: BACKUP DATABASE [database_name] TO DISK=’c:\path\to\backup\file.bak’ Replace ‘database_name’ with the name of the database you want to backup. Eg: BACKUP DATABASE [testing] TO DISK=’C:\temp\testing.bak’ Sample output: Processed 312 pages for database ‘testing’, file ‘Testing’ on file 1. Processed…

Read more [...]



Page 12 of 42« First...891011121314151617...3040...Last »