Forum Replies Created

Viewing 15 posts - 256 through 270 (of 322 total)

  • RE: Dependencies,Please help

    salibindla_m (4/1/2008)

    Hi

    I am trying to move objects,Sps,views,Udfs from one database to another meaning cleaning the junk.is there any script that I could find Tables,Sps.views udf's dependencies and than recreate the...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 3, 2008 at 10:35 am

    #797945

  • RE: generating the csv files

    This got me thinking... I haven't seen any posts from Phil for a while.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 1, 2008 at 9:41 am

    #796631

  • RE: The New SQL OS

    Ya got me too! Good one.:cool:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    April 1, 2008 at 9:24 am

    #796613

  • RE: Replicating LARGE database over WAN

    Michael Valentine Jones (3/26/2008)

    The data transfer rate of a FedEx package is very high.

    You just made my day! What a great line.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 28, 2008 at 9:59 am

    #795312

  • RE: Installing Database Server in Windows Vista

    Another option would be to setup a Server 2003 on a Virtual PC. they usually run better from an external drive, but since you have 2 HDs on your laptop,...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 28, 2008 at 9:50 am

    #795298

  • RE: Bad Automation

    As a developer, I know how easily the mind's scope can be narrowed to just the single application that I'm working on. That still isn't an excuse to produce an...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 26, 2008 at 9:11 am

    #794121

  • RE: Linking to the Previous Row

    Lisa Slater Nicholls (3/16/2008)

    >>

    However, when one post examples using Oracle or SQL 2005 you often get a question about "how to do this in SQL 2000". I usually...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 17, 2008 at 8:00 am

    #790347

  • RE: Trouble writhing the code for a new trigger

    Keep in mind that if just 1 row meets your criteria, you will be undoing the entire update.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 14, 2008 at 8:08 am

    #789645

  • RE: Backup solution-need suggestions/opinions

    As a DBA you will be better off with a single point of reference for histories, errors, restores, etc.

    Unless you are the person responsible for ALL backups, use native backup....

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 14, 2008 at 7:55 am

    #789636

  • RE: Linking to the Previous Row

    CREATE TABLE #PriceCompare (

    ITEMNMBR varchar(31),

    ITEMDESC varchar(101),

    DOCDATE datetime,

    UNITCOST numeric(19, 5),

    rownum int identity

    )

    INSERT INTO #PriceCompare

    SELECT

    RTRIM(PH.ITEMNMBR) [ITEMNMBR],

    RTRIM(i.ITEMDESC) [ITEMDESC],

    ph.DOCDATE,

    ph.UNITCOST

    FROM IV00101 i

    INNER JOIN IV30300 ph

    ON i.ITEMNMBR = ph.ITEMNMBR

    ORDER BY...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 13, 2008 at 10:54 am

    #789209

  • RE: Create a job to execute proc in all databases.

    If there is common data used by multiple databases of a single application, it is unfortunate that the application designers didn't think to use an Application Master database for housing...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 13, 2008 at 9:20 am

    #789138

  • RE: Linking to the Previous Row

    jordonpilling (3/13/2008)

    a very nice article indeed, however i recently had the same issue on SQL Server 8.0, Is their a related atricle/method for SQL 8?

    You should be able to do...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 13, 2008 at 8:42 am

    #789102

  • RE: How to lay out SQL Code

    Karma (3/6/2008)

    Hi,

    Interesting topic 🙂

    Does anyone else think it's slightly obtuse to spend time creating naming standards for tables and then alias them in code with something so meaning less as...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 6, 2008 at 10:45 am

    #786205

  • RE: How to lay out SQL Code

    paulhunter (3/5/2008)

    Could be my faulty memory. I thought I remembered a post that went to the effect of "why are you wasting your time on this". If I...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 6, 2008 at 6:31 am

    #785900

  • RE: How to lay out SQL Code

    paulhunter (3/5/2008)

    xmlish short hand for stating it's an opinion. Or, was the "huh?" that you didn't understand the why and where of that comment?

    I'm afraid I didn't understand the...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 5, 2008 at 6:08 pm

    #785840

Viewing 15 posts - 256 through 270 (of 322 total)