{{theTime}}

Search This Blog

Total Pageviews

SQL Server Address Windowing Extensions(AWE) Option (Performance improvements)

-- Can be configured to improve performance.
-- Sql Server 32 bit can support max 3GB memory on Windows Platform.  Setting this option would let OS to allow more than 3GB
-- To enable, Goto Properties --> Memory --> Server memory Options.

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...