Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 49,552 total)

  • RE: Find the last executed part of a stored procedure

    Look at the Books Online entry for either sys.dm_exec_requests or sys.dm_exec_query_stats (or maybe sys.dm_exec_sql_text) as one of them has an example query using the statement offsets.

    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

    September 15, 2015 at 3:17 am

    #1826657

  • RE: Query Optimization/Cleanup

    Kristen-173977 (9/15/2015)

    john_rowles (9/14/2015)

    OnTime = COUNT(CASE WHEN AttendanceReason = 0 THEN 1 END),

    LatePost = COUNT(CASE WHEN AttendanceReason = 1 THEN 1 END),

    PostOut = COUNT(CASE WHEN AttendanceReason = 2 THEN 1 END),

    LateNoPost...

    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

    September 15, 2015 at 3:05 am

    #1826653

  • RE: Move database log files massively

    Gazareth (9/14/2015)

    To avoid downtime, it could be possible to add a new logfile on F to each DB , then issue a shrinkfile with emptyfile on the old one; 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

    September 15, 2015 at 2:59 am

    #1826651

  • RE: Log file management in simple recovery model

    jitendra.padhiyar (9/15/2015)

    But as its not advisable I am looking for any other options. I suggested to change the recovery model to Full and start T-log backup, but client dont want...

    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

    September 15, 2015 at 2:54 am

    #1826650

  • RE: Log file management in simple recovery model

    Kristen-173977 (9/15/2015)

    I think the only reason for this is a long running transaction. Its a heck of a transaction though ...

    Possibly an index rebuild, thought they're minimally logged in simple,...

    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

    September 15, 2015 at 2:53 am

    #1826648

  • RE: Lockdown All Databases Except One

    stanlyn (9/14/2015)

    Our databases and tables can easily tell prying eyes what we are up to, what our next product or service will be, and etc, and that we must protect...

    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

    September 15, 2015 at 2:50 am

    #1826644

  • RE: Lockdown All Databases Except One

    Correct. Public (I believe) by default has the 'View any database' permission, so all logins get that by default (all logins are a member of public). You can deny that...

    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

    September 14, 2015 at 10:20 am

    #1826447

  • RE: Index Fragmentation

    Auto shrink on?

    Manual shrink operation after the index rebuild?

    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

    September 14, 2015 at 10:12 am

    #1826444

  • RE: What is a good system variable that will identify the user who ran the stored proc

    ORIGINAL_LOGIN()

    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

    September 14, 2015 at 10:11 am

    #1826443

  • RE: Lockdown All Databases Except One

    Create them a login. Give that login a user in the database they should be allowed to access. Give the user whatever permissions it should have in the database. Give...

    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

    September 14, 2015 at 9:21 am

    #1826410

  • RE: Log File Info and management

    Never. The log can't be backed up in simple recovery because the log is marked reusable on checkpoint.

    Please take a read through this http://www.sqlservercentral.com/articles/books/94938/ and have a chat with 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

    September 14, 2015 at 9:15 am

    #1826406

  • RE: Log File Info and management

    Kristen-173977 (9/14/2015)

    (we do it differently, setting the source database to READ_ONLY so it is relatively easy to re-mount it if we have a problem with the migration and need 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

    September 14, 2015 at 8:53 am

    #1826398

  • RE: Log File Info and management

    First things first.

    Taking log backups once a day is a bad idea. It means you're exposed to 24 hours of data loss. If that's tolerable, then you could achieve 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

    September 14, 2015 at 8:07 am

    #1826372

  • RE: Are the posted questions getting worse?

    jasona.work (9/14/2015)

    So this week, I may be picking up a new server for my home lab...

    It's a Craigslist deal, being sold by a business near Detroit...

    Dell PowerEdge R900, quad quad-core...

    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

    September 14, 2015 at 7:30 am

    #1826346

  • RE: Transactional log file restore job

    Kristen-173977 (9/12/2015)

    Would Log Shipping help? (although I think that might be deprecated in SQL2014 ?)

    It would, and it is not deprecated.

    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

    September 14, 2015 at 5:35 am

    #1826318

Viewing 15 posts - 4,756 through 4,770 (of 49,552 total)