Forum Replies Created

Viewing 15 posts - 586 through 600 (of 18,926 total)

  • RE: T-SQL code to perform dimension/fact updates

    ... depends on what you are transfering.

    What type of data / documents are you downloading?

  • RE: Are the posted questions getting worse?

    ChrisM@Work (12/6/2011)


    Ninja's_RGR'us (12/6/2011)


    LutzM (12/6/2011)


    Changing subject: Does anyone know one of the DBAinSpace finalists?

    There's no name I recognize as one of the Threadizens....

    There's noone I recognize from this site, period. ...

  • RE: temp tables

    JonFox (12/6/2011)


    What is the scope of these temp tables, #local or ##global?

    You need a trace to track connection opened / closed.

    Beyond that I'm not sure what else you'd need to...

  • RE: Are the posted questions getting worse?

    LutzM (12/6/2011)


    Changing subject: Does anyone know one of the DBAinSpace finalists?

    There's no name I recognize as one of the Threadizens....

    There's noone I recognize from this site, period. :crying:

  • RE: How to replace While Loop in place of Cursor

    Reformated for Sanity :

    CREATE PROCEDURE [dbo].[MyTestSPROC]

    @Category NVARCHAR(MAX)

    , @Program NVARCHAR(MAX) = ''

    , @AName NVARCHAR(MAX) = ''

    , @Country NVARCHAR(MAX) = ''

    ...

  • RE: T-SQL code to perform dimension/fact updates

    Of course you can. What exactly do you need to do and what are your limitations?

  • RE: temp tables

    Long @$$ shot, anything weird in the err logs?

  • RE: temp tables

    Track the connection useage. No way the table was dropped by error by sql server.

    There's either an explicit drop or the connection is recycled.

    Could also be an edge case...

  • RE: SQL Server 2008 Error

    The linked server is not configured properly on 2008. See how you did it on 2005 and redo on 2008 (that can be scripted if you want).

  • RE: upgrade reporting server

    I know you can have RS 2008 use 2005 as datasource.

    I'm not sure I understand your upgrade process tho. If it's on a new machine then super easy to...

  • RE: How to replace While Loop in place of Cursor

    See all the free time we have to goof around. Too bad we don't have what we need to work on your issue.

  • RE: Logical File Appears After 2005 To 2008 R2 DB Restore

    CSS or PSS.

    Either there's something really wrong in the DB or you've hit a bug. Either way I'd like those guys on my side.

    You can always wait 1-2 days...

  • RE: Complex joins

    SQL Kiwi (12/6/2011)


    Hugo Kornelis (12/6/2011)


    Something about the ability to select blocks of code to run easily I think is one main argument in favour.

    +1000

    I work mainly with 1000+ lines procs...

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/6/2011)


    Steve Jones - SSC Editor (12/6/2011)


    george sibbald (12/6/2011)


    I was first 🙂

    You were, and I've chimed in with Gail.

    Yeah but Cadavre had blood in his post.

    DOA is a better description...

  • RE: How to replace While Loop in place of Cursor

    SQLRNNR (12/6/2011)


    Lynn Pettis (12/6/2011)


    MSBI Learner (12/6/2011)


    Yeah, I have sent... hope that helps you to work on my issue.

    Please let me know if you need any more information on the same.

    There...

Viewing 15 posts - 586 through 600 (of 18,926 total)