Tags » SQL Server

SQL Operations Studio - Initial Thoughts

I have used SQL Server Management Studio (SSMS) for years.  I never really thought of it as a bad IDE per say.  It offered many improvements over its predecessor “SQL Server Enterprise Manager” for those who remember. 348 more words

SQL Server

Logging Exception in Database using Microsoft Enterprise Library 6.0

In this post, we will discuss about how to use Enterprise Library Logging Application block in our asp.net application to log exceptions inside database (SQL Server). 346 more words

File Grow

It’s important to monitor the file grow. Due to database activity, your files will accumulate records and this will trigger a grow. Now disk space is not expensive , never the less, you need to know when you are close to the limits of your disk space. 982 more words

Miscellaneous

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 turn of the year 2000 in good old asp, VB scripting and SQL server. 7,421 more words

SQL Server

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 THEN count(si.index_id) – 1 ELSE count(si.index_id) END AS ‘IndexCount’, MAX(d.ColumnCount) AS ‘ColumnCount’,MAX(s.StatCount) AS ‘StatCount’,MAX(dmv.rows) AS ‘ApproximateRows’,MAX(dmv.rowmodctr) AS ‘RowModCtr’ 164 more words

SQL Server

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),
varchar(256),
datafilesizemb int,
datausedsizemb int,
datafilefreemb int, 287 more words

SQL Server