Useful tips for everyday
How to fix 1064 error in MySQL? Error #1064 means that MySQL can’t understand your command….To fix it: Read the error message. It tells you…
How do I install SQL Server Management Studio 18? Go To Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft SSMS 18. Below ‘Connect to Server’ screen…
What happens when you delete a foreign key? A foreign key with cascade delete means that if a record in the parent table is deleted,…
How do I upgrade my SSIS package from 2008 to 2017? 1 Answer Fire up ISDeploymentWizard (C:\Program Files\Microsoft SQL Server\140\DTS\Binn\ISDeploymentWizard.exe) Change the deployment model from…
How do I get column names in Toad? 1 Answer From Oracle metadata: select * from all_tab_columns where table_name =’USER’; From Toad UI: You should…
How to diagnose blocking issues using blocked process report? During these times we see a massive spike in response times from the database that holds…
What is the initial size of TempDB? A default installation of any SQL Server edition will create a tempdb database with an 8MB data file…
What is tuned query? SQL Tuning or SQL Optimization. Sql Statements are used to retrieve data from the database. We can get same results by…
How do you subtract dates from dates? Here’s how: Type a start time and end time. In this example, the start time is in cell…
Can I use a different port for MySQL? Even though the MySQL default port is 3306, that doesn’t always mean your MySQL service will always…