Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 18,926 total)

  • RE: Preventing usage of "SELECT *..."

    Geoff-577403 (2/13/2011)


    This can be done a lot easier with SQL 2008 Policy Management Feature.

    :smooooth:

    How?

  • RE: Very Complicate Query....

    rajesh-303966 (2/12/2011)


    Lutz,

    Is it possible to make the pos=1 and RtnSetid1 dynamic as

    By declaring variable value upto 6 for ex. x <= 6 posx and RtnSetidx likethat....

    Kindly help me on...

  • RE: SP4 on 2005 Standars edtition (32 bits)

    Rem70Rem (2/11/2011)


    Installing SP4 (RTM) on Microsoft SQL Server 2005 - 9.00.3282.00 (X64) the weekend in production

    Any last minutes information needed?

    And a backup restored to another server with checkdb run to...

  • RE: Preventing usage of "SELECT *..."

    Tom.Thomson (2/11/2011)


    There are also some reasons from the GUI side of the house in the following short article...

    http://www.adopenstatic.com/FAQ/selectstarisbad.asp

    YG&LF!! I started reading the stuff at that URL, and hit...

  • RE: Suggestions to tune this query?

    sqldba_icon (2/11/2011)


    Ninja's_RGR'us (2/11/2011)


    Unlikely. The problem with this setup if that you are basically downloading the whole table.

    Unless you can bring that down to 3% and ideally very much...

  • RE: Preventing usage of "SELECT *..."

    ZA_Crafty (2/11/2011)


    I started my career as dba, and in the mean time discovered that my true calling is in fact development.

    Now if my dba disables select * from any of...

  • RE: Suggestions to tune this query?

    Unlikely. The problem with this setup if that you are basically downloading the whole table.

    Unless you can bring that down to 3% and ideally very much less than...

  • RE: Suggestions to tune this query?

    Without a where condition it CANNOT do anything else than a scan.

    That being said, maybe it's not required.

    Can you post table / keys / indexes defs, sample data and required...

  • RE: Parent Report and Sub Reports Issue

    Yes there is. Simply put a default parameter that has a fast completion time. So they know what the report will look like.

    Here's a very complete list of...

  • RE: Parent Report and Sub Reports Issue

    My setup is in french so guess-translating.

    You have the same function to hide the folders as you have for the reports. Which means you see hit in the full...

  • RE: Parent Report and Sub Reports Issue

    Well that starts with correct cataloging and classification in folders.

    That being said, you could put all your subreports into a single folder and hide that folder from the "short" list...

  • RE: Parent Report and Sub Reports Issue

    I understand but what are you trying to prevent???

    What's the worst that can happen if a user unwantedly runs those subreports bypassing the parent?

  • RE: Parent Report and Sub Reports Issue

    Yes... otherwise you'd have no way to go in to edit the properties.

    You could always add a hidden parameter that you set via the parent report so that even if...

  • RE: Parent Report and Sub Reports Issue

    Ya just go in the subreport properties in the web interface and then check the box "Hide in list view"

  • RE: Accidentally deleted a Table ?? Can I recover ??

    Grant Fritchey (2/10/2011)


    Ninja's_RGR'us (2/10/2011)


    kasaranenikiran-725528 (2/10/2011)


    THanks for the Info... This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also...

Viewing 15 posts - 7,126 through 7,140 (of 18,926 total)