Forum Replies Created

Viewing 15 posts - 21,286 through 21,300 (of 49,552 total)

  • RE: query assistance

    Look up the section on PIVOT in Books Online.

    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

    January 6, 2012 at 11:19 am

    #1429771

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/6/2012)

    Brandie Tarvin (1/6/2012)

    Evil Kraig F (1/5/2012)

    One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under 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

    January 6, 2012 at 11:04 am

    #1429766

  • RE: Managing Transaction Logs

    Good luck in you search. In the meantime, may I suggest this? http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    January 6, 2012 at 10:57 am

    #1429760

  • RE: Are the posted questions getting worse?

    MysteryJimbo (1/6/2012)

    GilaMonster (1/6/2012)

    And vague question of the week award goes to: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169885

    I don't know. This is pretty vague.

    http://www.sqlservercentral.com/Forums/Topic1231424-1549-1.aspx

    Ow, I didn't see that one. What do people expect when they...

    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

    January 6, 2012 at 10:43 am

    #1429754

  • RE: Are the posted questions getting worse?

    And vague question of the week award goes to: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169885

    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

    January 6, 2012 at 10:07 am

    #1429738

  • RE: SSMS Client

    http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/28/getting-graphical-showplan-back-in-sql-server-2008-r2.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

    January 6, 2012 at 9:22 am

    #1429710

  • RE: SQL coding techniques

    The join clause is for joins (how one table relates to the other), unless dealing with outer joins and wanting the table filtered before the join.

    Filters belong in the where...

    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

    January 6, 2012 at 8:41 am

    #1429676

  • RE: and the deadlocks are back...

    Sapen (1/6/2012)

    Looking at my deadlock graph and the isolationlevel being serializable which query is using the isolation level as serializable? the update or select?

    Both.

    per my assumption the isolation levels...

    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

    January 6, 2012 at 8:37 am

    #1429669

  • RE: logical views

    Views are nothing more than saved select statements. They're inlined into the query during parsing and executed as part of the full query.

    You'd tune it the way you tune any...

    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

    January 6, 2012 at 4:25 am

    #1429545

  • RE: Regarding using VARCHAR(MAX)

    Varchar(max) is for columns with data > 8000 characters. If you have a column with max 500 characters, that's a varchar(500).

    Same reason we don't use bigint to store numbers between...

    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

    January 6, 2012 at 4:12 am

    #1429534

  • RE: Need TRAINING ON TUNING STORED PROCEDURES

    How much training do you want and what are you willing to pay?

    To give you an idea, I charge $100/hour (and I'm probably on the cheap side of what you'll...

    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

    January 6, 2012 at 2:37 am

    #1429491

  • RE: which sp's are using

    There are no DMVs that store procedure usage info. Some people suggest using the plan cache, but that is fraught with problems - plans could have been aged out, 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

    January 6, 2012 at 2:35 am

    #1429490

  • RE: Are the posted questions getting worse?

    I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:

    INSURANCECAMPAIGNREVIEW_STARTDATE

    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

    January 6, 2012 at 2:32 am

    #1429488

  • RE: failed 70-668 exam

    terrence.2011 (1/6/2012)

    I studied the online materials but many of questions are outdated,someone said this exam had been changed questions.is that true?who has the latest questions?Thanks!

    If by 'online materials' and 'latest...

    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

    January 6, 2012 at 2:31 am

    #1429487

  • RE: Cannot shrink log file

    Why can't you delete the local publication?

    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

    January 5, 2012 at 4:16 pm

    #1429409

Viewing 15 posts - 21,286 through 21,300 (of 49,552 total)