Useful tips for everyday
What is Reportservertempdb? ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports. To…
What is query in Big Data? Big data analytics are techniques that are used to analyze large datasets in order to extract patterns, trends, correlations…
WHERE do I type SQL commands? Accessing SQL Commands Click SQL Workshop and then SQL Commands to drill-down to the SQL Commands home page. Click…
Why does text column not have default value in MySQL? If you try to create a TEXT column on a table, and give it a…
How do I query only date in SQL? MS SQL Server – How to get Date only from the datetime value? SELECT getdate(); CONVERT (…
How do you add a column to NOT NULL? The only way to really be sure is to enforce it in your column definition. If…
What is mutating in the trigger Please select all the correct answers? Mutating trigger is trigger that is currently being modified by DML opertion. sabrishandyou.…
How do you store large arrays? Storing and reading large arrays Store each chunk in a separate file. Store all chunks into a single text…
Can I delete log files in Windows? From the left panel, under the “Windows Log” section, most of the logs can be accessed. To clear…
What happens when you disable ghost cleanup in SQL Server? Since the ghost cleanup process removes records that are marked as ghosts, disabling the process…