Skip to main content

Home/ Groups/ MS SQL Server and Analysis Services
Rss Feed
Sort By: Most Recent | Popular 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

Fundamentals of Storage Systems, IO Latency and SQL Server - 1 views

www.sqlservercentral.com/...io-latency-and-sql-server.aspx

SQL Server Performance

shared by Sergey Leifer on 06 Mar 11 - No Cached
  • Sergey Leifer on 06 Mar 11
     
    Fundamentals of Storage Systems, IO Latency and SQL Server
Sergey Leifer

SSAS performance counters - 0 views

SQL Server Analysis Services Monitoring

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

MSOLAP Service Crashes Once a Day - Windows Low Fragmentation Heap vs OLAP Heap - 0 views

jesseorosz.spaces.live.com/...cns!E322FD91218E57CF!295.entry

SQL Server Analysis Services

shared by Sergey Leifer on 11 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    OLAP Heap isn't an stable as Windows, especially if you have a large OLAP database (we're 500GB and I guess that's considered large)...
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

SSAS performance counters - 0 views

SSAS performance counters * Direct hit ratio - Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. Higher is better. * Evictions / sec - Rate of evictio...

SQL Server Analysis Services

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

SSAS performance counters - 0 views

SSAS performance counters * Direct hit ratio - Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. Higher is better. * Evictions / sec - Rate of evictio...

SQL Server Analysis Services Monitoring

started by Sergey Leifer on 02 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

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

Data Type Mapping - 0 views

www.carlprothman.net/Default.aspx

SQL Server SSIS

shared by Sergey Leifer on 05 Oct 10 - Cached
  • Sergey Leifer on 05 Oct 10
     
    ADO Data Type mapping between Visual Basic, Access, SQL Server, Oracle, and the .NET Framework.
Sergey Leifer

How to: Connect to the Database Engine Using sqlcmd.exe - 0 views

msdn.microsoft.com/...ms188247.aspx

SQL Server

shared by Sergey Leifer on 15 Feb 11 - No Cached
  • Sergey Leifer on 15 Feb 11
     
    How to: Connect to the Database Engine Using sqlcmd.exe
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
Sergey Leifer

Simple vs Searched CASE statements-SSAS - 0 views

www.ssas-info.com/...le-vs-searched-case-statements

SQL Server Performance T-SQL

shared by Sergey Leifer on 03 May 11 - No Cached
  • Sergey Leifer on 03 May 11
     
    Simple vs Searched CASE statements
Sergey Leifer

Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks" - Bart Duncan... - 1 views

blogs.msdn.com/...parallel-thread-deadlocks.aspx

SQL Server Monitoring

shared by Sergey Leifer on 11 Jul 11 - No Cached
  • Sergey Leifer on 11 Jul 11
     
    Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"
Sergey Leifer

Security Checklists - 0 views

iase.disa.mil/checklist

Security

shared by Sergey Leifer on 09 Aug 10 - Cached
  • Sergey Leifer on 09 Aug 10
     
    Security checklists for different products
Sergey Leifer

SQLDiag for SQL Server 2005 - 0 views

www.virtualobjectives.com.au/...sqldiag_2005.htm

SQL Server Monitoring

shared by Sergey Leifer on 07 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    This article explains how to use SQLDiag as a Service to get more thorough diagnostics than the standard Profiler traces or Server Side Tracing...
Sergey Leifer

T-SQL: list files in folder - 1 views

create table #Files ( FullName nvarchar(255) null ) insert #Files exec master..xp_cmdshell 'DIR C:*.csv /B /S' select right(FullName, patindex('%%', reverse(FullName)) - 1) as ShortFileName ...

SQL Server T-SQL

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

T-SQL: disk free space alert - 0 views

USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Disk Free Space on Drive E', @message_id=0, @severity=0, @enabled=1, @delay_between_responses=0, @include_event_description_in=0, ...

SQL Server T-SQL

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

T-SQL: last day of the month, round dates - 0 views

SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))

SQL Server T-SQL

started by Sergey Leifer on 07 Aug 10 no follow-up yet
1 - 20 Next › Last »
Showing 20▼ items per page