Useful tips for everyday
Is it possible to shrink a SQL server log file? But you can reclaim this excess space by shrinking SQL Server log file. The process…
What are dynamic management views in SQL Server? Dynamic management views and functions return server state information that can be used to monitor the health…
What are the different types of indexes in MongoDB? MongoDB involves different types of data hence different types of indexes are derived to support these…
How to spool to a CSV file using sqlplus? I need to spool CSV file from SQLPLUS, but the output has 250 columns. What I…
Is SQL Server 2016 end of life? July 14th, 2026 is the end of Extended Support for SQL Server 2016. At this time Microsoft will…
Why is database activity monitoring important? Activity monitoring is an essential part of any comprehensive database-security best practice. Monitoring and alerting enables enterprises to detect…
How do you SELECT a column from a table that has non null values? select column_name from user_tab_columns where table_name=’Table_name’ and num_nulls=0; Here is simple…
How do you handle a merger? Change Advocacy Always be positive. Leave the past in the past. Don’t speak negatively about the merger to anyone.…
How to view a plan in SentryOne SSMS? Right-click a plan in SSMS, and then select View with SentryOne Plan Explorer. This opens the plan(s)…
Where is the snapshot folder in replication? You can see the snapshot folder is currently pointed at a share called “\\FL-WS-CON-CC03\Share”. This is my snapshot…