Forum Replies Created

Viewing 15 posts - 44,641 through 44,655 (of 49,552 total)

  • RE: can I have composite index on identity column?

    You can. Whether it will be useful or not is another matter.

    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

    September 8, 2008 at 8:10 am

    #868459

  • RE: Clarification!

    I'll be blunt, as usual.

    Dumps are cheating. Get your hands on one of the training kits for the exam and work your way through it. People cheating their way through...

    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

    September 8, 2008 at 8:05 am

    #868455

  • RE: Regarding Two Database

    Sorry, I didn't understand that. Could you please explain a bit more what you're 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

    September 8, 2008 at 1:33 am

    #868310

  • RE: error handling in sql

    Could you be a little more specific on what you want please?

    Next time, please post in the appropriate forum, not an article discussion forum.

    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

    September 8, 2008 at 1:03 am

    #868305

  • RE: Unable to create index on table when DB is set auto shrink

    Turn autoshrink off!

    Autoshrink doesn't just shrink the log file, it shrinks the data file as well. Shrinking data files causes index fragmentation. The next time data gets added, the 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

    September 8, 2008 at 12:56 am

    #868303

  • RE: SQL 2005 x64 on Windows 2003 x64

    Personally, I've always preferred using perfmon for checking SQL's memory. I just don't trust task manager.

    I just tested out on my desktop (Vista 64 running SQL 64 bit) Task manager...

    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

    September 7, 2008 at 3:46 am

    #868207

  • RE: How are records sorted without an order by clause?

    http://www.sqlmag.com/Article/ArticleID/92888/sql_server_92888.html

    Which is what the test with the read uncommitted shows.

    If the isolation level is read committed or higher, and SQL has to scan the index it will scan in index...

    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

    September 6, 2008 at 9:19 am

    #868152

  • RE: How are records sorted without an order by clause?

    For proof of what read-uncommitted does to ordering...

    (borrowed and slightly modified from WesleyB's old blog

    CREATE TABLE tblClustered

    (ID int,

    MyDate smalldatetime,

    TestField char(2000))

    GO

    CREATE CLUSTERED INDEX ixID ON tblClustered (ID, MyDate)

    GO

    DECLARE @i int

    SET @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

    September 6, 2008 at 8:59 am

    #868148

  • RE: How are records sorted without an order by clause?

    However, even if the index hint is specified, there are ways to mess up the pseudo-ordering.

    Parallelism (parallel scans and the subsequent repartition/merge streams return the data in no particular order)

    Read...

    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

    September 6, 2008 at 8:46 am

    #868146

  • RE: PASS summit 2008

    I'm going. Second summit in Seattle.

    There's a very good Thai restaurant in a shopping center a couple blocks from the conference venue. I don't recall the name, it's the same...

    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

    September 6, 2008 at 5:13 am

    #868128

  • RE: Hardware Information

    What information are you looking for?

    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

    September 6, 2008 at 4:53 am

    #868125

  • RE: Sql Server (Recommended) Configuration Settings : 2000 & 2005

    In general the defaults are pretty good and in most cases shouldn't be changed unless you have a good reason. The exception is the max memory if the server in...

    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

    September 6, 2008 at 4:52 am

    #868124

  • RE: select statement with order by

    mj obi-wan kenobi (9/5/2008)

    Can it be because on the first the DB is attached to run in mode 80 i.e. not migrated to a SQL Server 2005 DB and on...

    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

    September 6, 2008 at 4:09 am

    #868123

  • RE: Index Seek vs Index Scan

    Deepak (9/5/2008)

    I think it also depends on the number of records present in the table. IF fewer records are there i think the optimzer would prefer a scan rather than...

    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

    September 6, 2008 at 4:07 am

    #868122

  • RE: if.. else if.. else performance issues

    Wow. 12 sec to compile...

    If this server heavily used? Is that proc getting heavily used?

    Can you run it again and trace (filtered by your machine name) the events Cache...

    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

    September 6, 2008 at 4:01 am

    #868121

Viewing 15 posts - 44,641 through 44,655 (of 49,552 total)