Forum Replies Created

Viewing 15 posts - 26,131 through 26,145 (of 49,552 total)

  • RE: What is up with the "Hey Kid Classification"?

    Google is a wonderful tool...

    http://en.wikipedia.org/wiki/Willie_Mays

    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

    May 15, 2011 at 3:58 pm

    #1324794

  • RE: Are both these select statements same?

    Ninja's_RGR'us (5/15/2011)

    In general, it's better to return the correct data.

    *snigger*

    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

    May 15, 2011 at 3:56 pm

    #1324792

  • RE: Are both these select statements same?

    sqldba_icon (5/15/2011)

    i was looking more in general. Thanks

    General performance tuning advice:

    Ensure the queries are written so that they can use indexes

    Ensure the indexes are designed for the queries

    Don't do row-by-row...

    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

    May 15, 2011 at 3:55 pm

    #1324791

  • RE: select from Local Temporary tables: Invalid object name

    Welsh Corgi (5/15/2011)

    Marc Bizzar (5/15/2011)

    "I'd guess the connection is closed and reopened leading to the temp table getting deleted in between."

    Perhaps I'm not understanding you correctly but the issue...

    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

    May 15, 2011 at 11:51 am

    #1324735

  • RE: Migration From MSSQL 2008 to MSSQL 2008R2

    Syed Jahanzaib Bin hassan (5/15/2011)

    64-Bit system processing is much faster than 32-bit

    That is a myth. 64-bit is not about better performance, it's about flat memory addressing up to the maximum...

    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

    May 15, 2011 at 7:13 am

    #1324690

  • RE: SQL Server and TSQL Technical Questions for an Interview

    chapman8790 (5/15/2011)

    If anyone could suggest what sort of questions might be asked, either from a recent interview or from an interviewers point of view, and also how i should prepare...

    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

    May 15, 2011 at 5:59 am

    #1324684

  • RE: After Update Trigger Only Fired for the first record in the IN close

    Exactly what I thought

    Nawar.Tabaa (5/15/2011)

    SELECT @WaybillId = [WaybillId],

    @StatusId = [CurrentStatus],

    @ActionBy = [LastActionBy]

    FROM inserted

    That assumes...

    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

    May 15, 2011 at 5:55 am

    #1324682

  • RE: Dont understand which version I am using ??

    If the database it attached to the 2008 R2 server, it is a 2008 R2 database. Always.

    p.s. Developer edition or Enterprise?

    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

    May 15, 2011 at 2:20 am

    #1324669

  • RE: Is there a way to avoid index scan in "Case" statements?

    Post the query, post the indexes

    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

    May 15, 2011 at 2:19 am

    #1324668

  • RE: After Update Trigger Only Fired for the first record in the IN close

    My guess, the trigger is not written to handle multi-row updates. It probably assumes there'll only ever be a single row updated at a time and hence a single row...

    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

    May 15, 2011 at 2:16 am

    #1324667

  • RE: sql server gets recycled autimatically

    Welsh Corgi (5/14/2011)

    Try setting the recovery model of tempdb to simple so that the space can automatically be reclaimed.

    TempDB is always in Simple recovery. Any attempt to change it returns...

    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

    May 14, 2011 at 2:37 pm

    #1324650

  • RE: sql server time out and memory dumps

    I'm kinda curious as to why you ran DBCC Page. What that returns is the contents of the data page. Other than the object id and index id (which are...

    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

    May 14, 2011 at 2:34 pm

    #1324649

  • RE: SQL Class question

    Is the server or domain called SQLServer?

    Oh, and as the comment says, these need to be run at the command prompt, not in a SQL query window.

    -- In a Command...

    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

    May 13, 2011 at 3:44 pm

    #1324573

  • RE: Order of Tables in a Query

    Terry Low-350996 (5/13/2011)

    The correct sequence that SQL uses internally to process the clauses in an SQL query:

    FROM, [JOIN CONDITION, JOIN TABLE...], WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, TOP

    SQL...

    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

    May 13, 2011 at 1:31 pm

    #1324541

  • RE: Trouble Declaring a Variable in a Stored Procedure

    Garadin (5/13/2011)

    Thanks for noting that Gail. I knew you needed to add a RECOMPILE but was incorrect in thinking that WITH RECOMPILE (which I've been using) worked the same...

    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

    May 13, 2011 at 1:27 pm

    #1324540

Viewing 15 posts - 26,131 through 26,145 (of 49,552 total)