Derek Seaman's Blog: SQL 2008 R2: Unattended Install Script (Part 2) - 0 views
SSAS Partition Slicing - 0 views
How to reduce paging of buffer pool memory in the 64-bit version of SQL Server - 1 views
-
... 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...
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...
T-SQL: disk free space alert - 0 views
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...
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...
1 - 20 of 20
Showing 20▼ items per page