Useful tips for everyday
Does SQL Server 2019 Standard Edition support partitioning? SQL Server supports table and index partitioning. Does SQL Server 2014 Standard Edition support partitioning? Since Standard…
How many rows can Ssrs handle? 65536 rows Worksheets cannot exceed 65536 rows or 256 columns. How do you do row grouping in SSRS? To…
How does explain work in SQL? The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT , DELETE , INSERT ,…
How to select first rows in SQL Server? The following SQL statement selects the first three records from the “Customers” table (for SQL Server/MS Access):…
What is a thread cache? TCMalloc is a memory allocator designed as an alternative to the system default allocator that has the following characteristics: Fast,…
Can mirroring be done in data synchronization? Synchronous mirroring is an approach to data protection that involves data being written to a remote site and…
How do you create an alphanumeric sequence in SQL? 3 Answers. You have to create 1 sequence and 1 transforming function: CREATE SEQUENCE num_seq START…
How are relational databases stored? A relational database stores data in tables. Tables are organized into columns, and each column stores one type of data…
What happens when Transparent Data Encryption ( TDE ) is enabled? When Transparent Data encryption (TDE) is enabled on a database, it reads the page…
How do I fix my ORA-01861? There’re 5 ways that can solve ORA-01861 and make formats between date and string match each other. Conform to…