Forum Replies Created

Viewing 15 posts - 2,461 through 2,475 (of 49,552 total)

  • RE: DBCC CHECKDB error

    Is the E drive present and can you see databases and open files on that drive?

    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

    September 6, 2016 at 2:50 am

    #1899272

  • RE: Is Division by Zero NULL?

    Gregory Hart (9/6/2016)

    I beg to differ. The definition of "NULL" is a lack of a value.

    NULL is an unknown value. How many apples are there in the kitchen? NULL...

    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

    September 6, 2016 at 1:59 am

    #1899267

  • RE: Splitting out System DB data and log files?

    JasonClark (9/5/2016)

    I hope this link helpful for you:-

    https://msdn.microsoft.com/en-us/library/bb402876.aspx

    Probably not, since it's about Policy-Based Management.

    This rule checks whether data and log files are placed on separate logical drives.

    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

    September 6, 2016 at 1:38 am

    #1899262

  • RE: Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 3: Building a Correlated Subquery

    Because there's no un-aggregated columns being returned from that subquery. Group By is only needed when you have columns in aggregate and columns that aren't in aggregate in the select...

    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

    September 6, 2016 at 1:37 am

    #1899260

  • RE: Check if field is null, if yes, use this field - multiple fields...

    Coalesce is how you do this. You're getting the error because the data types are different, SQL's trying to do implicit conversions and fails. All the entrie in Coalesce must...

    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

    September 5, 2016 at 5:16 am

    #1899182

  • RE: SQL 2008 to 2016 inplace vs side by side upgrade

    I do not like in-place upgrades for production servers. If anything goes wrong in the upgrade (and I've seen it happen), then you're left with a non-working system.

    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

    September 5, 2016 at 4:19 am

    #1899175

  • RE: Splitting out System DB data and log files?

    TempDB however may well need its own drive or two, depending how much load is put onto 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

    September 5, 2016 at 4:13 am

    #1899172

  • RE: mdf database in sql server

    The tool adverts are a common spam here. Mention 'corruption', and you get a pile of them.

    We might be able to help more (and maybe even get the data back...

    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

    September 4, 2016 at 10:55 am

    #1899128

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/2/2016)

    I hope everyone has a safe weekend.

    It's the beginning of the SQLSaturday madness for me. 3 SQL Saturdays, 3 cities, 3 weeks

    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

    September 2, 2016 at 3:00 pm

    #1899059

  • RE: Why does the query optimizer choose this way?

    Abort reason is "Good enough plan found" (properties of the SELECT). Optimisation has multiple phases, "Good enough plan found" means that at the end of one phase the cheapest plan...

    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

    September 2, 2016 at 7:09 am

    #1898978

  • RE: Why does the query optimizer choose this way?

    The execution plans please, not pictures of them. As in, the XML plans saved in as .sqlplan files.

    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

    September 2, 2016 at 5:06 am

    #1898960

  • RE: Why does the query optimizer choose this way?

    Can you post the actual execution plans of both please?

    It's probably a case if 'good enough', but there might also be some estimation differences resulting in the plan you didn't...

    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

    September 2, 2016 at 3:30 am

    #1898946

  • RE: Why does the query optimizer choose this way?

    Edit: ignore.

    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

    September 2, 2016 at 3:16 am

    #1898944

  • RE: Add unique valules to a heap

    dan-572483 (9/1/2016)

    We have a new process to run updates on it that takes forever, so it needs a primary key or at least a unique index. One column already has...

    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

    September 1, 2016 at 1:39 pm

    #1898882

  • RE: Azure and ssql server 2014/2016

    And with no details about what it'll be used for, how it will be accessed, where the data comes from, what reliability is required, what performance is required, etc, etc,...

    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

    September 1, 2016 at 1:35 pm

    #1898878

Viewing 15 posts - 2,461 through 2,475 (of 49,552 total)