dmlogv

/*
Get table row count

See code comments.
See http://blogs.msdn.com/b/martijnh/archive/2010/07/15/sql-server-how-to-quickly-retrieve-accurate-row-count-for-table.aspx


Args:
    @table      NVARCHAR(1000) ,  -- Table name (include DB: 'Northwind..tEmployee').
    @row_count  BIGINT OUTPUT  ,  -- Output result (see example).

dmlogv

/*
Converts SQL Server Agent Time to Time
*/
CREATE FUNCTION dbo.fnc_agentTimeToTime (
	@agent_date INT
)
RETURNS TIME(0)
AS
BEGIN
    DECLARE @result TIME(0);

dmlogv

/*
Split a string by delimiter and return substrings

    
Args:
    @string      NVARCHAR(max),
    @delimeter   NVARCHAR(100) = ''
  
Returns:
    TABLE 

dmlogv

/*
Counts a number of substrings in the given string

    
Args:
    @string  
    @substring 
  
Returns:
    INT

dmlogv

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout]
"Scancode Map"=hex:00,00,00,00,00,00,00,00,02,00,00,00,1d,00,3a,00,00,00,00,00

dmlogv

/*
Get date interval

Find days of week interval including @date.

Args:
    @date   -- Date to find interval
    @first  -- Interval start (day of week number where 1 is Mon, 7 is Sun)
    @last   -- Interval start (day of week number where 1 is Mon, 7 is Sun)

dmlogv

/*
Slow method

Pre-use my integer's table: https://gist.github.com/dm-logv/38eb66f5a2a461cb8f42e14714682daa
*/
SELECT TOP 1 i
FROM #integers
ORDER BY NEWID();

dmlogv

/*
Result values table
    
You could change it to permanent table like s/#integers/dbo.Integers/g    
*/
DROP TABLE IF EXISTS #integers;

CREATE TABLE #integers ( 
    i  INT NOT NULL PRIMARY KEY
);