Forum Replies Created

Viewing 15 posts - 15,301 through 15,315 (of 49,552 total)

  • RE: How to solve blocking issue

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapters 6 and 7

    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

    December 10, 2012 at 10:36 am

    #1567114

  • RE: Which table join should I use

    I would recommend you get into the habit of qualifying your columns names

    DELETE FROM Despatch

    WHERE Despatch.ordno NOT IN

    (SELECT Order.ordno FROM Order)

    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

    December 10, 2012 at 7:02 am

    #1567023

  • RE: detach multiple databases using sp_detach_db

    sri6sri6 (12/10/2012)

    I ahve modified the querry as the execution satement was missing in it.

    It wasn't missing. The script you refer to generated the sp_detach statements, allowing someone to copy 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

    December 10, 2012 at 6:59 am

    #1567019

  • RE: Memory usage

    Jeff Moden (12/10/2012)

    In that case, the number of page reads has a direct correlation to the number of and "age" (they empty space may have be inserted to) 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

    December 10, 2012 at 6:22 am

    #1567000

  • RE: Sorting - Custom Based.

    If those 2 columns are in a table, then

    SELECT name FROM SomeTable ORDER BY sortorder

    No CTE required

    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

    December 10, 2012 at 5:44 am

    #1566993

  • RE: DB gone offline

    Hemant.R (12/10/2012)

    also in case your missing mdf or ldf missing .

    Missing files will not result in the DB being in the offline state. They result in the Recovery_Pending state if...

    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

    December 10, 2012 at 4:18 am

    #1566969

  • RE: Which system trigger fires?

    Nope, that's not something you'd use a trigger for. That's something you'd probably use an extended events sessions for, or SQL Trace if you're using SQL 2005 or below.

    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

    December 10, 2012 at 4:16 am

    #1566968

  • RE: what is the use of dbo.dtproperties, can this be deleted?

    asir83 (12/10/2012)

    Wanted to know if this table can be deleted & will impact any other process?

    If you delete it then anyone who's created a database diagram (from SSMS) will lose...

    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

    December 10, 2012 at 4:14 am

    #1566967

  • RE: Appropriate range for partitioning

    If you are partitioning with the idea that queries are automatically faster on partitioned tables, don't waste your time.

    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

    December 10, 2012 at 2:44 am

    #1566943

  • RE: Blocking Situation

    You see all the locks that are held.

    If the select's session was holding an IS (from an open transaction and previous statements), that's enough to block the index rebuild. Everything...

    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

    December 10, 2012 at 2:29 am

    #1566939

  • RE: what is the use of dbo.dtproperties, can this be deleted?

    It's created when someone creates a database diagram

    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

    December 10, 2012 at 2:20 am

    #1566935

  • RE: Blocking Situation

    What locks was it holding?

    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

    December 10, 2012 at 2:15 am

    #1566933

  • RE: Log backup question

    DBA24 (12/9/2012)

    My transaction log backup today took longer time to complete than usual. Daily it runs at 1:00PM for about 2 mins and today it took like almost 2 hours....

    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

    December 10, 2012 at 1:35 am

    #1566926

  • RE: Blocking Situation

    What was session 88 doing?

    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

    December 10, 2012 at 1:33 am

    #1566925

  • RE: How to check when was the last Time re-indexing was performed on a DB

    CheckDB won't tell you the last time an index was rebuilt (however you need to run it regularly).

    That information isn't stored by default. If you're running a reindexing job, you...

    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

    December 10, 2012 at 1:32 am

    #1566924

Viewing 15 posts - 15,301 through 15,315 (of 49,552 total)