Computers

Expand VMWare Drive Image

These instructions assume we have a Windows Server called “vm1” that we need to expand the “c” drive. 1). Remove any snapshots from vm1. This method will not work with …

Computers

Datetime variables TSQL

Syntax for a TSQL date time variable 1234567DECLARE @START_DATE DATETIME DECLARE @END_DATE DATETIME SET @START_DATE = ’09/21/2012 00:00:00′ SET @END_DATE = ’09/21/2012 23:59:59′ SELECT * FROM TABLE WHERE POSTINGDATE >= …

Computers

Select Tables with Row Count

TSQL 123456–all tables and rowcount (in descending order by count) select ‘[‘+SCHEMA_NAME(t.[SCHEMA_ID])+’].[‘+t.NAME+’]’ AS [fulltable_name], SCHEMA_NAME(t.[SCHEMA_ID]) as [schema_name],t.NAME as [table_name] ,i.rows from sys.tables t INNER JOIN sysindexes i ON (t.object_id = …

Programming

Sort Array by Date C#

Sort an array of objects by date Given the class below: 1234567891011121314    public class MyClass     {         public int id;         …