Forum Replies Created

Viewing 15 posts - 7,531 through 7,545 (of 49,552 total)

  • RE: Moving From Production system one server to another - Do i need to copy system databases

    Yup, you can restore across the service packs without a problem.

    I'm in South Africa, if you are as well, and you would like to set up a retainer for SQL...

    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

    October 10, 2014 at 7:42 am

    #1751631

  • RE: Moving From Production system one server to another - Do i need to copy system databases

    Depends what kind of help you're looking for.

    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

    October 10, 2014 at 7:37 am

    #1751624

  • RE: Are the posted questions getting worse?

    Or, for multiple levels of geekery in one

    http://www.thinkgeek.com/product/e95e/

    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

    October 10, 2014 at 7:33 am

    #1751621

  • RE: Transactions

    Dave62 (10/9/2014)

    According to their example, testing XACT_STATE for != 0 is insufficient.

    Only if you plan to COMMIT in the catch block after an error has occurred (which there are...

    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

    October 10, 2014 at 7:29 am

    #1751616

  • RE: Moving From Production system one server to another - Do i need to copy system databases

    No, you shouldn't move the system databases. Script out anything that needs to be copied across.

    Also, any plans for upgrading from a 9 year old product (which is out of...

    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

    October 10, 2014 at 7:27 am

    #1751614

  • RE: The wisdom of developers

    sqldriver (10/9/2014)

    Today it was replacing a traditional WHERE col IS NULL with WHERE ISNULL(col, 0) = 0

    It's extremely important to realise that those two queries are not equivalent.

    The first one...

    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

    October 10, 2014 at 6:42 am

    #1751586

  • RE: Deadlock Question

    Table definition, index definition please?

    SQL may well be locking more than one row because it doesn't know that's unique and/or because there's no useful index for it to access that...

    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

    October 10, 2014 at 4:39 am

    #1751552

  • RE: Very Large Transaction Log File

    I'd recommend monitoring for a few weeks, see how much of that log is ever used. You can use DBCC SQLPERF(LOGSPACE) for that. With the DB in simple recovery, you'll...

    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

    October 10, 2014 at 4:36 am

    #1751551

  • RE: Very Large Transaction Log File

    Koen Verbeeck (10/10/2014)

    GilaMonster (10/10/2014)

    Large log file will not be the cause of performance problems. Look elsewhere for your performance issues.

    Managing transaction logs: http://www.sqlservercentral.com/articles/Administration/64582/

    What if the log file has to grown...

    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

    October 10, 2014 at 4:14 am

    #1751545

  • RE: Very Large Transaction Log File

    Large log file will not be the cause of performance problems. Look elsewhere for your performance issues.

    Managing transaction logs: http://www.sqlservercentral.com/articles/Administration/64582/

    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

    October 10, 2014 at 3:57 am

    #1751538

  • RE: Converting A OUTER APPLY to LEFT JOIN in a query

    Why?

    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

    October 10, 2014 at 3:55 am

    #1751537

  • RE: How to change server collation in 2005

    Makes no difference what collations you're setting it to. To do as you want specify /SQLCOLLATION=Latin1_General_CP1_CI_AS in the process described on that site.

    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

    October 10, 2014 at 3:34 am

    #1751533

  • RE: Understanding In memory OLTP

    Divine Flame (10/10/2014)

    Suppose we have a server which has 16 GB RAM. Now, we have configured a table as in-memory table & the size of this table is 25 GB....

    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

    October 10, 2014 at 3:22 am

    #1751530

  • RE: Are the posted questions getting worse?

    TomThomson (10/9/2014)

    GilaMonster (10/9/2014)

    Could someone who knows their way around firewalls please help this network admin out?

    http://www.sqlservercentral.com/Forums/Topic1624301-1550-1.aspx

    what he's tring to do (and you said all firewalls should 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

    October 10, 2014 at 2:30 am

    #1751517

  • RE: Understanding In memory OLTP

    Divine Flame (10/9/2014)

    My assumption regarding the in-memory tables is that we create the tables & we configure which tables we want to make as in-memory tables. These tables use 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

    October 10, 2014 at 2:26 am

    #1751515

Viewing 15 posts - 7,531 through 7,545 (of 49,552 total)