Full-Text catalog properties - SQL Server

Recently I have been working with the Wiki project – just to prove that my desktop PC can be as fast as Windows Azure in hosting and searching through the entire Wiki content.

In order to do that I created a local database which contains all wikipedia articles in XML format and it uses XML indexing

Continue reading […] Full-Text catalog properties – SQL Server […]

 

Simple T-SQL Proper Case User-Defined Function

Today I found a nice ol’ post about Simple T-SQL Proper Case User-Defined Function

What this function does, it takes a string and makes the words a proper case.

Here is the script:

 

?View Code TSQLALTER FUNCTION [dbo].[f_ProperCase] ( @Text AS VARCHAR(512) )
RETURNS VARCHAR(512)
AS
BEGIN
DECLARE @Reset

Continue reading […] Simple T-SQL Proper Case User-Defined Function […]

 

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 bytes of the blocks in this storage extent.
DirtyBitSet –

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