RMJCS Site Map

Home
- Feedback - Contact details and a feedback form.
- Site Map - A full site map for www.rmjcs.com.
SQL Server
- T/SQL Functions
- T/SQL Scripts
  - Quick Row Counts
  - Check Identity Capacity
- 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.
DotNetNuke - A brief introduction to the open source web application framework.
- SQL Scripts
Everything Else
- English Bank Holidays - The definitive list of English Bank Holiday dates from 1990 through to 2019.
- Investment Bank Risk Analytics
- My Software - The software that I use day in day out.
- Simonish

Feedback |

Login

Copyright 2007-2020 RMJCS