Wednesday, 10 March 2010

RMJCS Site Map

Home
- What's New - What's been added or updated on this site recently.
- Feedback - Contact details and a feedback form.
- Site Map - A full site map for www.rmjcs.com.
SQL Server
- T/SQL Functions
- Sources for Metadata and Operational Info
- DMVs
- Statistics
- Using the Default Trace
- Things You Might Not Know
  - Avg(x) Fails When Sum(x) Overflows an Int - If Sum(x) exceeds the range of an int then Avg(x) will fail.
  - Statistics are not transactional - Updated stats do not get undone as part of a rolled back transaction.
  - sp_updatestats Does Not Update Indexed View Stats - Stats on indexed views might need extra maintenance.
Everything Else
- English Bank Holidays - The definitive list of English Bank Holiday dates from 1990 through to 2010.
- My Software - The software that I use day in day out.
- DotNetNuke - A brief introduction to the open source web application framework.

Feedback | Site Map | Top | Login

Copyright 2007-2010 RMJCS Ltd