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,870 reads
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
2012-08-09 (first published: 2012-07-26)
1,635 reads
Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.
2012-07-31 (first published: 2007-10-09)
4,364 reads
Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.
2010-05-31 (first published: 2009-04-06)
2,491 reads
Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,506 reads
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-03-28 (first published: 2008-01-18)
1,184 reads
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-01-18 (first published: 2007-09-25)
2,681 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Udaipur, Rajasthan, is a popular wedding destination known for its regal palaces, serene lakes,...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...