A quick way to find recently entered datetime entries in tables
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-09 (first published: 2010-05-04)
1,836 reads
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-09 (first published: 2010-05-04)
1,836 reads
2010-06-09 (first published: 2008-05-20)
2,843 reads
Two sets of scripts to help setup mirroring or remove mirroring - handy during disaster recovery exercise
2010-06-07 (first published: 2009-03-17)
2,595 reads
Similar to many other Job History scripts, but unique in that it has a timeline.
2010-06-01 (first published: 2009-04-03)
3,199 reads
Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.
2010-05-31 (first published: 2009-04-06)
2,483 reads
Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.
2010-05-28 (first published: 2009-04-17)
1,463 reads
This scripts helps to power you with the disk space monitoring for the Mount points.
Hope this helps
2010-05-27 (first published: 2009-04-17)
3,995 reads
The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user
2010-05-26 (first published: 2009-04-21)
1,453 reads
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
4,996 reads
An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft
2010-05-21 (first published: 2009-05-07)
2,106 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers