Suggested Max Memory Settings for SQL Server 2005/2008

Suggested Max Memory Settings for SQL Server 2005/2008 Posted on October 29, 2009 by Glenn Berry https://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/ It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject toSeguir leyendo

SQL Home Database Administration HDDs, SSDs and Database Considerations

https://www.simple-talk.com/sql/database-administration/hdds,-ssds-and-database-considerations/ A technical journal and community hub from Red Gate Join Simple-Talk Sign in Home SQL .NET Cloud SysAdmin Opinion Books Blogs Forums SQL Home Database Administration HDDs, SSDs and Database Considerations Av rating: Total votes: 33 Total comments: 5 send to a friend printer friendly version HDDs, SSDs and Database Considerations 09 January 2013Seguir leyendo

Database Price

http://www.microsoft.com/sql/howtobuy/default.mspx Note: The retail price for Microsoft SQL Server 2005 Developer Edition is $49.95. Microsoft SQL Server 2005 Developer Edition may be installed and used by one user to design, develop, test, and demonstrate your programs. SQL Server 2005 Pricing Comparison: Retail versus Example Pricing   Processor License   Server plus User/Device CALs    Seguir leyendo

Backup – Restore SQL 2005

T-SQL code BACKUP: USE myDatabaseName GO BACKUP DATABASE myDatabaseNameTO DISK = ‘C:\filePath\myDatabaseName.bak’NAME = ‘The name of the back up.’   RESTORE: RESTORE databaseName FROM DISK = ‘C:\filePath\backupFilename’ Tags: backup, restore