Forum Replies Created

Viewing 15 posts - 28,966 through 28,980 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/8/2010)

    Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you 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

    December 8, 2010 at 2:27 pm

    #1260322

  • RE: HOW TO RECOVER DATABASE

    azad maratha (12/8/2010)

    when we run repair command,the corrupt pages get deallocated.

    it means these pages get back to the disk.

    No, it means those pages are no longer part of any objects...

    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 8, 2010 at 9:53 am

    #1260190

  • RE: database is slow

    Ask them exactly what is slow - what app, what portion, doing what, etc.

    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 8, 2010 at 8:18 am

    #1260116

  • RE: sys.syscacheobjects and sys.objects

    I've tried that many times, and if the plan is for an object (as opposed to ad-hoc SQL), it works fine.

    Are you not maybe in the context of the wrong...

    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 8, 2010 at 8:10 am

    #1260115

  • RE: Backup error on network drive

    Please post new questions in a new thread. Thank 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 8, 2010 at 8:05 am

    #1260114

  • RE: Service Pack information

    I don't believe there's any record within sQL as to when the patches are applied, just which one the system is running on.

    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 8, 2010 at 4:48 am

    #1260005

  • RE: SUB QUERY RETURNED MORE THAN ONE VALUE

    SELECT TOP 100 ADDRESSLINE1 FROM MST_ADDRESS ma WHERE EXISTS

    (SELECT 1 FROM DIGITLOOKUPS.dbo.INPROGRESS_POBOX_EXCLUSION_LOOKUP pel WHERE ms.ADDRESSLINE1 LIKE pel.KEY_WORD+'%')

    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 8, 2010 at 4:39 am

    #1260001

  • RE: sys.syscacheobjects and sys.objects

    Cross apply to sys.dm_exec_sql_text. If the plan is from a procedure, the object-id column in there will give the object_id of that procedure. Join to sys.procedures for the name.

    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 8, 2010 at 4:18 am

    #1259996

  • RE: Trigger

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1031703-391-1.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

    December 8, 2010 at 4:14 am

    #1259995

  • RE: corrupt model database

    Restore from a clean 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

    December 8, 2010 at 4:14 am

    #1259994

  • RE: Slow running query

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 8, 2010 at 3:18 am

    #1259969

  • RE: sys.syscacheobjects and sys.objects

    syscacheobjects is deprecated, will be removed in a future version of SQL and should not be used. Besides, you can't get the exec plan from it. sysobjects is also...

    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 8, 2010 at 3:17 am

    #1259968

  • RE: what size should i set on the comment column

    Are you expecting unicode data?

    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 8, 2010 at 12:56 am

    #1259934

  • RE: Error in the function that i developed

    This is returning more than one row

    select max(coursefees)-sum(fee.amount)

    from feespaid fee,batch

    where

    substring(cast(fee.rollno as varchar(50)) ,1,2)=substring(cast(batchcode as varchar(50)),1,2) and

    rollno = @prollno

    group by rollno,batchcode

    If you're going to use it the way you are, 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

    December 7, 2010 at 11:05 pm

    #1259914

  • RE: Are the posted questions getting worse?

    Tom.Thomson (12/7/2010)

    Brandie Tarvin (12/7/2010)

    I have to wonder if this thread is encouraging people to respond more harshly to articles, posts, etc. Certain we've seen an uptick amongst ourselves of bashing...

    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 7, 2010 at 10:58 pm

    #1259913

Viewing 15 posts - 28,966 through 28,980 (of 49,552 total)