Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-5f962d187227e952395168/] Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be used in above query. …
Read More »Saumya Maurya
Hash Functions to Identify Skewed Data
On day to day activity we often get situation when the database has a lot of space left but query fails with “2644: No more room in database”. If …
Read More »