Forum Replies Created

Viewing 15 posts - 48,751 through 48,765 (of 49,552 total)

  • RE: Restore Database to another server

    Is there enough space on the drive?

    Is the drive (or folder) read only or encrypted?

    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

    March 27, 2007 at 3:07 am

    #697076

  • RE: Performance gap between two seemingly identical databases

    Are the statistics up to date on both databases? Are the indexes on one more fragmented than on he other?

    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

    March 27, 2007 at 1:45 am

    #697062

  • RE: function for current transaction....

    Pleasure

    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

    March 27, 2007 at 12:12 am

    #697053

  • RE: Distinct with no order

    I saw your example. Why 3,1,2. why not 2,1,3?

    As I said, if you want to have data in a specific order (whatever it may be) you have to specify an...

    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

    March 26, 2007 at 4:48 am

    #696838

  • RE: Distinct with no order

    What do you mean by 'no order'?

    If you want your data back in a specific order, you must specify an order by clause. Otherwise it comes back however 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

    March 26, 2007 at 3:30 am

    #696824

  • RE: Old editing...

    Or maybe what I've seen on a lot of other forums. The text bix to enter the new post is at the top of the page and all the other...

    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

    March 23, 2007 at 5:58 am

    #696578

  • RE: divide by zero, but no fields are zero

    Try this way indstead. Aside from the divide by zero, it's better for index selection (if you have appropriate indexes)

    Select *

    from table t

    where t.value_a > 10*t.value_b

    AND t.value_c...

    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

    March 21, 2007 at 11:08 am

    #696216

  • RE: function for current transaction....

    Or you can use sys.dm_exec_requests and pass the SQL handle to the sys.dm_exec_sql_text function and get the entire sql statement. (DBCC Inputbuffer only displays the first 255 characters)

    select * 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

    March 21, 2007 at 5:25 am

    #696110

  • RE: please help me with this index problem..??

    That's not ideal either because, at optimisation, the query optimiser can't evaluate the first half of the or. SQL doesn't have short circuit evaluation

    The only way I've managed to deal...

    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

    March 21, 2007 at 3:46 am

    #696104

  • RE: SQL Server 2005 Adoption

    Don't know about the global parameters, I don't think we use them. Our DTS packages are mainly complex data flows.

    What we decided to do was to ensure that the people who...

    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

    March 20, 2007 at 7:10 am

    #695909

  • RE: SQL Server 2005 Adoption

    Not sure if this is addressed to me or not, but I'll answer.

    No, we're not using SSIS to exec the DTS packages. We imported the DTS packages as legacy objects...

    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

    March 20, 2007 at 6:57 am

    #695902

  • RE: SQL Server 2005 Adoption

    Unable to execute DTS jobs migrated to Version 2005...Arg!!!!!!  The learning curve for SSIS is VERY steep...I have to re-write every DTS package in 2005 before I can migrate

    What problems...

    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

    March 20, 2007 at 4:33 am

    #695871

  • RE: Help finding a dummy row...

    Try this. It's not tested, but should work. It depends on the dummy course been the only one that all students take.

    SELECT

    *

    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

    March 16, 2007 at 2:25 am

    #695399

  • RE: Help finding a dummy row...

    There's nothing else? Foreign key? Flag anywhere?

    It's doable, but it's not going to be a nice query. Let me see what I can come up 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

    March 16, 2007 at 12:21 am

    #695394

  • RE: Help.....This runs so slow

    Remove the distinct from the in. x in (1,2,2,2,2,5) and x in (1,2,5) are equivalent.

    Make sure you have an index on SKey and FTSKey.

    Also, try the query as a left...

    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

    March 15, 2007 at 10:21 am

    #695281

Viewing 15 posts - 48,751 through 48,765 (of 49,552 total)