Forum Replies Created

Viewing 15 posts - 151 through 165 (of 206 total)

  • RE: Cursor within DTS

    At a glance it looks like the cursor is there to enforce an insert into a logging table. Is there any reason why this could not be done with a...

    Hope this helps,
    Rich

    [p]
    [/p]

    July 20, 2010 at 7:18 am

    #1195493

  • RE: Comma separated result

    Are you looking for the query to produce the resultset or a way of exporting into a csv format?

    Seeing as this is in the 7/2000 forum I would suggest that...

    Hope this helps,
    Rich

    [p]
    [/p]

    July 20, 2010 at 7:07 am

    #1195483

  • RE: Optimizing query

    The query appears to be doing table scans on the tables TaxRules and Interface_CorrectionMethods. Ideally you would want to create some clustered indexes on these tables, do you have someone...

    Hope this helps,
    Rich

    [p]
    [/p]

    July 20, 2010 at 6:55 am

    #1195475

  • RE: 70-432 Exam Passed

    Congratulations, I passed it last month see blog entry and after my recent holiday am starting to crack on with 70-450. I can see this becoming addictive!

    Hope this helps,
    Rich

    [p]
    [/p]

    July 15, 2010 at 2:01 pm

    #1193764

  • RE: Training Kit Question

    One of the features of database mirroring in 2008 is automatic page repair which would allow you to restore corrupt pages directly from the copy. If the database were on...

    Hope this helps,
    Rich

    [p]
    [/p]

    July 15, 2010 at 1:55 pm

    #1193758

  • RE: any recommendations for 70-450?

    Yin Halen (7/8/2010)

    Just barely failed the 70-450 test today.

    Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass this...

    Hope this helps,
    Rich

    [p]
    [/p]

    July 15, 2010 at 1:49 pm

    #1193754

  • RE: Help with using mulitple replace in a function

    Have you tried doing comparisons using the SOUNDEX function?

    Hope this helps,
    Rich

    [p]
    [/p]

    July 14, 2010 at 9:38 am

    #1192918

  • RE: Guide to MCITP: SQL Server 2008 Developer

    I took and passed the 70-432 exam at the weekend and there were 40 questions, seems pretty low compared to the number listed on the dev track.

    As study guides I...

    Hope this helps,
    Rich

    [p]
    [/p]

    June 21, 2010 at 7:26 am

    #1182720

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/21/2010)

    CirquedeSQLeil (6/20/2010)

    .....

    Haha - maybe I should have made a few bets this last week.:-D

    Horrible match. Looks like the "world champions" have disappeared.

    Just a few notes:

    1. Killen should...

    Hope this helps,
    Rich

    [p]
    [/p]

    June 21, 2010 at 5:19 am

    #1182659

  • RE: Why the lock wait time is not stable?

    You'll need to show what locks you are having the issue with before anybody will be able to help you with as you are just showing "_Total"

    Hope this helps,
    Rich

    [p]
    [/p]

    June 1, 2010 at 3:36 am

    #1174692

  • RE: Are there any gotchas with TDE on a Windows Server 2008 server (i.e., Microsoft failover clustering)

    We haven't had any issues, you just need to ensure that all keys/certificates are on all physical nodes. The only thing I will say though is that once you enable...

    Hope this helps,
    Rich

    [p]
    [/p]

    May 18, 2010 at 3:34 am

    #1168675

  • RE: Procedure Stats

    Microsoft have replied to the Connect Issue and have confirmed that they will be changing the documentation about this DMV.

    Hope this helps,
    Rich

    [p]
    [/p]

    May 17, 2010 at 4:27 pm

    #1168505

  • RE: Query to see what components or features are installed

    MAPs is very useful, I used it at my current position when I joined to see how big the estate was, one thing to take note of is that it...

    Hope this helps,
    Rich

    [p]
    [/p]

    May 14, 2010 at 7:04 am

    #1167502

  • RE: Careful with table name alias

    Interesting question, it was the alias that almost caught me out. Have seen plenty of attributes named as reserved words in the past which has caused a few issues unless...

    Hope this helps,
    Rich

    [p]
    [/p]

    May 14, 2010 at 5:04 am

    #1167426

  • RE: Procedure Stats

    After reading Robert's post I rechecked the code and found that the plan handle was not being taken from the procedure_stats DMV but a temporary table I had used to...

    Hope this helps,
    Rich

    [p]
    [/p]

    May 14, 2010 at 4:41 am

    #1167418

Viewing 15 posts - 151 through 165 (of 206 total)