Forum Replies Created

Viewing 15 posts - 526 through 540 (of 2,010 total)

  • RE: Are the posted questions getting worse?

    Another late comer here, good luck Barry and best wishes for a speedy recovery.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 15, 2010 at 6:50 am

    #1133663

  • RE: Update Oracle table from SQL 2005

    So I may not be understanding your data all that well, some sample data and the relevant DDL of the tables would make this more helpful, check the first link...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 12, 2010 at 2:26 pm

    #1133015

  • RE: Change Subscription Owner with Direct SQL Update

    I'm not sure about doing this as a direct update vs. report manager but if you're looking for other avenues, I'd think you might want to try the webservice and...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 12, 2010 at 11:18 am

    #1132887

  • RE: SQL Server Monitoring Software Recommendations

    I've used a variety of tools and am currently in a shop that used the ideara Diagnostic manager tool. IT seems to get the job done. I'd say...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 12, 2010 at 9:33 am

    #1132820

  • RE: need way to get disk space used by table

    Have a look at the sp_spaceused system stored procedure in BOL.

    I think it will get you want you want.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 12, 2010 at 9:10 am

    #1132788

  • RE: Friday Afternoon

    Where I work now we have a small break room with a fridge micro etc, but that about it. I clear my head by taking a walk outside...

    At previous...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 12, 2010 at 7:21 am

    #1132679

  • RE: Update Oracle table from SQL 2005

    Update OracleServer..OracleSchema.GM_ITM

    SET LST_BUY_CST = (SELECT a.PS_COST

    FROM SQLServer.SQLDatabase.dbo.GRS_COST_COMPARE a

    INNER JOIN OracleServer..OracleSchema.GM_ITM b ON b.ITM_CD=a.ITM_CD),

    LST_BUY_CST_CHNG_DT=GETDATE()

    WHERE ITM_CD='042470'

    AND

    EXISTS

    (SELECT a.PS_COST

    FROM SQLServer.SQLDatabase.dbo.GRS_COST_COMPARE a

    INNER JOIN OracleServer..OracleSchema.GM_ITM b ON b.ITM_CD=a.ITM_CD)

    The portion I put in...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 11, 2010 at 2:14 pm

    #1132317

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/11/2010)

    Jeff has quietly passed the 20,000 pt mark. No fanfare???

    Congrats Jeff.

    Congrats Jeff! I wonder how long it be 'til he catches Steve?

    Cheers,

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 11, 2010 at 12:09 pm

    #1132240

  • RE: Running Reporting Services on a Virtual Server

    SQL Noob (3/10/2010)

    hardware resources. we run a scale out version of SSRS and the main server has 32GB of RAM. Reason is our BI devs wrote a bad query one...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 10, 2010 at 1:39 pm

    #1131643

  • RE: Which report caused the error?

    Job Name or Job ID? If it's the JobName, that is the same as the ScheduleID from the Reportserver database which you can use to join to the catalog...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 9, 2010 at 12:34 pm

    #1130891

  • RE: SQL Engine Service Account

    I can't say that I've ever done it without recycling the service. Even if it's possible, I'll still always stop/start the service because that way you know that...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 9, 2010 at 11:45 am

    #1130856

  • RE: Which report caused the error?

    I may be reading this incorrectly... Can you confirm the GUID that you get is that the GUID for the Subscription or something else? If it's the subscription you...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 9, 2010 at 11:36 am

    #1130847

  • RE: SSRS 2008 toolbox options

    I suppose I don't get what you are trying to accomplish here.

    You could put any number of textboxes, rectangles, lines or whatever else you see fit on the...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 5, 2010 at 1:22 pm

    #1129434

  • RE: SSRS vs Crystal

    Here's a link... http://lmgtfy.com/?q=ssrs+vs+crystal

    From the 1st few results it looks like you might something from both sides of the discussion. Beware though that some of the info is a...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 5, 2010 at 1:20 pm

    #1129432

  • RE: stored procedure insert to one table then insert to another table if two variables aren't empty

    I'm sure other may have better suggestions, but I'd think about using optional parameters. Pass in your data for table 1 and pass in A and B optionally. ...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 4, 2010 at 2:25 pm

    #1128783

Viewing 15 posts - 526 through 540 (of 2,010 total)