Home
Feedback
Site Map
SQL Server
T/SQL Functions
ISO Weekday Number
ISO Week Number
Parse ISO 8601 DateTime
Random Numbers
Haversine Formula
Convert Hex String to VarBinary
DateSerial
Trim Whitespace
UnQuote Name
LOG Any Base
T/SQL Scripts
Quick Row Counts
Check Identity Capacity
Sources for Metadata and Operational Info
DMVs
sysprocesses
sys.databases
sys.database_files
sys.dm_db_partition_stats
sys.dm_exec_cached_plans
sys.dm_exec_connections
sys.dm_exec_query_stats
sys.dm_exec_requests
sys.dm_exec_sessions
sys.dm_io_virtual_file_stats
sys.dm_io_pending_io_requests
sys.dm_os_buffer_descriptors
sys.dm_os_latch_stats
sys.dm_os_sys_info
sys.dm_os_wait_stats
sys.master_files
Statistics
Using the Default Trace
Things You Might Not Know
Avg(x) Fails When Sum(x) Overflows an Int
Statistics are not transactional
sp_updatestats Does Not Update Indexed View Stats
DotNetNuke
SQL Scripts
Find and Fix Tab Levels and TabPaths
Find and Fix Missing Tab ContentItemIds
Find Duplicate TabOrders
Find Skin and Container Usage
Everything Else
English Bank Holidays
Investment Bank Risk Analytics
Investment Banking Products
My Software
Simonish
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
ISO Weekday Number
ISO Week Number
Parse ISO 8601 DateTime
Random Numbers
Haversine Formula
Convert Hex String to VarBinary
DateSerial
Trim Whitespace
UnQuote Name
LOG Any Base
T/SQL Scripts
Quick Row Counts
Check Identity Capacity
Sources for Metadata and Operational Info
DMVs
sysprocesses
sys.databases
sys.database_files
sys.dm_db_partition_stats
sys.dm_exec_cached_plans
sys.dm_exec_connections
sys.dm_exec_query_stats
sys.dm_exec_requests
sys.dm_exec_sessions
sys.dm_io_virtual_file_stats
sys.dm_io_pending_io_requests
sys.dm_os_buffer_descriptors
sys.dm_os_latch_stats
sys.dm_os_sys_info
sys.dm_os_wait_stats
sys.master_files
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
Find and Fix Tab Levels and TabPaths
Find and Fix Missing Tab ContentItemIds
Find Duplicate TabOrders
Find Skin and Container Usage
Everything Else
English Bank Holidays
- The definitive list of English Bank Holiday dates from 1990 through to 2019.
Investment Bank Risk Analytics
Investment Banking Products
My Software
- The software that I use day in day out.
Simonish
Feedback
|
Login
Copyright 2007-2020 RMJCS