|
||||||
 |
RIL_button( “http://sqlconcept.com/2012/12/29/full-text-catalog-properties-sql-server/”, “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 Continue reading [...] Full-Text catalog properties – SQL Server [...]  (3 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 ...
RIL_button( “http://sqlconcept.com/2012/12/10/simple-t-sql-proper-case-user-defined-function/”, “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) ) Continue reading [...] Simple T-SQL Proper Case User-Defined Function [...] (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 ...
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) Continue reading [...] Disk and mount points space and properties [...] (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 ...
|
|
||||
|
Copyright © 2013 sqlconcept.com - All Rights Reserved Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. ) |
||||||
