Useful tips for everyday
What does not unique table alias mean in SQL? Your query contains columns which could be present with the same name in more than one…
Is SQL Server a Microsoft product? Microsoft SQL Server is a relational database management system developed by Microsoft. What is SQL Server Data Tools? SQL…
How convert JSON object to array Postgres? To unnest the JSON array. Then use array_agg() or an ARRAY constructor to build a Postgres array from…
Can I use and in a case statement? CASE must include the following components: WHEN , THEN , and END . ELSE is an optional…
How do I find SQL Server connection properties? In MS SQL Server, the Database Properties dialog has the “View Connection Properties” link over on the…
What is the difference between clustering and Alwayson? The main difference is that a clustered instance has the same binaries installed and configured on two…
What is the order of SQL execution? Six Operations to Order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY. By using examples, we will…
What is many-to-many relationship in power pivot? In a relational world, a many-to-many relationship is materialized using a bridge table that split this relationship in…
How to count rows with the same value in column? SQL count rows with same value in column and group by id? i wonder if…
How does a function call affect the performance? The function being called may not be loaded into the processor’s cache, causing a cache miss and…