Like all database servers, Microsoft SQL Server thrives on memory. Each instance of Microsoft SQL Server has its own memory address space. The SQL Server address space (Virtual memory allocation by Windows) consists of two main components: Executable Code and Memory Pool. Let's examine each of these components in more details. Read more...

Migrating changes made to SQL Server databases to production

Almost all developers use a dedicated development server where they make changes to data and schemas instead of changing production servers directly. Every company that uses SQL Server is faced with the challenge of migrating changes made on a development server to staging and production servers. Developers have to plan which method they should use to achieve a seamless migration. Read more...

Understanding SQL Server backup types

Database backups are at the core of any SQL Server disaster recovery planning for any production system. Microsoft® SQL Server™ provides several kinds of backups that may be combined to formulate a customized disaster recovery plan depending on the nature of the data and the recovery requirements. Read more...

Advantages of SQL Server 2005 (64-bit)

64-bit processors are expected to dominate the markets by the end of 2007. It is clear that the industry is moving towards the 64-bit platform fast, especially for server hardware. The move towards the 64-bit platform has been driven by lower hardware prices, especially after the introduction of x64 architecture by both Intel (EM64T) and AMD (AMD64). Read more...

Understanding DDL Triggers in SQL Server 2005

Much like regular DML triggers, DDL triggers fire in response to an event happening on the server. However, DDL triggers do not fire in response to UPDATE, INSERT, or DELETE statements on a table or view. Instead, they fire in response to Data Definition Language (DDL) statements that start with the keywords CREATE, ALTER, and DROP. Read more...

Longhorn, Vista to drop SQL Server 2000 and MSDE support

In a surprise move, Microsoft announced that the soon-to-be released Microsoft Windows Vista operating system and Microsoft Windows Server "Longhorn" will not support earlier versions of SQL Server, including SQL Server 2000 (all editions including MSDE), SQL Server 7.0, and SQL Server 6.5. Read more...

Understanding VARCHAR(MAX) in SQL Server 2005

In SQL Server 2000 and SQL Server 7, a row cannot exceed 8000 bytes in size. This means that a VARBINARY column can only store 8000 bytes (assuming it is the only column in a table), a VARCHAR column can store up to 8000 characters and an NVARCHAR column can store up to 4000 characters (2 bytes per unicode character). This limitation stems from the 8 KB internal page size SQL Server uses to save data to disk. Read more...

Privacy Statement

License Agreement

Articles

Site Map