Non Recursive Common Table Expressions - Performance Sucks 2 - ROW_NUMBER() is executed {number of CTE references} x {number of rows from the anchor}

Posted on Mai 19, 2008 von in SQL Server
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/17/non-recursive-common-table-expressions-performance-sucks-2-row-number-is-executed-number-of-cte-references-x-number-of-rows-from-the-anchor.aspx

Non Recursive Common Table Expressions - Performance Sucks 1 - CTE Self-Join / CTE Sub Query inline expansion

Posted on Mai 19, 2008 von in SQL Server
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/17/non-recursive-common-table-expressions-performance-sucks-1-cte-self-join-cte-sub-query-inline-expansion.aspx

Query Processing Presentation

Posted on Mai 16, 2008 von in SQL Server
http://blogs.msdn.com/craigfr/archive/2008/05/15/query-processing-presentation.aspx
Tags:

How hard is it to pick the right non-clustered indexes?

Posted on May 15, 2008 by in SQL Server
http://www.sqlskills.com/blogs/paul/2008/05/14/HowHardIsItToPickTheRightNonclusteredIndexes.aspx

Execution Plan Basics

Posted on May 14, 2008 by in SQL Server
http://www.simple-talk.com/sql/performance/execution-plan-basics/

Indizes einer temporären Tabelle ermitteln

Posted on Mai 12, 2008 von in SQL Server
CREATE TABLE #t
(
	c1 int
)
GO
CREATE INDEX IX_c1 ON #t(c1)
GO
SELECT 
	[object_id], [name]
FROM 
	tempdb.sys.indexes
WHERE 
	[object_id] = OBJECT_ID('tempdb.dbo.#t') AND
	type > 0
DROP TABLE #t
GO

object_id   name  
----------- -------
389576426   IX_c1

(1 row(s) affected)
Tags:

Business Intelligence und Reporting mit Microsoft SQL Server 2005

Posted on Mai 12, 2008 von in SQL Server

Das Buch bietet einen gut strukturierten Zugang in die vielfältige Welt der Business Intelligence (BI) und liefert einen kompetenten Überblick über die BI Funktionalitäten des SQL Server 2005. Dabei reicht die Bandbreite der behandelten Themen von OLAP und Data Mining über die Integration- und Reporting- bis hin zur Programmierung der Analysis Services. Für den Einsteiger bietet das Buch fundiertes Fachwissen, das anschaulich und kompetent präsentiert wird.

Ganze Geschichte »

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Posted on May 9, 2008 by in SQL Server
http://ola.hallengren.com