Skip to main content

Home/ MS SQL Server and Analysis Services/ Group items tagged Management

Rss Feed Group items tagged

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

Automating Analysis Services Deployment - 1 views

Automating build of Analysis Services Projects As you may be aware, an Analysis Services project consists of the following files: A project file (*.dwProj) One or more Data sources (*.ds) One or...

SQL Server Analysis Services Management

started by Sergey Leifer on 29 Aug 10 no follow-up yet
Sergey Leifer

T-SQL: disk free space alert - 0 views

SQL Server T-SQL Monitoring Management

started by Sergey Leifer on 29 Aug 10 no follow-up yet
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
Sergey Leifer

Input Note - 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

started by Sergey Leifer on 21 Sep 10 no follow-up yet
Sergey Leifer

Rename Server Name for SQL Server Cluster | JohnSterrett.com - 0 views

johnsterrett.com/...er-name-for-sql-server-cluster

Sql Server Management

shared by Sergey Leifer on 03 May 11 - No Cached
  • Sergey Leifer on 03 May 11
     
    Rename Server Name for SQL Server Cluster
1 - 20 of 20
Showing 20▼ items per page