Forum Replies Created

Viewing 15 posts - 39,451 through 39,465 (of 49,552 total)

  • RE: Code level changes while migration from SQL Server 2000 to SQL Server 2005

    sk.panda (4/28/2009)

    Please advise me if you know any exact code compatibilty senario while migrating to sql server 2005.

    Did you look at the link that Grant gave?

    There are a lot of...

    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

    April 28, 2009 at 2:28 am

    #984882

  • RE: max() min() Query Plan

    vlad (4/27/2009)

    I was hoping for an Index Seek, alas it's a Scan, but Why ??

    Because a seek requires a predicate, something to seek on, and neither of your queries has...

    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

    April 27, 2009 at 2:53 pm

    #984700

  • RE: Silly optimization question - ALTER PROCEDURE and RECOMPILE

    Mike Baria (4/27/2009)

    I wasn't really thinking that indexes would be useless because of the potential sproc recompile, but that the cost to the overall job might outweigh the gain 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

    April 27, 2009 at 2:19 pm

    #984680

  • RE: 70-432 Exam

    Steve Jones - Editor (4/27/2009)

    Prometric and Vue are the testing places.

    Is Vue still running the MS exams over in the US? I thought MS dropped them completely a couple years...

    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

    April 27, 2009 at 1:54 pm

    #984651

  • RE: Update statistics only to specific tables and columns

    Since you know what tables and columns are involved, just do an explicit UPDATE STATISTICS for the tables and the stats that you want to update.

    UPDATE STATISTICS <Table Name> <Statistics...

    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

    April 27, 2009 at 1:42 pm

    #984635

  • RE: Silly optimization question - ALTER PROCEDURE and RECOMPILE

    Mike Baria (4/27/2009)

    First question (an easy one): Do existing sprocs get marked for recomiplation automatically after they have been ALTERED? It seems like they should, but I don't...

    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

    April 27, 2009 at 1:23 pm

    #984626

  • RE: Report with huge data

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

    April 27, 2009 at 1:16 pm

    #984620

  • RE: DBCC & maintanence of Sql Database

    Look up DBCC DBReindex in the SQL books online.

    Please in the future don't use polls for simple questions.

    Thanks

    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

    April 27, 2009 at 1:15 pm

    #984619

  • RE: timestamp data type

    http://msdn.microsoft.com/en-us/library/ms182776(SQL.90).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

    April 27, 2009 at 1:14 pm

    #984617

  • RE: 70-432 Exam

    http://www.prometric.com

    You should be able to search for exam centres and book 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

    April 27, 2009 at 1:14 pm

    #984616

  • RE: SP

    Fixes in SP3 - http://support.microsoft.com/?kbid=955706

    Fixes in SP2 - http://support.microsoft.com/?kbid=921896

    Fixes in SP1 - http://support.microsoft.com/?kbid=913090

    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

    April 27, 2009 at 11:29 am

    #984532

  • RE: Dynamic query help

    Also, why a cursor? Unless I've missed something, the entire thing, cursor and all can be replaces by this:

    UPDATE t1 SET

    t1.Sat = CASE WHEN t2.Day_To_Receive = 'Saturday' THEN 1 ELSE...

    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

    April 27, 2009 at 10:55 am

    #984511

  • RE: Dynamic query help

    You need some brackets in the exec statement.

    Change

    EXEC @CMD

    to

    EXEC (@CMD)

    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

    April 27, 2009 at 10:50 am

    #984502

  • RE: Some deleted tables in the db,is there way to roll them back

    No.

    If you have no backup at all, even the transaction log won't have that information in it as it auto-truncates regularly. Hence no log reader tool will work. There's no...

    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

    April 27, 2009 at 10:30 am

    #984487

  • RE: Abusing Table Variables?

    Mohit (4/27/2009)

    So question, when the plan gets creating using table variables? How long do the plans stay in cache?

    Exactly the same as for any other query.

    Plan gets created when...

    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

    April 27, 2009 at 10:20 am

    #984478

Viewing 15 posts - 39,451 through 39,465 (of 49,552 total)