Disk and mount points space and properties

RIL_button( “http://sqlconcept.com/2012/02/23/disk-and-mount-points-space-and-properties/”, “Disk and mount points space and properties” );

Here is a piece of code which gives a good idea about the drives on your system, and also about the mountpoints.

gwmi -computername Enter_Server_Name win32_volume|where-object {$_.filesystem -match “ntfs”}|ft name,Availability,BlockSize,Compressed,DirtyBitSet,IndexingEnabled,Label,LastErrorCode,PowerManagementCapabilities,Status,@{Name=’CapacityMB’;Expression={$_.Capacity/1MB} },@{Name=’FreeSpaceMB’;Expression={$_.FreeSpace/1MB} }

Availability – describes the availability and the status of the device. (For example, Offline)
BlockSize – Size in

Continue reading [...] Disk and mount points space and properties [...]

February 23rd, 2012 | Category: Disk System, IO, Performance audit, Ramblings, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Find the second work day of the month

RIL_button( “http://sqlconcept.com/2012/02/22/find-the-second-work-day-of-the-month/”, “Find the second work day of the month” );

Just some fun with T-SQL.
Recently someone asked me to write a code which answers the question if today is the second business day of the month or not.
Here is a version of the code. If you have better ideas for doing this, feel free

Continue reading [...] Find the second work day of the month [...]

February 22nd, 2012 | Category: T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (4 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

SQL SERVER TRANSACTION ISOLATION LEVELS

RIL_button( “http://sqlconcept.com/2012/02/06/sql-server-transaction-isolation-levels/”, “SQL SERVER TRANSACTION ISOLATION LEVELS” );

SQL SERVER TRANSACTION ISOLATION LEVELS

by Mukiibi Ivan

On a busy day, our streets are given order by the traffic police, they keep the traffic flowing and they also keep motorists safe. Maximum safety can be ensured by only allowing one person to use a junction at a time.
Unfortunately, if

Continue reading [...] SQL SERVER TRANSACTION ISOLATION LEVELS [...]

February 6th, 2012 | Category: Database Objects, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (4 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...