-
Database recovery procedure for corrupted databases
Follow the following procedure to recover corrupter SQL Server database. It is assumed that database is in full recovery mode, full database backup is available and transaction log backups was taken sometime before the failure.If database has been corr…
-
Quick and simple aggregation of Hierarchical Data in SQL Server
Sometimes data containing hierarchies have to be aggregated and total calculated on different levels. The following script will help archive fast calculation of totals on each level of hierarchy.INPUT DATA STRUCTURE AND VALUES0100***Level 1*****$210110…
Toronto, Ontario, Canada
Eastern Time Zone
info@maximconsulting.ca
Month: August 2012
Archive
Categorise
- aggregation
- audit
- average
- backup
- baseline
- cell value overwrite
- certification
- compliance
- cube
- data driven subscriptions
- data export
- datetime
- de-normalize
- graph
- hierarchy
- local time
- MCSE
- MDX
- Microsoft
- parent-child
- recovery
- restore
- rounding
- script table data
- Small cell value suppression
- ssas
- ssrs
- statistical functions
- stipline
- UTC
