Useful tips for everyday
Where is pivot table insert? Insert a PivotTable in Excel for the web Select a table or range of data in your sheet, and then…
Is SQL_Latin1_General_CP1_CI_AS case-sensitive? For example, the default server-level collation in SQL Server is SQL_Latin1_General_CP1_CI_AS , which is a case-insensitive, accent-sensitive collation. Can we make Postgres…
Can I delete IBD files? To remove the new IBD file, execute the following sql command: ALTER TABLE mytable DISCARD TABLESPACE; This command removes the…
How to execute a stored procedure against a linked server? We currently execute a stored procedure against a linked server using: EXECUTE [LinkedServer]. [DatabaseName]. [dbo].…
How do you use order by in MERGE statement? Populate into relational (physical)table via nested table (collection). The collection has a field ITR_ORDER (iteration order)…
How to optimize MariaDB to handle peak workloads? The safest option here (at the expense of a bit of speed) is to set sync_binlog =…
How to identify a poor plan in SQL Server? Plans can be poor because they take a long time to complete or because they consume…
Can a table have multiple foreign keys from same table? A table may have multiple foreign keys, and each foreign key can have a different…
How do I enable SQL Server and Windows NT authentication? 2 Answers Start > Run > Services.msc. Right-click on the service in “Services” Choose the…
What is outrigger dimension? An outrigger is a dimension table or entity that is joined to other dimension tables in a star schema. Outriggers are…