I found this blog about using MS SQL Profile to help locate issues in large complex stored proc’s.
Well with a read and bookmark
We’ve all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they’re so complex and have so many logic offshoots that it’s very easy to get lost when you’re trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code. I found it very useful to use custom events and a database snapshot to debug some code recently and we’ll explore both in this article. I find raising these events and running Profiler to be very useful for testing my stored procedures on my own as well as when my code is going through official testing and user acceptance. It’s a simple approach and a great way to catch any performance problems or logic errors.
SQL Team Mike Femenella
The Dark Art of Performance Tuning
Despite all of the enhancements to the instrumentation in SQL Server 2008, many database professionals still view performance tuning as a dark art.
In this session Peter Ward (SQL Server MVP) from WARDY IT Solutions (www.wardyit.com) will provide database administrators and developers with valuable information on SQL Server performance tuning concepts.
This presentation will walk you through proven performance tuning strategies and teach you how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements.
Location
Microsoft
Level 5
22 Viaduct Harbour Ave
Auckland CBD
Date / Time
Monday, July 20th
Food and Drink kindly provided by SQL Services Ltd will be available from 5:30pm
Presentation will kick off around 6pm.
If you arrive after the doors have locked, please call on 027-323-4670
More info and registration: http://aucklandsql.com/Meetings/Peter-Ward-(SQL-MVP).aspx
Microsoft has updated there SQL Books Online (BOL)
You will get it with the update service or download from Microsoft
I found a very nice SQL article by Susan Harkins giving 10 tips for the beginner in SQL
Among the questions answered are:-
- Working with Jet SQL in the Access SQL window
- Words reserved by SQL
- The difference between ALL, DISTINCT and DISTINCTROW
To read the full blog entry go to
Excellent article by Pinalkumar Dave detailing the 3 languages of BI
MDX – Multidimensional Expressions. This language is used for retrieving data from SSAS cubes. It looks very similar to T-SQL, but it is very different in the areas of conceptualization and implementations.
DMX – Data Mining Extensions. This is again used for SSAS but rather than cubes it is used for data mining structures. This language is more complicated than MDX. Microsoft has provided lots of wizards in its BI tools, which further reduced experts for learning this language which deals with data mining structures.
XMLA – XML for Analysis. This is mainly used for SSAS administrative tasks. It is quite commonly used in administration tasks such as backup or restore database, copy and move database or learning meta data information. Again, MS BI tools provide lots of wizards for the same.
The complete article can be found on Dave’s Blog
