Useful tips for everyday
What does replay do in SQL Server Profiler? SQL Server Profiler features a multithreaded playback engine that can simulate user connections and SQL Server Authentication.…
How is a histogram similar to an event counter? The histogram target behaves similarly to the event_counter target. The event_counter target counts the number of…
Does Mysqldump backup users? The users and privileges are stored in the databased named ‘mysql’. You can use mysqldump to backup the tables in the…
How do I find the format of a column in SQL? The other way to check data types is the statement with using INFORMATION_SCHEMA database.…
How do I install Reporting Services in SharePoint Integrated mode? Select ‘Install only’ radio button from ‘Reporting Services SharePoint Integrated Mode’. This will install two…
What is free space map in PostgreSQL? Each heap and index relation, except for hash indexes, has a Free Space Map (FSM) to keep track…
How do you find the distance between two cities? Measure distance between points On your computer, open Google Maps. Right-click on your starting point. Choose…
Is there a better way to avoid update statement locking out the table? Does NOLOCK even make sense in this case, because the SQL Server…
How do you append an int to a string in Python? If you want to concatenate a number, such as an integer int or a…
How do I match a specific character in RegEx? There is a method for matching specific characters using regular expressions, by defining them inside square…