Forum Replies Created

Viewing 15 posts - 22,276 through 22,290 (of 49,552 total)

  • RE: Loop Keyword in SQL-BY SHUBHAM@INVENTIVE INFORMATICS BAREILLy

    shubham.saxena67 (11/12/2011)

    :crazy: ... That is what I want to convey...

    Plz send me sample sql statement about this...

    The LOOP keyword has nothing to do with control flow loops. It's a query...

    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

    November 12, 2011 at 5:19 am

    #1406687

  • RE: help help help

    bijarcity (11/12/2011)

    but on the network if my clients want to report something my application shows a log in form and it needs user and password of sa.

    I do hope 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

    November 12, 2011 at 5:17 am

    #1406685

  • RE: Loop Keyword in SQL SERVER-BY-SHUBHAM SAXENA @INVENTIVE INFORMATICS

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

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

    November 12, 2011 at 5:13 am

    #1406679

  • RE: Loop Keyword in SQL-BY SHUBHAM@INVENTIVE INFORMATICS BAREILLy

    shubham.saxena67 (11/12/2011)

    As u know that each keyword that is reserved shows with blue color

    and LOOP also shows with Blue color within query analyzer..that's why i am

    asking.

    It is a keyword, but...

    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

    November 12, 2011 at 5:10 am

    #1406677

  • RE: tempdb 35 GB using by query statement- Help

    Why can't you take an execution plan? Did you read the article I referenced?

    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

    November 12, 2011 at 4:56 am

    #1406674

  • RE: tempdb 35 GB using by query statement- Help

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    10 lacks is how many?

    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

    November 12, 2011 at 2:12 am

    #1406653

  • RE: Deadlocks

    BSavoie (11/11/2011)

    Wow, thank you Gail. Chapter 42 is the clearest, most straight forward explanation I've ever seen regarding deadlocks. I would highly recommend it to anyone looking to deal with...

    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

    November 12, 2011 at 1:47 am

    #1406652

  • RE: PageLatch_SH waittime drastically increases

    Sorry, can't find and it's late, but start with this DMV, it's at the core of tempDB monitoring

    sys.dm_db_task_space_usage

    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

    November 11, 2011 at 3:45 pm

    #1406612

  • RE: BAckup job details of last one week

    the sysbackup* tables (there are a few of them), sysscheduled (hard to decode, not well documented)

    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

    November 11, 2011 at 3:39 pm

    #1406611

  • RE: PageLatch_SH waittime drastically increases

    Lilsamp (11/11/2011)

    For example, if the wait type was IO related, then I could look for heavy IO queries. What do you look for when trying to track down PageLatch_SH...

    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

    November 11, 2011 at 3:38 pm

    #1406609

  • RE: PageLatch_SH waittime drastically increases

    Lilsamp (11/11/2011)

    We just migrated over to a new server and EqualLogic disk array with SSD and 10K SAS drives. So, I was hoping to get rid of any tempdb...

    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

    November 11, 2011 at 2:27 pm

    #1406601

  • RE: Decoding the keys for LCK_M_X wait type

    That script's correct. Just make sure you're in database 10 when you run 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

    November 11, 2011 at 2:21 pm

    #1406598

  • RE: alter index rebuild or reorganize?

    Nadrek (11/11/2011)

    Note that the few scripts I've seen with something like @TimeLimit do not tend to have code to prevent starting a 5 hour defrag of an enormous table 15...

    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

    November 11, 2011 at 1:33 pm

    #1406582

  • RE: Deadlocks

    BSavoie (11/11/2011)

    Thanks all for the great info. Sounds like I need to educate myself on deadlock graphs. I just happen to have the SQL Server MVP Deep Dives book 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

    November 11, 2011 at 12:34 pm

    #1406556

  • RE: Stored proc, deadlocking after a minor change, but nothing has changed on the deadlocking T-SQL statement

    dooh.register (11/11/2011)

    Try to use scope_identity() instead of @@IDENTITY. scope_identity() is session wide. @@IDENTITY is global and it may be source of your problems.

    @@Identity is not global. It's the last identity...

    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

    November 11, 2011 at 12:33 pm

    #1406555

Viewing 15 posts - 22,276 through 22,290 (of 49,552 total)