http://www.xoowiki.comLatest articlesen-US© http://www.xoowiki.comadmin@xoowiki.frjusteSQL ServerGeneration on demand of 100 random time range whose duration does not exceed 30 minutes. This script was used for a lottery game.http://www.xoowiki.com/en-US/Article/SQL-Server/random-time-range-44.aspx2011-04-25justeSQL ServerPassword generatorhttp://www.xoowiki.com/en-US/Article/SQL-Server/generator-random-password-69.aspx2011-04-25justeSQL ServerDeduct days of execution for a SQL job with decomposition method in powers of twohttp://www.xoowiki.com/en-US/Article/SQL-Server/deduct-days-of-execution-for-a-sql-job-298.aspx2011-04-25justeSQL ServerConvert a Julian date format and vice versa.http://www.xoowiki.com/en-US/Article/SQL-Server/julian-date-83.aspx2011-04-25justeSQL ServerGenerating a script to attach files to a database. Script must be run before detach files !http://www.xoowiki.com/en-US/Article/SQL-Server/dynamic-attach-471.aspx2011-04-25justeSQL ServerDownload / Uplad / Delete a file on SFTP from SSIShttp://www.xoowiki.com/en-US/Article/SQL-Server/ssis-sftp-task-475.aspx2011-04-25justeSQL ServerCheck activity on a database to determine if it has been used/updated recently to archive or not.http://www.xoowiki.com/en-US/Article/SQL-Server/check-activity-on-a-database-491.aspx2011-04-25justeSQL ServerInitialize a value of type DATETIME at 00:00:00http://www.xoowiki.com/en-US/Article/SQL-Server/datetime-000000-89.aspx2011-04-25justeSQL ServerTo truncate the transaction file of a database mirroring, a backup log will be launched in a loop until it doesn't contains any more actives Virtual Log File. A SHRINK will be possible just after the baclup log. Be careful, this solution is limited to a database with few transactions.http://www.xoowiki.com/en-US/Article/SQL-Server/truncate-log-on-database-mirroring-499.aspx2011-04-25