Forum Replies Created

Viewing 15 posts - 61 through 75 (of 140 total)

  • RE: 10/23/07

    As tables contain data in a random order (as we are always told) wouldn't ROW_NUMBER return random values anyway!

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    October 23, 2007 at 1:46 am

    #744362

  • RE: Iterate over files in correct sequence according to creation date ??

    I use a staging table to hold the filename and modified date which is populated via a stored procedure.  I then use a Query to order the filenames to feed another...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 29, 2007 at 2:00 am

    #729998

  • RE: check for today''''s file on ftp server. if exist, then download else, restart job 30 mins later

    How are you downloading the file from the ftp server?

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    July 20, 2007 at 5:56 am

    #721068

  • RE: check for today''''s file on ftp server. if exist, then download else, restart job 30 mins later

    Something along these lines?

    http://www.databasejournal.com/features/mssql/article.php/1459691

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    July 20, 2007 at 3:53 am

    #721036

  • RE: Reporting services and IIF

    If you bracket "everything" does it work?

    = IIF(((Fields!Hazard.Value >=19 AND Fields!Hazard.Value <=76)

    AND

    (Fields!Complience.Value <=11)),"Excellent", "OOH OOH")

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    July 17, 2007 at 1:43 am

    #719904

  • RE: No DBAs allowed access to Production DB Servers...

    Isn't that the basic understanding: If you can't trust your DBA with your data who can you trust?

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    June 22, 2007 at 4:45 am

    #714532

  • RE: SSIS Jobs Fail

    Does the SQL Agent account have the correct permissions?

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 30, 2007 at 8:18 am

    #709692

  • RE: The May Car Update

    Our car is a 1.9TDi that gets approx. 38mpg commuting to and from work (urban).  On the motorways we can easily top 60mpg.  The fuel is dearer over here so it...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 30, 2007 at 7:57 am

    #709690

  • RE: Embedded sqls in front end

    Don't forget about the security issues as well

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 24, 2007 at 2:32 am

    #708559

  • RE: Using GO in a stored procedure

    But this works.

    USE

    AdventureWorks;

    ;

    DECLARE

    @MyMsg VARCHAR(50)

    SELECT

    @MyMsg =

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 24, 2007 at 1:54 am

    #708553

  • RE: Using GO in a stored procedure

    Have you tried ; (semi colon)

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 21, 2007 at 5:49 am

    #707777

  • RE: master and msdb log does not get backed up

    The master database can only be backed up using a complete backup and as such is usually in SIMPLE mode.  As the msdb is in SIMPLE mode no logs are...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 16, 2007 at 2:35 am

    #706697

  • RE: Question of the Day for 26 Apr 2007

    According to the link for Adaptec's site read performance is the same but write performance suffers.

    FeaturesRAID 0RAID 1

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    April 26, 2007 at 1:58 am

    #702543

  • RE: SSIS – Transfer SQL Server Objects Debugged

    Hate to think how much coffee and hair pulling it took to weed this out

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    April 26, 2007 at 1:42 am

    #702542

  • RE: Using Enterprise manager to monitor an MSDE database

    Just register a new server and connect to the MSDE on server1

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    April 24, 2007 at 3:43 am

    #702094

Viewing 15 posts - 61 through 75 (of 140 total)