How does one write a recursive query? This would come into play where a table is self-referencing. Like, a list of employees, where there is a primary Key and supervisor column, where the latter maps to the primary key. So, If I want a list of employees everyone from person "X" on down, how do I do this?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed