Forum Replies Created

Viewing 15 posts - 24,601 through 24,615 (of 49,552 total)

  • RE: SQL Server Log data missing

    SQLRO (7/29/2011)

    I wonder why the data is lost from both the log file(as the log reader software does not show any log entry) and data file.

    Records are NEVER removed from...

    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 29, 2011 at 7:27 am

    #1360788

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (7/29/2011)

    Ugh. Another copyright violation.

    http://www.sqlservercentral.com/Forums/Topic1150675-391-1.aspx?Update=1

    Original article:

    http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html

    Thanks, I was going to spend the afternoon tearing it apart. Lots of bad info in there.

    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 29, 2011 at 7:22 am

    #1360779

  • RE: Microsoft Certified Master

    talkeffect (7/29/2011)

    How is Knowledge Exam? Is it like 70-451 and 70-450 or a little bit harder?

    Try several hundred times harder. It's also significantly more expensive. iirc $500 for the knowledge...

    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 29, 2011 at 7:21 am

    #1360777

  • RE: Missing indexes and Frequently used Queries

    Lavanyasri (7/29/2011)

    I am expecting scripts .. can you provide any scripts to find the missing indexes and frequently used queries ???

    I'm expecting please and thank you, but I'm frequently disappointed.

    There...

    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 29, 2011 at 7:17 am

    #1360771

  • RE: Seesion ids are suspended

    Have you searched the script library here? Have you searched with google for one?

    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 29, 2011 at 1:39 am

    #1360576

  • RE: Can I kill any one of deadlocked process?

    forsqlserver (7/29/2011)

    Suresh can u explore how to set deadlock_prority

    Did you look in Books Online? It is documented quite well.

    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 29, 2011 at 1:22 am

    #1360569

  • RE: Seesion ids are suspended

    System processes are supposed to be waiting most of the time. They're waiting for stuff to do, when the find stuff to do, they wake up, do it and 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 29, 2011 at 1:21 am

    #1360568

  • RE: using dbcc commands

    You can. Some you must, so you run only for specific reasons, some you can find other options.

    DBCC showcontig is deprecated, use sys.dm_db_index_physical_stats

    DBCC indexdefrag is deprecated, use ALTER INDEX ......

    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 28, 2011 at 12:45 pm

    #1360413

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (7/28/2011)I've never selected it because I never understood it. I never tried to find out what it does because backups seemed to do everything I needed without 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

    July 28, 2011 at 12:40 pm

    #1360407

  • RE: 1 DB and 2 Servers

    p.s. Check with your licensing provider or with MS licensing. The cost of getting this wrong is not small (audits and fines)

    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 28, 2011 at 12:37 pm

    #1360406

  • RE: Are the posted questions getting worse?

    SQLkiwi (7/28/2011)

    GilaMonster (7/28/2011)

    The 'backup the tail of the log' option has no place in maint plans. Shouldn't be there, absolutely no reason to ever select it and a nasty trap...

    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 28, 2011 at 12:25 pm

    #1360400

  • RE: 1 DB and 2 Servers

    ajsnyman (7/28/2011)

    Something sounds off, I can understand to pay for each user accessing SQL even via a web service due to a connection being made to the SQL, but 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 28, 2011 at 12:17 pm

    #1360395

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/28/2011)

    Now this is funny if this is what I think it is!

    http://www.sqlservercentral.com/Forums/Topic1149828-391-1.aspx

    The 'backup the tail of the log' option has no place in maint plans. Shouldn't be there, absolutely...

    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 28, 2011 at 12:09 pm

    #1360389

  • RE: Additional index needed?

    Ninja's_RGR'us (7/28/2011)

    With that distribution I'd really go with PK : SKU, endt

    Then clustered on the date.

    Agreed.

    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 28, 2011 at 10:49 am

    #1360324

  • RE: Additional index needed?

    Queries that filter on End_dt alone can seek on the primary key index. Queries that filter on End_dt and on ITEM_NUM can seek on the primary key index. Queries 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 28, 2011 at 10:19 am

    #1360289

Viewing 15 posts - 24,601 through 24,615 (of 49,552 total)