Get a distinct list of file names from a table into an ArrayList and compare against a remote FTP server. Retrieve only the files that have not already been processed into the database.
2013-05-17 (first published: 2008-09-11)
2,877 reads
2008-09-05
1,260 reads
This procedure is supposed to compare structure (tables, procedures, triggers, foraign keys etc.) of two specified databases.
2008-10-27 (first published: 2008-08-19)
3,073 reads
2008-08-19
3,790 reads
2008-10-16 (first published: 2008-08-12)
1,448 reads
This article describes how to enable Instant File Initialization in SQL Server 2005
2008-07-31
3,738 reads
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
2008-06-24
5,674 reads
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
2009-10-08 (first published: 2008-06-20)
1,902 reads
2008-06-17
3,531 reads
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,274 reads
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Comments posted to this topic are about the item Create an HTML Report on...
When exploring interior doors for your home renovation or new build, you’ve probably come...
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...