Directions EMEA 2010 – NAV/SQL Performance: Indexes

Directions EMEA 2010 from 19th to 21st May 2010 in Prague/CZ.
Website: http://www.directionsemea.com/

Well, actually this is not some new stuff, actually the presentation is quite similar (but stronger focus on indexes) than this one:
http://dynamicsuser.net/blogs/stryk/archive/2010/02/10/technical-airlift-2009-munich-nav-sql-performance-optimization-indexes.aspx

The scripts & templates (attached) have been improved.

ALL SCRIPTS, TEMPLATES ETC. ARE PROVIDED "AS IS". NO WARRANTY, NO GUARANTEE, NO SUPPORT. USE AT OWN RISK.


Let the show begin ...


During the presentation: disrupting "Yellow Pages" to demo a "heap"

 
After the session: chat with Erik and Rene (who took the picture)

(Pictures courtesy of Rene Gayer - thanks a lot Big Smile)

Posted: May 20, 2010 11:00 by Jörg A. Stryk | with 4 comment(s) |
Filed under: , , , , ,
Bookmark and Share

Comments

# re: Directions EMEA 2010 – NAV/SQL Performance: Indexes

great presentation. thanks!

(with full use of physical play - even killed a copy of the yellow pages)

Thursday, May 20, 2010 12:28 PM by jr

# Directions EMEA 2010: SQL Server Tips & Tricks - Indexes

A session presented by a fellow-MVP:Jörg Stryk. The guy is unbelievable into SQL Server and SQL Server

Friday, May 21, 2010 8:14 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# re: Directions EMEA 2010 – NAV/SQL Performance: Indexes

Ups ... I just realized:

In the script "Directions2010_IndexDefragmentation.sql" the part "EXEC (@command);" was commented out.

So please replace this line ...

--EXEC (@command);

... with this one:

EXEC (@command);

Sorry! (the attached script to this BLOG was updated now)

Saturday, May 22, 2010 9:49 AM by Jörg A. Stryk

# re: Directions EMEA 2010 – NAV/SQL Performance: Indexes

Just received some pictures from Rene which I added to the article ;c)

Thanks a lot Rene!

Friday, June 04, 2010 11:04 AM by Jörg A. Stryk

Leave a Comment

(required) 
(required) 
(optional)
(required)