Useful tips for everyday
How to grab data from two tables into one view? Is it possible to grab data from two tables (that have the same fields) into…
What is the purpose of refresh in ETL process? Refresh the Dimensions, then the Facts This approach attempts to make sure that the process is…
How do I find local windows in SSIS? You must be in debug mode to display the local window: In the SSMS, click Debug ->…
How to convert month number into month name in sql? Converting month number to month name in SQL In MySQL, we can use a combination…
What is total and partial participation in ER diagram? Total Participation − Each entity is involved in the relationship. Total participation is represented by double…
Can I restore database from TRN file? trn) transaction log backup. You can restore your transaction log file with two ways. it recover the database…
What happens when execution plan is removed from SQL Server? The execution plan for your query has been successfully removed from the SQL Server plan…
Is Azure Data Studio a replacement for SSMS? Final verdict Despite being a truly an awesome tool, Azure Data Studio still lacks some key features…
How do you set a column with multiple values in SQL? To update multiple columns use the SET clause to specify additional columns. Just like…
How to select a limit number of Records in SQL? MySQL supports the LIMIT clause to select a limited number of records, while Oracle uses…