Forum Replies Created

Viewing 15 posts - 166 through 180 (of 49,552 total)

  • RE: Trigger question

    No idea why it's getting in the log table twice (that trigger CANNOT insert two rows, so it must have fired twice), but that trigger is flawed.
    A  trigger fires...

    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 27, 2018 at 11:05 am

    #1988490

  • RE: Are the posted questions getting worse?

    On an unrelated note, I've started writing fiction again on my personal blog. At the moment it's limited to material related to an ongoing roleplaying campaign, but I hope 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

    April 27, 2018 at 9:28 am

    #1988471

  • RE: principal "guest" does not exist

    Is there a logon trigger on the server?

    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 27, 2018 at 6:18 am

    #1988433

  • RE: Index REBUILD doesn't work with SORT_IN_TEMPDB = ON

    Is there some job that kills sessions that use too much TempDB space? Something another DBA put in place?

    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 27, 2018 at 6:15 am

    #1988432

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Thursday, April 26, 2018 8:57 PM

    FWIW, SO recognizes some problems: https://stackoverflow.blog/2018/04/26/stack-overflow-isnt-very-welcoming-its-time-for-that-to-change/#.WuIwkcIW6k0.twitter
    I'd like to think...

    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 27, 2018 at 2:53 am

    #1988422

  • RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

    ejoell 66477 - Friday, April 20, 2018 8:26 AM

     But why would the auto-generated script show the square brackets in the incorrect location?

    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 20, 2018 at 4:09 pm

    #1987770

  • RE: PUBLIC server role vs PUBLIC database role

    You're going to have to figure out where the differences come from yourself. Look at the queries, look at the source data, trace down where the differences originate. I haven'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

    April 19, 2018 at 12:41 pm

    #1987586

  • RE: Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

    ejoell 66477 - Wednesday, April 18, 2018 7:03 AM

    None of you people have identified the issue. 

    6 year old thread, and Lynn...

    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 18, 2018 at 2:10 pm

    #1987424

  • RE: Learning about clustered index

    NewBornDBA2017 - Wednesday, April 18, 2018 12:48 PM

    Sorry to be PIB but just confirming. You create a clustered index on a column...

    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 18, 2018 at 12:59 pm

    #1987414

  • RE: Log Backup question

    itmasterw 60042 - Wednesday, April 18, 2018 7:54 AM

    Thanks for the quick reply. I had a feeling of that, but then I...

    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 18, 2018 at 12:48 pm

    #1987412

  • RE: PUBLIC server role vs PUBLIC database role

    hurricaneDBA - Wednesday, April 18, 2018 7:24 AM

    select count(*) as PublicPermissionCount from sysprotects P inner join sysusers U on P.Uid = U.UID...

    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 18, 2018 at 12:45 pm

    #1987409

  • RE: Shrinking Transnational Log File

    Lj Burrows - Wednesday, April 18, 2018 12:45 AM

    First of all, Shrinking is bad. Shrinking log file on regular basis can cause...

    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 18, 2018 at 1:40 am

    #1987282

  • RE: Execution plan missing.

    Jeff Moden - Tuesday, April 17, 2018 7:51 AM

      It also happens if the query uses a Temp Table.  That's NOT 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 17, 2018 at 10:37 am

    #1987206

  • RE: PUBLIC server role vs PUBLIC database role

    Create yourself a new login, add DB users and grant them absolutely no permissions, and then log in and see how visible the various metadata and security information is. That'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

    April 17, 2018 at 5:04 am

    #1987108

  • RE: PUBLIC server role vs PUBLIC database role

    I have said, multiple times now, that I do not suggest removing permissions from public. I also don't recommend adding any permissions to public. Rather add permissions to user-defined roles...

    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 17, 2018 at 4:31 am

    #1987102

Viewing 15 posts - 166 through 180 (of 49,552 total)