http://www.ncsa.uiuc.edu/~aloftus/FibreChannel/Qlogic/config_options_2300.pdf
Execution Throttle. This setting specifies the maximum number of commands
executing on any one port. When a port’s execution throttle is reached, no new
commands are executed until the current command finishes executing. The valid
options for this setting are 1–256. The default is 16.
>4GByte Addressing. This option should be Enabled if the system has more
than 4 GB of memory available. The default is Disabled.
Monday, July 21, 2008
Sunday, July 20, 2008
Friday, July 18, 2008
Tuesday, July 15, 2008
Friday, July 11, 2008
Wednesday, July 9, 2008
Tuesday, July 8, 2008
SQL Table Ownership Changes, Quick and Easy - Scott Forsyth's Blog
SQL Table Ownership Changes, Quick and Easy - Scott Forsyth's Blog: "DECLARE @old sysname, @new sysname, @sql varchar(1000)
SELECT
@old = 'oldOwner_CHANGE_THIS'
, @new = 'dbo'
, @sql = '
IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
WHERE
QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
AND TABLE_SCHEMA = ''' + @old + '''
)
EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''
EXECUTE sp_MSforeachtable @sql"
SELECT
@old = 'oldOwner_CHANGE_THIS'
, @new = 'dbo'
, @sql = '
IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
WHERE
QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
AND TABLE_SCHEMA = ''' + @old + '''
)
EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''
EXECUTE sp_MSforeachtable @sql"
Monday, July 7, 2008
Sunday, July 6, 2008
Wednesday, July 2, 2008
Subscribe to:
Posts (Atom)