Muller Jannie

About myself and everyone else.

Monthly Archives: August, 2018

Ghost Writer (Book Idea)

Story The plot is that a regular Joe gets a ghost writer to write a basic story. The backdrop of the story is a romance in a military camp. When … Continue reading

August 17, 2018 · Leave a comment

DBA Ramblings from 2013

DBA In training My IT career started when I joined a small IT firm that developed web based applications. The applications were written like most other applications in at the … Continue reading

August 17, 2018 · Leave a comment

Sweetness

brix-chart

August 17, 2018 · Leave a comment

All About bees

 

August 17, 2018 · Leave a comment

Plant Guides

Poster_GDN_Com_Plant

August 17, 2018 · Leave a comment

Alternative Spend and Save

Based on personal experience and a good amount of watching TED and other youtube bits I want to explain the why. I have done my budgeting in excel for as … Continue reading

August 17, 2018 · Leave a comment

Get out of date stats

SELECT DISTINCT SCHEMA_NAME(so.schema_id) AS ‘SchemaName’, OBJECT_NAME(so.object_id) AS ‘TableName’,so.object_id AS ‘object_id’,CASE OBJECTPROPERTY(MAX(so.object_id), ‘TableHasClustIndex’) WHEN 1 THEN ‘Clustered’ WHEN 0 THEN ‘Heap’ ELSE ‘Indexed View’ END AS ‘ClusteredHeap’,CASE objectproperty(max(so.object_id), ‘TableHasClustIndex’) WHEN 0 … Continue reading

August 17, 2018 · Leave a comment

Disk Usage with HADR

if object_id(‘tempdb..##DiskUsage’) is not null drop table tempdb..##DiskUsage Create table ##DiskUsage ( databasename varchar(256), filegroupname varchar(56), physical_name varchar(256), [filename] varchar(256), datafilesizemb int, datausedsizemb int, datafilefreemb int, diskcapacitymb int, diskfreespacemb int, … Continue reading

August 17, 2018 · Leave a comment

Index Operational Info

Select @@servername as servername, db_name() as databasename, object_name(b.object_id,db_id()) as objectname, object_schema_name(b.object_id,db_id()) as schemaname, isnull(b.name,’HEAP’) as indexname, isnull(user_seeks,0) as user_seeks, isnull(user_scans,0) as user_scans, isnull(user_lookups,0) as user_lookups, isnull(user_updates,0) as user_updates, d.rows, d.data_compression_desc, … Continue reading

August 17, 2018 · Leave a comment

Database FileSize

with recent_DatabaseFileSize as ( select rank() over(partition by databaseid order by snapshotdate desc ) as recent,* from snapshot.DatabaseFileSize WITH (NOLOCK)), Growth_On_Disk as ( select a.name, a.label, min(a.used – b.used) as … Continue reading

August 17, 2018 · Leave a comment
Advertisements