Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    I'm researching for an article and a blog post on Stretch DB, and I'm struggling to find anything complimentary to say about it to be honest.

    How many here have 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

    April 8, 2016 at 3:34 pm

    #1870941

  • RE: Code smells versus transgressions

    My rule on storing XML is, is it going to only ever be used as a single chunk, or will it need to be searched/shredded.

    If the latter, don't store 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

    April 8, 2016 at 1:15 pm

    #1870920

  • RE: Need to pull data from table having datetime colum

    m.rajesh.uk (4/8/2016)

    I am unable to fetch data using that query is that the complete query or do i need to do any changes in it.

    Maybe start with a basic...

    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

    April 8, 2016 at 11:47 am

    #1870889

  • RE: Need to pull data from table having datetime colum

    DECLARE @Today DATE = GETDATE();

    WHERE <the datetime column> >= @Today and <the datetime column> < DATEADD(dd,1,@Today)

    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

    April 8, 2016 at 7:57 am

    #1870803

  • RE: SQL Server diagram - table in other DB

    Providing you have properly written check constraints on both sides, it should work (checking on inserts not enough, you need to consider updates), emphasis 'should'

    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

    April 8, 2016 at 7:40 am

    #1870799

  • RE: SQL Server diagram - table in other DB

    happycat59 (4/7/2016)

    You can work around this by using a UDF - not sure but the UDF may be able to reference another database (either directly or using a synonym).

    Be careful...

    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

    April 8, 2016 at 7:02 am

    #1870781

  • RE: Get distinct records for paging when joining tables

    Can you post execution plans for all of those tests?

    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

    April 8, 2016 at 6:56 am

    #1870775

  • RE: Prod DB on Simple Recovery Model

    No point in time recovery. If you're doing full backups once a day, then in simple recovery you're risking up to 24 hours of data loss in a disaster, where...

    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

    April 8, 2016 at 4:55 am

    #1870745

  • RE: Are the posted questions getting worse?

    Jack Corbett (4/7/2016)

    SQLRNNR (4/6/2016)

    Brandie Tarvin (4/6/2016)

    Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how...

    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

    April 8, 2016 at 3:37 am

    #1870731

  • RE: Could it be Tempdb corrupt ?

    Not real corruption.

    https://connect.microsoft.com/SQLServer/feedback/details/641122/error-605-in-tempdb-on-sql-2008-r2-despite-bug-claims-to-be-fixed

    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

    April 8, 2016 at 2:59 am

    #1870727

  • RE: sql server 2016 certification

    tindog (4/7/2016)

    GilaMonster (4/7/2016)

    tindog (4/7/2016)

    If you're not in any rush then you might as well wait for 2016.

    Or do both. There will likely be an upgrade option for the certification (usually...

    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

    April 7, 2016 at 7:50 am

    #1870482

  • RE: sql server 2016 certification

    tindog (4/7/2016)

    If you're not in any rush then you might as well wait for 2016.

    Or do both. There will likely be an upgrade option for the certification (usually 1 or...

    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

    April 7, 2016 at 7:38 am

    #1870472

  • RE: How to split records evenly into 4 tables from one table is sql

    nTile window function can create a column with numbers 1 to 4. After that it should be easy to do an INSERT ... WHERE Tile = 1...

    CREATE TABLE #Test (

    SomeNumber...

    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

    April 7, 2016 at 7:29 am

    #1870466

  • RE: Are the posted questions getting worse?

    Anyone want to hep tune a really nasty looking query?

    http://www.sqlservercentral.com/Forums/Topic1774589-3412-1.aspx

    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

    April 7, 2016 at 7:24 am

    #1870462

  • RE: Transaction Log Truncation - in Full or Incremental backup

    Hugo Kornelis (4/7/2016)

    Suppose you need to restore and find that the last full backup is unreadable, you can still restore from the previous full and then apply all tran...

    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

    April 7, 2016 at 7:23 am

    #1870460

Viewing 15 posts - 3,286 through 3,300 (of 49,552 total)