Lowell, I'm a bit confused. The map you posted kind of shows that datetime2 also has...

Yes, but as written you'll get NULL because @CaptureError and @Date are nulls. Assign some values and test it.

Explicitly convert @Date to CHAR or VARCHAR.

You are comparing strings, not numbers.

'1000205830'

'1000206'

'1000206010'

I hear you, it's tempting to think that it will negate 5 rows selected by a = 1 or b = 1 and return the other 4. But in fact,...

not (a = 1 or b = 1) is equivalent to a <> 1 and b <> 1 which is only True for the row where both a and b...

Maybe OP re-creating index, not rebuilding it? Last sentence ("i have application which drops indexes") kind of implies that?

Can't you use RIGHT or SUBSTRING ?

DECLARE @BufferPoolDescription VARCHAR(60);
DECLARE @BufferPoolSizeMB VARCHAR(60); --BIGINT?

EXECUTE sp_executesql  N'SELECT @p1 = state_description,  @p2 = (current_size_in_kb / 1024) FROM sys.dm_os_buffer_pool_extension_configuration',
       ...

Why not use TABLESAMPLE?

SELECT * FROM YourTable TABLESAMPLE(100 ROWS)
SELECT * FROM YourTable TABLESAMPLE(10 PERCENT)

You do realize that this is not an Oracle forum, right? Simple Google search for Oracle forums should get you to the right place, for example:

https://community.oracle.com/community/groundbreakers/database/developer-tools/sql_and_pl_sql

When I'm looking for text in procedures I usually query sys.sql_modules view, something like this:

 SELECT 
   o.object_id
  ,SchemaName = s.name
  ,ObjectName =...

Sample calls from function comment. The last one works but 4 prior produce that error.

Thanks Jonathan, nice function. Which versions of SQL Server it will work with? It doesn't seem to work on 2008R2. I replaced IIF with CASE but now getting this:

            
August 21, 2019 at 3:48 pm
            
#3673170

            
            
                                                
        

Is UPDATE statement being dynamically constructed? If so, print it out and see if it's correct.