Best content in MS SQL Server and Analysis Services

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

<div class="cArrow"> </div><div class="cContentInner">Fundamentals of Storage Systems, IO Latency and SQL Server</div>

...

Cancel

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...

<div class="cArrow"> </div><div class="cContentInner">... 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...</div>

...

Cancel

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

<div class="cArrow"> </div><div class="cContentInner">Rename Server Name for SQL Server Cluster</div>

...

Cancel

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

<div class="cArrow"> </div><div class="cContentInner">Simple vs Searched CASE statements </div>

...

Cancel

A closer look at CXPACKET wait type in SQL Server - 0 views

www.mssqltips.com/tip.asp

SQL Server Monitoring

shared by Sergey Leifer on 07 Aug 10 - Cached

Sergey Leifer on 31 Aug 10

If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits...

<div class="cArrow"> </div><div class="cContentInner">If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits...</div>

...

Cancel

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...

<div class="cArrow"> </div><div class="cContentInner">This article explains how to use SQLDiag as a Service to get more thorough diagnostics than the standard Profiler traces or Server Side Tracing...</div>

...

Cancel

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)...

<div class="cArrow"> </div><div class="cContentInner">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)...</div>

...

Cancel

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"

<div class="cArrow"> </div><div class="cContentInner">Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"</div>

...

Cancel

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

<div class="cArrow"> </div><div class="cContentInner">How to: Connect to the Database Engine Using sqlcmd.exe</div>

...

Cancel

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.

<div class="cArrow"> </div><div class="cContentInner">ADO Data Type mapping between Visual Basic, Access, SQL Server, Oracle, and the .NET Framework.</div>

...

Cancel

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

<div class="cArrow"> </div><div class="cContentInner">Security checklists for different products</div>

...

Cancel