Forum Replies Created

Viewing 15 posts - 14,371 through 14,385 (of 49,552 total)

  • RE: tempdb question

    No.

    http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-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

    February 7, 2013 at 1:44 pm

    #1585659

  • RE: My first UDF doesn't work. Thoughts?

    Yes and yes (to your last two questions)

    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

    February 7, 2013 at 12:13 pm

    #1585621

  • RE: log backup very large after full backup

    Rambler (2/7/2013)

    Hi. Using SQL 2008 R2 Web edition, we're doing daily full backup of all databases (at night), followed by log backup every hour.

    The problem is that for some 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

    February 7, 2013 at 12:09 pm

    #1585618

  • RE: Log Shipping Simple question re: full backup involvement

    sotn (2/7/2013)

    That is where I am confused, as I thought that a FULL backup which does not perform a Tlog backup as such, does affect the transactions so there 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

    February 7, 2013 at 12:00 pm

    #1585607

  • RE: Database in Recovery mode from last 7 days.

    anthony.green (2/7/2013)

    Someone restore the DB and not issue a RECOVERY command?

    Someone backup the tail log and issues with NORECOVERY?

    Both result in the RESTORING state, not the RECOVERING state.

    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

    February 7, 2013 at 8:31 am

    #1585468

  • RE: Database in Recovery mode from last 7 days.

    Suresh B. (2/7/2013)

    The message in the SQL Server log might not be related the database status.

    Is the database Log-Shipped (Secondary Server)?

    Following command is used to bring the database online:

    RESTORE DATABASE...

    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

    February 7, 2013 at 8:25 am

    #1585462

  • RE: Log Shipping Simple question re: full backup involvement

    How would those transactions appear at the log shipping secondary if the log backups aren't running?

    Log shipping means backup log, copy log, apply log, there's no other factor involved...

    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

    February 7, 2013 at 8:24 am

    #1585461

  • RE: To Re-index all indexes for a table.

    Err... even ignoring that the connection that SSMS uses to display the dialog won't be a system thread and that the spid < 50 mean system is no longer true...

    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

    February 7, 2013 at 8:22 am

    #1585459

  • RE: To Re-index all indexes for a table.

    Ignore the GUI, it's half-broken.

    Query sys.dm_db_index_physical_stats for that table, that'll give you all the info the gui would.

    To rebuild - ALTER INDEX ALL ON <table> 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

    February 7, 2013 at 1:50 am

    #1585260

  • RE: Record locking

    L' Eomot Inversé (2/6/2013)

    I'll refrain from giving in to my hatred of VB and suggesting you ditch VB and switch to either C# or Jscript.

    It's an MS Access form, 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

    February 6, 2013 at 2:45 pm

    #1585143

  • RE: Are the posted questions getting worse?

    Can someone capable of spelling VBA maybe take a look here?

    http://www.sqlservercentral.com/Forums/FindPost1416549.aspx

    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

    February 6, 2013 at 12:54 pm

    #1585107

  • RE: Severe error occurred on the current command. How bad is corruption fix?

    Just run the CheckDB. If it was a NC index I'd say drop and recreate, but a cluster that's a lot of time and a lot of log usage, you're...

    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

    February 6, 2013 at 12:52 pm

    #1585104

  • RE: Database performance issue

    Please note: 3 year old thread

    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

    February 6, 2013 at 11:07 am

    #1585065

  • RE: Wait Statistics Query

    That query returns information relating to the waiting task.

    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

    February 6, 2013 at 9:51 am

    #1585033

  • RE: Parameterized table names?

    Nope.

    To be honest, that's something I strongly recommend against. It's a pain, it's a security hole if you're not incredibly careful and it suggests bad design (you wouldn't write 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

    February 6, 2013 at 9:50 am

    #1585031

Viewing 15 posts - 14,371 through 14,385 (of 49,552 total)