SQL DBA Interview question no 5: "What are the possible values of log_reuse_wait_desc in SQL Server, and how do you troubleshoot and resolve each to allow transaction log truncation and shrinking?" ...
I help maintain the ODBC driver for IBM i and we have a question regarding SQLColumnAttribute getting SQL_DESC_OCTET_LENGTH when it comes to multibyte encodings. There are many code pages on IBM i ...
SQLColAttribute() function always returns SQL_DESC_OCTET_LENGTH only for two-byte encoding (ex. UTF-16). If iconv is used for the on-fly conversion (ex. ClientCharset = UTF-8) SQLColAttribute() should ...
SQLHANDLE InputHandle input Existing handle to use as a context for the new handle being allocated. If HandleType is SQL_HANDLE_ENV, this is SQL_NULL_HANDLE. If HandleType is SQL_HANDLE_DBC, this must ...
The SQL Circle: Master These Essentials (Bookmark this if you’re learning SQL) Order & Sorting ↳ ORDER BY ASC – Sort in ascending order ↳ ORDER BY DESC – Sort in descending order Joins ↳ INNER JOIN – ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results