Syndicated Blogs - Ana's Blog

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	Syndicated Blogs

Upload Image

Close it

Select File

Blog about SQL Server and related technologies.


	Like

Invite Friends

Browse by Tags · View All

SQL Server	20
Database Administration	12
TSQL	10
Denali	10
SQLServer Denali	9
SQL Server 2012	8
#SQLServer	7
SQLServer 2012	6
PowerShell	4
Performance	4

Archive · View All

August 2011	6
September 2011	4
October 2011	3
November 2011	3
February 2013	2
January 2013	2
December 2011	2
January 2012	2
April 2013	1
November 2012	1

Ana's Blog

Home · Most Liked · Most Discussed · Fans (41) · Preferences

1
Liked

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) – Part 2

In my last post, SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) I showed how to use sort_warning event with sql_text action to detect sort warnings in database with statements sent to SQL server instance. We also saw that using sql_text action we know what stored ......

Ana Posted on Dec 7 2011 12:00AM
Profile

0
Liked

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event)

Sort warnings events will rise when sort operation is performed in a query and it doesn’t fit into memory. In this case, SQL Server needs to spill the sort operation into tempdb which can result in a very slow physical operation especially if multiple passes to tempdb is needed for sorting the......

Ana Posted on Dec 5 2011 12:00AM
Profile

1
Liked

UPDATE STATISTICS: How to cheat the optimizer

Did you ever need to see what execution plan will optimizer choose for your query on large set of data but you have a really small test database? Or you are testing your notification system for sort warning, for example, and you need to force query optimizer to think that tables used in a query are ......

Ana Posted on Oct 10 2011 12:00AM
Profile

5
Liked

4
Comments

SQL Server Denali: New warnings in Actual Execution Plan

I’ve played with SQL Server Denali and found some new features and improvements in Query Execution plan. My intention was to test Extended Events and new events: sort_warning and hash_warnig. In SQL Server 2008R2, we can create SQL Trace to capture sort and hash warnings but there is no easy w......

Ana Posted on Sep 29 2011 12:00AM
Profile