Useful tips for everyday
What is a non aggregated column? 3 MySQL Handling of GROUP BY. For the query to be legal, the name column must be omitted from…
How set MySQL root password after installation? Configuring a default root password for MySQL/MariaDB Use the following procedure to set a root password. To change…
How can improve SQL Server database performance? Tips to improve SQL Server performance & database design Choose Appropriate Data Type. Avoid nchar and nvarchar. Avoid…
Does SQL express support mirroring? Express Edition doesn’t include database mirroring, but you can do something similar with log shipping. Log shipping is a technique,…
How long does a query take? Some may take longer to establish the connection, and others to transmit data. The query takes 20 to 500…
Where do I find the status variables in MySQL? The MySQL server maintains many status variables that provide information about its operation. You can view…
How to show rows that are different between two tables? You can just Full Outer Join on the PK, preserve rows with at least one…
What is Kimball dimensional Modelling? Dimensional modeling (DM) is part of the Business Dimensional Lifecycle methodology developed by Ralph Kimball which includes a set of…
How use inner join index in SQL Server? Force using an Index in Inner Join SELECT [closed] Table1 has clustered index in t1.Id. IndSearch is…
How do SQL Server Agent jobs work? SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each…