Forum Replies Created

Viewing 15 posts - 43,036 through 43,050 (of 49,552 total)

  • RE: Query Plan's

    Can you post the exec plan please?

    There are places where this does happen and isn't a problem. The estimated rows is the estimated rows affected per execution of the operator...

    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 21, 2008 at 11:19 am

    #901807

  • RE: What is better for performance: one covered index or many indexes on single columns

    Well, you can't create an index that contains columns from different tables, so that's not an option.

    Try something like this:

    t1 (col1)

    t2 (col1, col2)

    t3 (col2, col3)

    t4 (col3)

    Include columns would vary depending...

    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 21, 2008 at 11:13 am

    #901804

  • RE: How can I join derived table

    That's not a complete statement.

    Is that part of a SELECT? Part of a SET? Part of an UPDATE?

    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 21, 2008 at 10:54 am

    #901778

  • RE: Error No 3624 on SQl Server 2000

    With assertion failures and stack dumps, you should probably be calling CSS (customer support) as they are likely the only ones who will be able to help you.

    Can you run...

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

    #901446

  • RE: SSN Encryption

    Depends what you're trying to achieve with encryption. Remember that SQL's encryption cannot protect the data against the DBA.

    As for what to encrypt, you need to identify what's sensitive data....

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

    #901444

  • RE: Msg 102, Level 15, State 1, Line 16

    Lynn Pettis (11/20/2008)

    Nevermind, Gail beat me to 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 20, 2008 at 10:07 pm

    #901438

  • RE: Multi file Restore not working

    All you do by backing up to 4 files is stripe the backup over 4 devices. It speeds up backups, nothing more.

    As Alzdba said

    You cannot alter db file separation using...

    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 20, 2008 at 9:55 pm

    #901436

  • RE: wht is wrong in the below cursor ?

    Nandy (11/20/2008)

    I have done some analysis on the issue and found that if there is a one row in the table,then it will insert double the rows in the table...

    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 20, 2008 at 9:50 pm

    #901435

  • RE: available size in the database

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

    No more replies here please. Replies to:

    http://www.sqlservercentral.com/Forums/Topic605967-146-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 20, 2008 at 9:36 pm

    #901427

  • RE: Msg 102, Level 15, State 1, Line 16

    The error's coming from the line after the exec, because there's a variable with no assignment that's sitting there. That said, there are some other more minor issues with 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

    November 20, 2008 at 9:35 pm

    #901426

  • RE: Weired Security Error

    What error?

    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 20, 2008 at 9:16 pm

    #901419

  • RE: Delete rows from the table using cursor

    Nandy (11/20/2008)

    Hi,

    Let me explain the issue, I have written the stored procedure to delete the data from the table based on some certain conditions. To check each row with 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

    November 20, 2008 at 9:14 pm

    #901417

  • RE: Moving Database to another server with a 64 bit OS

    The system resource database must be in the same place as master. Where did you place the new master database?

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

    #901416

  • RE: wht is wrong in the below cursor ?

    bang725 (11/20/2008)

    I want to do further processing on this table that is too by another cursor.

    Not enough information. If you want help, please give us enough info to help 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 20, 2008 at 9:06 pm

    #901414

  • RE: Bypassing the keyword DISTINCT

    Garadin (11/20/2008)

    Indeed. The problem at the moment is that I don't really understand how to read execution plans / see the specifics of which might be better for what...

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

    #901337

Viewing 15 posts - 43,036 through 43,050 (of 49,552 total)