I am a SQL server DBA, MCITP-DBA certified, etc. and still learning about MSSQL every day. I may not say anything new in this entire blog, but I will share stuff as I discover it.
I went to Madison SQLSaturday #287 and also the precon on SQL Tuning. I am mostly an admin and not a developer or regular TSQL writer but tuning SQL sounds like fun ... here is where you start:
Set Statistics IO On
This little line at the top of your query will provide messages about how many logical reads each part of your SQL creates. check this for more: http://technet.microsoft.com/en-us/library/ms184361.aspx
Brent Ozar added - why use the mythical bicycle manufacturing database when you can use Stack Overflow's live database? And of course admonished us to BE CREEPY. If I could only remember what that accrostic was ... I did write it down and I'll share it soon.
For tomorrow, WISSUG is hosting one of Brent's colleague's and speaker at the precon - Jes Borland. She will be expanding our understanding of indexes in SQL. You can catch us every second Tuesday at Microsoft's location in Waukesha, WI at 4:30-6:00pm.
