Articles Posted in the " SQL Server " Category



  • Reading All Available SQL Error logs

    Reading All Available SQL Error logs

    There are many blog posts available online about reading SQL Server Error Log or SQL Server Agent Error Log. What I needed was to search for a string (or string within a string) in all available error logs. Save the results in a table. That way I can find the frequency and pattern of the occurrence. I am also aware that PowerShell commands can read error logs and there are few posts available online for doing that. I did not find one with everything I needed. I wrote 2 versions of this, one as a stored procedure that you can …


  • Extended Event duration Millisecond or Microsecond?

    Extended Event duration Millisecond or Microsecond?

    There was a question in dba.stackexchange.com titled “module_end extended events duration in microseconds?” that I answered and it was Microsecond in that instance.
    Later on I questioned myself if the duration is always in Microseconds for extended events. I found, it is a mix of Millisecond, Microsecond and some are unknown meaning famous NULL. I wrote below tsql code to determine which is what.

    SELECT p.name package_name,
           o.name event_name,
           c.name event_field,
           DurationUnit= CASE
                             WHEN c.description LIKE '%milli%' 
                             THEN SUBSTRING(c.description, CHARINDEX('milli', c.description),12)
                             WHEN c.description LIKE '%micro%' 
                             THEN SUBSTRING(c.description, CHARINDEX('micro', c.description),12)
                             ELSE NULL
                         END,
           c.type_name field_type,
           c.column_type column_type
    FROM sys.dm_xe_objects o
    JOIN 

  • TSQL to Find Status of SQL Server Statistics

    TSQL to Find Status of SQL Server Statistics

    About two years ago, I was working on an update statistics solution for 15 TB OLTP database.   First thing I needed to know, is the status of statistics.   With a google search I landed into this blog post by Erin Stellato (blog | Twitter) from SQLskills. Which gave me a perfect head start.

    I expanded that query to add more things in the result set.

    • Separate column for schema and object name.
    • Statistics ID.
    • Is this a temporary statistics (more here) ?
    • Column names (I wanted one row per statistics even with more than one column).
    • Ability