Skip to main content

Home/ MS SQL Server and Analysis Services/ Group items matching "SQL2008" in title, tags, annotations or url

Group items matching
in title, tags, annotations or url

Sort By: Relevance | Date Filter: All | Bookmarks | Topics Simple Middle
Sergey Leifer

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server - 1 views

support.microsoft.com/918483

SQL Server Management SQL2008

shared by Sergey Leifer on 31 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    ... SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API. On a Microsoft Windows 2000 Server-based system, SQL Server periodically calculates the free physical memory on the system by using the native Windows API. Based on this information from the QueryMemoryResourceNotification Windows API or from the memory calculation, SQL Server responds to the current memory situation on a specific system...
Sergey Leifer

TSQL - Script for moving databases to a new location - 0 views

set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...

SQL Server Management SQL2000 SQL2008

started by Sergey Leifer on 21 Sep 10 no follow-up yet
1 - 4 of 4
Showing 20▼ items per page