I liked the spirit of hte workshop.
I enjoyed few sessiosn owith real technical inputs and tips. SOme of them I could use in my work situation.
The crowd was loud and distracted by the t-shirts and books being given away...
Will I go next year ? - well probably yes , because there are no other better events in this area....
------------------------------------------------
Andy Warren:
Statistics ----
ASYNC update is recommended if hte stats are getting updated frequently and are heavily used. This way day time response times are not affected.
DOes a full scan 100% sampling
in SQL2k5 , it updates only that needs updating ( 500 updates or 10% of the total )
Always look at the query plan:
With recompile
keep plan
keep fixed plan
optimize for ( 'smith')
Lookat querystats.aspx.
============================
Confio software.
Ex-Oracle guru...Dean Richards
Highest wait times ( Wait types)
Tracing a sessions / process)
User / Batch complaints
Queries performing most I/O - LIO , PIO
Queries consuming CPU
Queries doing full table scans.
known poorly performing SQL
reference - KB822011 - sysprocesses
DMV - dm_exec_query_plan
or profiles event : under Misc: - execution plan
Consider: ERD - Entity Relationship Diagram
DAta Profiler Viewer...
Dan Tow : http://singingsql.com
Book bby him : SQL Tuning ----
-------------------------------------------------------
Chris Eagle:
Reastful DAta
http://www.kodefuguru.com
C R U D ? .... create retrieve update delete.
insert select update delete
post get put delte in HTTP
whistle ????? / $metadata
--------------------------------------------
1. Atomicity - of data
2. Definition of Primary Key
3. Dependency on the primary key
Extremely under-normalized
extrmeley over normalized.
EAV - Entity Attribute Value - this is bad...
big buckets of stuff....
performance considerations ...
metabase - custom database with cross linked to other databases with nesting views ... avoid them if you can since the query optimizer can go nuts ....
Segment the ETL process - where ever you can...
Parsing before deployment.
==============================================================
Brad Marshall - Fuzzy warm SSIS:
Demo on the fuzzy logic.
not very impressive because , the algorithms used for sorting with realtrive weights is not revealed and so not very amenable for tweaking. Waht you see is what you get pretty much.
Fuzzy grouping ; ETRI - error Tolerance Index,
If you want to process it faster, keep simlarity to closer to 1 then it will run faster.
one of the neat features of the new SSIS thingy is the Data Viewer. This give you hte ability to see the results of the fuzzy grouyping you have run recently.
That way, you can always go back and tewak it some more and see if hte results are closer to your expectations and other wise tewak some more kinda routine....
=============================
Paul Randall - He wrote teh DBCC routine on SQL Server.
Tera DAta will scal to several 100 million rows easily.
Power shell.
look at inlude (columns) in the query plans for perfomrance hints.
====================
Sunday, July 12, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment