Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 49,552 total)

  • RE: Issue with while loop

    That's an error from Management Studio, not SQL Server itself.

    To  test your function, try inserting into a temp table instead. That way Management Studio doesn't have to...

    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

    January 28, 2017 at 4:40 pm

    #1925501

  • RE: Sort order guaranteed?

    Robert Frasca - Friday, January 27, 2017 7:55 AM

    Would it be guaranteed that my returned values will still be in TransactionDate order...

    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

    January 28, 2017 at 4:24 pm

    #1925500

  • RE: Cost threshold for parallelism

    george.p - Friday, January 27, 2017 8:39 AM

    The bit I still don't really understand is, does this matter if your CPU is...

    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

    January 28, 2017 at 4:19 pm

    #1925499

  • RE: Are the posted questions getting worse?

    Phil Parkin - Thursday, January 26, 2017 12:53 PM

    Or perhaps there are plans for other options: Edit with Extreme Prejudice, Edit Like...

    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

    January 26, 2017 at 2:49 pm

    #1925203

  • RE: Int vs Bigint

    Eric M Russell - Thursday, January 26, 2017 1:17 PM

    I may look back at this 10 years from now and laugh, but...

    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

    January 26, 2017 at 2:48 pm

    #1925202

  • RE: Point Stored Procs At Read-only Instance of AG Group

    In short, you don't.

    The read only routing for AGs is based on connection strings, and a connection that indicates it is read only can be connected to 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

    January 25, 2017 at 12:12 pm

    #1924937

  • RE: Patch Principal and Mirror at The Same Time

    _nzrdb6 - Tuesday, January 24, 2017 1:09 AM

    I have synchronous mirroring between Server A and Server B and need to apply 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

    January 24, 2017 at 1:58 am

    #1924538

  • RE: Indexes

    Welsh Corgi - Monday, January 23, 2017 2:58 AM

    So are you telling me if a have for example an index CallID as 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

    January 23, 2017 at 3:24 am

    #1924346

  • RE: SSC Forum Updates

    There seems to be something wrong with posting quotes.

    Works fine when I try here, but exactly the same thing doesn't work properly in another thread: https://www.sqlservercentral.com/Forums/FindPost1852973.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

    January 23, 2017 at 3:08 am

    #1924343

  • RE: when we go for cross apply and when we go for inner join in sql server 2012

    asrinu13 - Sunday, January 22, 2017 3:33 AM

    Hi Friend, I have small doubt  in sql server .
    when we go for cross apply...

    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

    January 23, 2017 at 2:39 am

    #1924332

  • RE: 2014 vs 2016 ?

    WhiteLotus - Sunday, January 22, 2017 5:32 PM

    By the way... when you buy sql license which value that you look at...

    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

    January 23, 2017 at 2:36 am

    #1924330

  • RE: How to restrict access to users

    Eirikur Eiriksson - Friday, January 20, 2017 12:40 AM

     RECONFIGURE WITH OVERRIDE is needed for updating the Running Configuration Value.

    No, it is not.

    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

    January 23, 2017 at 2:31 am

    #1924324

  • RE: SVN and Managing Multiple Environments

    Jeff Moden - Friday, January 20, 2017 6:14 AM

    I guess I rambled on about my problem a bit too much.  I'm still...

    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

    January 20, 2017 at 6:39 am

    #1924000

  • RE: DBCC CHECKDB()

    To be honest, if CheckDB runs successfully, there won't be any interesting output, plus you probably should run it with the NO_INFOMSGS option (the number of rows and pages in...

    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

    January 20, 2017 at 3:54 am

    #1923961

  • RE: SQL Server Book

    Eirikur Eiriksson - Thursday, January 19, 2017 10:04 PM

    First thought would be the Troubleshooting SQL Server: A Guide for Accidental DBAs

    😎

    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

    January 20, 2017 at 3:44 am

    #1923959

Viewing 15 posts - 1,846 through 1,860 (of 49,552 total)