Forum Replies Created

Viewing 15 posts - 22,486 through 22,500 (of 49,552 total)

  • RE: Query Plan?

    Maybe post this in the comments of the article?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 7, 2011 at 2:25 am

    #1403811

  • RE: Never offend a captive audience

    SQL_EXPAT (11/7/2011)

    natural reaction to high stress/high impact working environments.... when trading systems are down there will be profanity... lots of it.

    Disagree. I used to work on a bank's trading...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 7, 2011 at 2:24 am

    #1403810

  • RE: Reindex failed primary file group not enough space

    sqlfriends (11/6/2011)

    So based on the size and the entire size of the database mentioned in above post, how much more space I need to assign to the database data file?

    I've...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 7, 2011 at 2:07 am

    #1403808

  • RE: PRIMARY Clustered vs NonClustered

    John Esraelo-498130 (11/6/2011)

    Also, clustered one is <snip> by far is faster than a non-clustered..

    Is it?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 11:38 am

    #1403730

  • RE: Using ISNULL

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 11:37 am

    #1403729

  • RE: Using ISNULL

    COALESCE(<expression1>,<expression2>,<expression3)

    is equivalent to

    ISNULL(ISNULL(<expression1>,<expression2>),<expression3>)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 11:08 am

    #1403725

  • RE: Using ISNULL

    Why do you not what to use Coalesce? From what you describe, it would be the way I'd go.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 10:53 am

    #1403722

  • RE: What are the risks of renaming FK/PK/UKs?

    None, unless you have any index hints referencing those constraints (which would generally not be recommended anyway)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 9:33 am

    #1403717

  • RE: Hw to restore an encrypted database backup in sql server 2008 (using script)?

    Sourav-657741 (11/6/2011)

    I'm now suggesting the customer to use 'database level encryption'.

    SQL 2005 doesn't have database encryption. It has column encryption, which is a completely different thing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 9:32 am

    #1403716

  • RE: where clause

    JonFox (11/6/2011)

    (for example on 2008 SP1 you can probably get away with using OPTION (RECOMPILE) )

    SP1 no, you need at least SP1 CU5 (or SP2) to be able to do...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 8:59 am

    #1403713

  • RE: sql start up problem

    changed the startup parameters in properties of sql sercer in configuration manager from -d to -m but i got this error after starting the sql server :

    There's your problem....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 8:51 am

    #1403711

  • RE: Stored Procs vs Ad Hoc

    brandonmooreis (11/6/2011)

    I posted this poll because the new lead developer on my team is wanting to move everything towards sprocs.

    Good to hear.

    I believe in using sp's in a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 12:53 am

    #1403685

  • RE: Reindex failed primary file group not enough space

    Is your largest table under 0.7GB?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 6, 2011 at 12:31 am

    #1403682

  • RE: Hw to restore an encrypted database backup in sql server 2008 (using script)?

    As per Books Online...

    RESTORE DATABASE ...

    WITH MEDIAPASSWORD = 'XXXX'

    This is not encryption, no keys, no certificates. This is nothing more than a weak password to discourage someone from restoring the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 5, 2011 at 12:37 pm

    #1403655

  • RE: Investigating (and resolving) bad plans and dynamic SQL.

    allmhuran (11/5/2011)

    Why would SQL server be using the @0=@1 paramaterized plan for the execution of the "where hire_no = <value>" query? That doesn't make sense.

    It wouldn't be. It can't. Ad-hoc...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 5, 2011 at 6:36 am

    #1403606

Viewing 15 posts - 22,486 through 22,500 (of 49,552 total)