Forum Replies Created

Viewing 15 posts - 43,381 through 43,395 (of 49,552 total)

  • RE: Oracle SQL*Plus to T-SQL

    gints.plivna (11/1/2008)

    GilaMonster (10/3/2008)

    There's no direct equivalent. SQL doesn't have the concept of a row's position in the table.

    BTW rownum has nothing to do with the row position in table. Rownum...

    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 1, 2008 at 2:15 pm

    #892759

  • RE: Poll for Samhain (Halloween)

    Grant Fritchey (11/1/2008)

    Clearly not nearly enough people recall the SQL Server 6.5 sp5/sp5a debacle. You would have a heck of a lot more fear of the SP's when they come...

    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 1, 2008 at 1:21 pm

    #892754

  • RE: Poll for Samhain (Halloween)

    After an encounter with auditors that resulting in the entire DBA team receiving verbal warnings and been threatened with dismissal if we ever allowed an audit to fail again, I...

    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 1, 2008 at 1:18 pm

    #892753

  • RE: Checkpoint frequency: is it possible to configure at database level?

    Bear in mind that if you lessen the checkpoint frequency you're going to increase the impact it has on your system. If it runs less often then when it does...

    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 1, 2008 at 1:10 pm

    #892750

  • RE: if statement after with

    Now things make sense....

    CREATE PROCEDURE [dbo].[LoadGalery]

    (@rowNumber INT)

    AS

    WITH Im AS (

    SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS RowNumber FROM Galery ...

    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 1, 2008 at 4:00 am

    #892701

  • RE: error in select from tempTable

    Continued here - http://www.sqlservercentral.com/Forums/Topic595406-8-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 1, 2008 at 3:54 am

    #892700

  • RE: if statement after with

    dr_csharp (11/1/2008)

    its not good for me,because i need some another field from Im besides count(*) :O(

    i mean i need to select max(rownumber) and other fields but you are going 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

    November 1, 2008 at 3:35 am

    #892697

  • RE: error in select from tempTable

    The first one throws an error because the last select refers to a table that doesn't exist. The derived table myTable is just a named subquery and it doesn't persist...

    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 1, 2008 at 3:31 am

    #892696

  • RE: if statement after with

    Please post in the correct forum in the future. This is the SQL 2000 forum and CTEs doen't exist on SQL 2000

    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 1, 2008 at 3:24 am

    #892694

  • RE: if statement after with

    Try this.

    DECLARE @state BIT

    SET @state='0'

    ;WITH Im AS (

    SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS 'RowNumber' FROM Galery ...

    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 1, 2008 at 3:20 am

    #892693

  • RE: if statement after with

    Does it throw an error? If so, what error? Does it give unexpected results?

    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 1, 2008 at 2:52 am

    #892691

  • RE: T-SQL Code Optimizers

    clive (10/31/2008)

    What is the preferred option, with(nolock) or with(readpast).

    Depends. Do you want to read dirty data or skip locked rows entirely. Better option would be to use neither and make...

    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 1, 2008 at 2:45 am

    #892690

  • RE: Query is in suspended mode

    Suspended indicates that the query is waiting for a resource. It may be a lock, it may be a latch, it may be for an IO to complete, it may...

    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 1, 2008 at 2:45 am

    #892689

  • RE: Transaction log has filled disk drive.

    liam.bell (10/31/2008)

    And this will ultimately remove all transactions from the log file? To which I then have to perform a full database backup?

    No. Shrink file will just change the size...

    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 1, 2008 at 2:35 am

    #892688

  • RE: Re: Database backups and recovery models

    Then set the DB to simple. No point in full if there are no tran log backups

    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 1, 2008 at 2:33 am

    #892687

Viewing 15 posts - 43,381 through 43,395 (of 49,552 total)