Compute fiscal years and quarters from an April start, build indexed date boundaries, and store a fiscal calendar for repeatable reports.
SQLAuthority News – Community Service and Public Speaking Engagements
On the last day of 2010 I look back at my community service and public speaking engagements: TechEds, PASS, Virtual Tech Days and many community events.
SQL SERVER – Detect Virtual Log Files (VLF) in LDF
A large LDF file is made of many small Virtual Log Files (VLFs). Here is how to detect them with DBCC LOGINFO and see which ones are active.
.jpg)
SQLAuthority News – My Evaluation of Singapore SharePoint Conference
My feedback from the Singapore SharePoint Conference, where I was the only SQL speaker: very high ratings, and my demo was called one of the best of the event.
SQL SERVER – Plan Cache and Data Cache in Memory
Two scripts I share with clients all the time: they show the plan cache and data cache in memory, with cached plans by size and cached pages by table.
SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber
I strongly favor ORDER BY ColumnName over ORDER BY ColumnNumber. The performance is the same, but here is why column numbers are risky in real code.
SQL SERVER – Server Side Paging in SQL Server Denali – Part2
Part 2 of server side paging in SQL Server Denali: a reader keeps rows per page and page number in a table, and OFFSET and FETCH can read them from there.