Determine the size of database tables in a MSSQL Server Database. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
Original Source Link 1234567891011121314151617181920212223242526272829303132COLUMN TABLE_NAME FORMAT A32 COLUMN OBJECT_NAME FORMAT A32 COLUMN OWNER FORMAT A10 SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE …
12345678static public string ConvertToText(string rtf) { using(RichTextBox rtb = new RichTextBox()) { rtb.Rtf = rtf; return rtb.Text; } } Catch ArgumentException …
Determine if a decimal number can be converted to an INT without any loss of precision. Check if either of the rightmost two digits are non-zero 123substring(convert(varchar(10), a.DebitAmount), len(convert(varchar(10), a.DebitAmount)) …
1234567891011121314151617Declare @Table_Name VarChar(100) ,@Column_Name VarChar(100) Set @Table_Name = ” Set @Column_Name = ” Select RowNumber = Row_Number() Over( PARTITION BY T.[Name] Order By T.[Name],C.column_id ), SCHEMA_NAME( T.schema_id ) As SchemaName …
Problem: When doing a php page load IIS gives the error 1Handler "PHP_via_FastCGI" has a bad module "FastCgiModule" in its module list Solution: Ensure that the CGI module to Internet …
Ensure the user has permission 123USE master; GRANT VIEW SERVER STATE TO username; GO Select from view sys.dm_os_sys_info 1select * from sys.dm_os_sys_info
Telnet and manually post the http get request \> telnet localhost 80 12GET /index.htm HTTP/1.1 host: localhost
Determine your Powershell exectuion policy 1Get-ExecutionPolicy Change your Powershell exectuion policy if restricted 1Set-ExecutionPolicy RemoteSigned Script to get system downtime 1234567891011121314151617181920212223242526272829303132333435363738[timespan]$downTime = New-TimeSpan -start 0 -end 0 [timespan]$totalDownTime = New-TimeSpan …
