Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 49,552 total)

  • RE: Partition Help

    N.B. (7/30/2016)

    The SNAP_DATE column in the tables will be part of the primary key on each table, and used when joining those tables to each other for historical reporting. ...

    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

    July 30, 2016 at 12:28 pm

    #1892762

  • RE: How Far Have You Traveled for a SQL Saturday?

    Hugo Kornelis (7/29/2016)

    Also, in the past I remember the Australian community organizaing a series of "SQL Saturday" events that were spread out over the country and all just a few...

    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

    July 29, 2016 at 3:21 am

    #1892596

  • RE: How to reclaim the space without shrinking the database

    naren.ece2012 (7/28/2016)

    Is there any other way other than shrinking???(It is a production database).

    No. Reclaiming space = shrinking data files.

    You could just leave it though. Free space in the data file...

    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

    July 29, 2016 at 3:12 am

    #1892593

  • RE: How Far Have You Traveled for a SQL Saturday?

    I'm going to be an outlyer, but most of these were paired with a second event in the same region (eg MVP Summit, SQLBits, etc), and I was speaking 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

    July 29, 2016 at 2:03 am

    #1892586

  • RE: How do you know when it is time to leave a job?

    ZZartin (7/27/2016)

    GilaMonster (7/27/2016)

    Eric M Russell (7/27/2016)

    It can be especially difficult for an organization when the recruiting effort is too focussed on conformity and cultural fit rather than experience and talent...

    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

    July 28, 2016 at 6:25 am

    #1892453

  • RE: Are the posted questions getting worse?

    The copyright page on my blog is more so that when someone starts posting my stuff as theirs, I have something to point them to as to what I consider...

    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

    July 28, 2016 at 6:15 am

    #1892451

  • RE: UPDATE SQL not working

    What's the output of:

    SELECT * FROM tab1

    SELECT * FROM tab2

    ?

    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

    July 28, 2016 at 3:24 am

    #1892425

  • RE: How do you know when it is time to leave a job?

    Eric M Russell (7/27/2016)

    It can be especially difficult for an organization when the recruiting effort is too focussed on conformity and cultural fit rather than experience and talent relevent 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

    July 27, 2016 at 9:29 am

    #1892322

  • RE: I nEED backup query to backup to disk but

    Easiest is to use a maintenance plan for that, the cleanup task does the file removal, the backup task lets you select specific databases

    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

    July 27, 2016 at 8:45 am

    #1892305

  • RE: How do you know when it is time to leave a job?

    Eric M Russell (7/26/2016)

    Rod at work (7/26/2016)

    If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't see...

    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

    July 27, 2016 at 8:32 am

    #1892294

  • RE: Availability groups - Read Only Intent

    curious_sqldba (7/26/2016)

    if i have a sproc that does bunch of reads from one database and writes it to another database, would the read-only type queries automatically get transferred to secondary...

    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

    July 27, 2016 at 8:28 am

    #1892292

  • RE: 64KB disk formatted vs 4KB disk formatted

    Let's step back a bit. By 'disk', do you mean old-style spinning disks directly attached to the machine, or do you mean a SAN LUN presented as a 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

    July 27, 2016 at 8:24 am

    #1892290

  • RE: 64KB disk formatted vs 4KB disk formatted

    because SQL performs disk IO in extents and an extent is 8 pages, each of which are 8KB, for a total of 64KB

    Unfortunately that's not true.

    http://blog.purestorage.com/what-is-sql-servers-io-block-size/

    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

    July 27, 2016 at 7:22 am

    #1892263

  • RE: Checking if a string value includes a value from a field

    twin.devil (7/27/2016)

    Quick suggestion, you can you PATINDEX to validate Email as well as to get the Birth Year from the email address.

    select dob, adj.YEAR_OF_BIRTH, email, IsValidEmail

    from

    (

    Select cast('20160101' as datetime)...

    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

    July 27, 2016 at 5:51 am

    #1892234

  • RE: Are the posted questions getting worse?

    jasona.work (7/27/2016)

    For the LastPass users around here:

    Zero day hole can pwn millions of LastPass users, all that's needed is a malicious site[/url]

    Already fixed. https://labs.detectify.com/2016/07/27/how-i-made-lastpass-give-me-all-your-passwords/

    Edit: correction, looks like different exploits.

    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

    July 27, 2016 at 5:43 am

    #1892231

Viewing 15 posts - 2,716 through 2,730 (of 49,552 total)