This is a continuing series for “Computing Running and Cumulative Average“. A cumulative sum (or running total) refers to a data set’s partial sum. It
Category: RDBMS
Tables Disk Consumption – SQL Server
Disk consumption is something that DBAs frequently investigate. It’s a process that checks the database’s growth and disk space use. It is often necessary to
Last Inserted Identity – MySQL & SQL Server
After inserting a row, the row identifier must be carried forward to be utilized for other related tables. When writing a batch process, such as
Frequently used Security Functions
SQL Server documentation specified the following security functions. CERTENCODED PWDCOMPARE CERTPRIVATEKEY PWDENCRYPT CURRENT_USER SCHEMA_ID DATABASE_PRINCIPAL_ID SCHEMA_NAME sys.fn_builtin_permissions SESSION_USER sys.fn_get_audit_file SUSER_ID sys.fn_my_permissions SUSER_SID HAS_PERMS_BY_NAME SUSER_SNAME IS_MEMBER
Dynamic SQL
Dynamic SQL is a programming approach that allows you to create SQL statements at runtime. Because the whole wording of an SQL statement may be
Table Variables in SQL Server
Table variables, like temp tables, are used to temporarily store data. This functions as a variable and is only present for a specific batch of
Big Data & SQL 