Back to OIM Explorer

dbo.QBM_FGIDBQueueSlotsMax

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 339 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL20 lines
1CREATE FUNCTION dbo.QBM_FGIDBQueueSlotsMax(2) RETURNS int3AS4BEGIN5  DECLARE @erg int6  DECLARE @CountProcessors float7  SELECT8    TOP 1 @CountProcessors = convert(float,9    cpu_count)10  FROM sys.dm_os_sys_info11  SELECT12    @erg = convert(int,13    (@CountProcessors + 4.0) * 1.15)14  IF @erg > 25615  BEGIN16    SELECT @erg = 25617  END18  endLabel:19  RETURN(@erg)20END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QBM_FGIDBQueueSlotsMax() returns int as begin declare @erg int declare @CountProcessors float   select top 1 @CountProcessors2 = convert(float, cpu_count) from sys.dm_os_sys_info select @erg = convert(int, (@CountProcessors + 4.0 ) * 1.15) if @erg > 256 begin select @erg = 2563 end endLabel: return(@erg) end 4