Forum Replies Created

Viewing 15 posts - 39,916 through 39,930 (of 49,552 total)

  • RE: Multiple Indexes on the Same Columns

    Can you post the index definitions? If they are identical (same columns in the same order) they they're redundant indexes. It could be that they're not quite the same though.

    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 7, 2009 at 7:49 am

    #973362

  • RE: ?how to Monitoring Tablespace status ?

    SQL doesn't have table spaces. That's an Oracle concept. SQL has files and filegroups.

    Are you working with SQL Server? If so, what are you trying to do?

    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 7, 2009 at 7:48 am

    #973361

  • RE: ?how toCreation/deletion of table spaces ?

    SQL doesn't have table spaces. That's an Oracle concept. SQL has files and filegroups.

    Are you working with SQL Server? If so, what are you trying to do?

    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 7, 2009 at 7:47 am

    #973359

  • RE: How to write this SELECT better

    Thang.Nguyen10 (4/7/2009)

    Gila, thanks. I tried this script and it was running amazingly fast, however, just one small difference, I got 3736 rows. And your script gave 96...

    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 7, 2009 at 7:40 am

    #973347

  • RE: Reference 'Deleted' table: Dynamic SQL

    And the audit table please. And the full trigger, since you said you stripped stuff out of 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

    April 7, 2009 at 7:35 am

    #973342

  • RE: Restore Multiple pages

    Krishna Potlakayala (4/7/2009)

    You could also check suspect_pages table in the msdb database, each row represents a suspect page

    Yes, but that assumes that SQL's encountered the suspect page. If checkDB is...

    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 7, 2009 at 7:22 am

    #973327

  • RE: Reference 'Deleted' table: Dynamic SQL

    If you disable it for batches, it invalidates the entire purpose of auditing, but then the trigger's only going to work for one row anyway. Your cursor is over 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

    April 7, 2009 at 7:21 am

    #973324

  • RE: Just Walk Away - Blacklisting - and Twits without Twitter

    Jeff Moden (4/7/2009)

    But then I saw it happen today. One of us made just the smallest snyde remark about helping someone on what was obviously a laundry list...

    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 7, 2009 at 7:16 am

    #973320

  • RE: DDL Triggers - Checking for a user being added to sysadmin

    wmt (4/7/2009)

    I presumed that the DDL_DATABASE_LEVEL_EVENTS error was a bug, as I would've thought that adding/removing users to a role would be a fairly natural auditing requirement

    Well, it is documented...

    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 7, 2009 at 3:33 am

    #973181

  • RE: Persistent index fragmentation

    How big is the index in question? (number of pages)

    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 7, 2009 at 3:23 am

    #973178

  • RE: Index tuning

    MR (4/6/2009)

    I can't save the plan, because its sql server 2000 - but basically it is something like this:

    Please post SQL 2000-related questions in the SQL 2000 forums in 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

    April 7, 2009 at 3:20 am

    #973177

  • RE: DDL Triggers - Checking for a user being added to sysadmin

    It's not a bug, maybe a limitation. The event you mention cannot be used with DDL triggers. It can (iirc) be used with event notifications, so that may be a...

    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 7, 2009 at 3:12 am

    #973172

  • RE: How to return a "start of group" column?

    Sheng (4/6/2009)

    I'm sorry that I havn't checked this thread these days:(

    I'm not under hard-pressure:) Currently, I just design my system to generate this "start of group" column in the client...

    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 7, 2009 at 3:08 am

    #973167

  • RE: Restore Multiple pages

    That's what CheckDB's there for. Preferably run regularly.

    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 7, 2009 at 3:00 am

    #973164

  • RE: Query using Index Scan instead of Index Seek

    kramaswamy (4/6/2009)

    wasn't aware that functions cause indexes to be unusable.

    It's not that functions make indexes unusable, it's that any function on a column (any at all) means that...

    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 6, 2009 at 4:19 pm

    #972971

Viewing 15 posts - 39,916 through 39,930 (of 49,552 total)