Forum Replies Created

Viewing 15 posts - 8,191 through 8,205 (of 49,552 total)

  • RE: db owner

    sqlfriends (8/8/2014)

    But my question is why bother to grant all these permssions, but just grant this account db_owner role. Becaue it pretty much need all the permissions: read, write, and...

    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

    August 9, 2014 at 5:48 am

    #1736600

  • RE: Troubleshooting\Tuning sql query taking more than 40 secs

    Table definitions, index definitions and actual execution plan please.

    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

    August 9, 2014 at 5:32 am

    #1736597

  • RE: Guys - How can I find out what VERSION was used to create a .BAK file ?

    RESTORE HEADERONLY FROM DISK = '<path to backup file>'

    One of the fields will tell you the version of SQL which created the backup.

    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

    August 9, 2014 at 5:31 am

    #1736596

  • RE: Restoring from .SS file

    Not if the snapshot has been dropped.

    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

    August 8, 2014 at 8:52 am

    #1736450

  • RE: Titles Matter

    Andy Warren (8/8/2014)

    Technical Lead isn't a bad title, though I'd like it better if it were Database Technical Lead or SQL Technical Lead. Still, I think most reading the title...

    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

    August 8, 2014 at 8:49 am

    #1736448

  • RE: Tables on seperate filegroups.

    senthil kumar d (8/8/2014)

    But the downside is that the DBA informed me that we are using a SIMPLE recovery database and it is not possible to have filegroup based backup...

    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

    August 8, 2014 at 3:29 am

    #1736340

  • RE: What percentage of memory utilization is server bottleneck?

    Wrong question

    SQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't, 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

    August 8, 2014 at 3:21 am

    #1736337

  • RE: need where clause with date is blank

    WHERE <date column> IS 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

    August 8, 2014 at 3:06 am

    #1736332

  • RE: Titles Matter

    What does "Technical Lead" say about me, I wonder...

    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

    August 8, 2014 at 2:27 am

    #1736326

  • RE: How to solve the SQL server performance issues?

    Could you be a little more specific about what the problem 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

    August 8, 2014 at 2:25 am

    #1736325

  • RE: Index creation

    ScottPletcher (8/7/2014)

    GilaMonster (8/7/2014)

    New Born DBA (8/7/2014)

    GilaMonster (8/7/2014)

    What does "Creating an index within the application" even mean?

    No Idea. I wanted to ask him the same thing

    Then do so.

    Seems to me 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

    August 8, 2014 at 1:09 am

    #1736310

  • RE: Index creation

    New Born DBA (8/7/2014)

    GilaMonster (8/7/2014)

    What does "Creating an index within the application" even mean?

    No Idea. I wanted to ask him the same thing

    Then do so.

    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

    August 7, 2014 at 3:26 pm

    #1736220

  • RE: where not exists sub-query and how it effects sort order of a table

    No order by, no guarantee of order. End of story.

    Tables don't have a defined order. They are unordered sets of rows.

    Edit: and put the TOP on the select. Along with...

    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

    August 7, 2014 at 3:25 pm

    #1736219

  • RE: Table Partitioning Question

    alex_pixley (8/7/2014)

    GilaMonster (8/7/2014)

    If partitions 8-13 are empty, this will not save you any disk space.

    It's like insulating your home. There is the upfront cost of time and effort. ...

    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

    August 7, 2014 at 2:21 pm

    #1736192

  • RE: Are the posted questions getting worse?

    Ok, good, I'm not the only one who would think 'blocking' long before thinking 'let me post this impossible situation on the forums'

    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

    August 7, 2014 at 2:18 pm

    #1736188

Viewing 15 posts - 8,191 through 8,205 (of 49,552 total)