SQL Server provides the RESTORE HEADERONLY command which helps users determine backup completion times. What if you have the need to use this completion time for comparison, perhaps to set up a job that only restores the file if it is xx hours old. This script can be used to determine the maximum backup finish […]
2002-12-04
400 reads
SQL Server provides a built-in stored procedure, sp_depends, that returns object dependencies. Recently, I discovered a need for determining dependencies on a table column, not just the table itself. For example, a table may be referenced by many stored procedures and views, but a specific column in that table may only be referenced in a […]
2002-12-03
2,403 reads
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
With in the paginated report I am trying to display on each new page...
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers