Forum Replies Created

Viewing 15 posts - 8,356 through 8,370 (of 49,552 total)

  • RE: Database is in Recovery Pending Status

    Divine Flame (7/24/2014)

    You should see somthing like "Recovering the database ...." & along the line it will also tell you the % of recovery completed. Wait for it to complete....

    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 24, 2014 at 10:58 am

    #1732155

  • RE: What causes my log size to get bigger ? Difference btw dbcc opentran and Select * from sysprocesses where open_tran>0

    http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

    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 24, 2014 at 2:51 am

    #1732035

  • RE: how to call dynamic query stored procedure in select statement

    In short, you can't do that.

    You'll need to either run the proc within a cursor, store the results into a temp table (insert into <table name> exec <proc>) or identify...

    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 23, 2014 at 3:14 pm

    #1731961

  • RE: IN / JOIN / EXISTS giving same performance in a query.

    ChrisM@Work (7/23/2014)

    http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/[/url]

    And the pertinent quote from there is 'very slightly'. The differences between join and in/exists were very slight.

    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 23, 2014 at 11:48 am

    #1731882

  • RE: Downgrading from SQL Server 2014 to SQL Server 2012

    As has been stated...

    You need the 2012 installation media. If you bought SQL 2014 with downgrade rights, contact whoever you bought it from and ask for the 2012 iso, once...

    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 23, 2014 at 11:46 am

    #1731877

  • RE: RESTORE DATABASE - BUFFERCOUNT

    No, of course not. If that was the case, how would a restore ever work for a database larger than physical memory?

    They're buffers, in the normal computer science definition of...

    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 22, 2014 at 3:16 pm

    #1731597

  • RE: Dbcc checkdb says 0 errors but SQL error 823 produced

    Hence the standard recommendation to run DBCC UpdateUsage when upgrading a DB. And 2008 still has incorrect counts occasionally.

    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 22, 2014 at 3:13 pm

    #1731596

  • RE: TempDB Avg Wait Times

    And what are you running/using to get 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

    July 22, 2014 at 1:20 pm

    #1731571

  • RE: TempDB Avg Wait Times

    What exactly do you mean by a 'TempDB wait'?

    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 22, 2014 at 1:17 pm

    #1731569

  • RE: Dbcc checkdb says 0 errors but SQL error 823 produced

    Please note: 2 year old thread.

    Edit: and checkDB does not require users to be disconnected, it's an online operation.

    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 22, 2014 at 1:11 pm

    #1731566

  • RE: RESTORE DATABASE - BUFFERCOUNT

    http://sirsql.net/blog/2011/9/26/optimizing-database-restores.html

    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 22, 2014 at 1:10 pm

    #1731564

  • RE: Tempdb not releasing the space

    No. Won't do anything.

    If you may run that operation again, leave TempDB as-is, unless you are major out of disk space now.

    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 22, 2014 at 1:03 pm

    #1731561

  • RE: Tempdb not releasing the space

    Why do you want 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 22, 2014 at 10:27 am

    #1731495

  • RE: 1 Quick question for all the DBA's

    New Born DBA (7/22/2014)1) I haven't set up any alerts on the system since all the alerts are in place?(I am hoping that they are in place, but 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

    July 22, 2014 at 10:18 am

    #1731490

  • RE: Are the posted questions getting worse?

    That was one of Rodney's photos (most of which are great)

    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 22, 2014 at 9:30 am

    #1731476

Viewing 15 posts - 8,356 through 8,370 (of 49,552 total)