Forum Replies Created

Viewing 15 posts - 35,956 through 35,970 (of 49,552 total)

  • RE: Understanding some locks appearing in dead locks

    One of your processes is indeed using serialisable, at least according to the deadlock graph, and in a user-started transaction. If the proc's not setting it, maybe it's the ADO...

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

    #1077487

  • RE: Introduction to the Transaction Log

    John Mitchell-245523 (11/10/2009)

    Looking at it rationally rather than empirically, I'd say that since a log file is written to sequentially, any activity (such as truncation) that moves the disk heads...

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

    #1077472

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/10/2009)

    She seems to be spending her day today correcting my answers.:-P

    Sorry. Will be leaving now. (cause battery's low and ADSL still needs configuring. maybe a Hammer will help......)

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

    #1077280

  • RE: Understanding some locks appearing in dead locks

    Are you using serialisable isolation level? If so, why?

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

    #1077273

  • RE: Transaction Log out of control

    Please take a read through this: http://www.sqlservercentral.com/articles/64582/

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

    #1077271

  • RE: Index on Encrypted column

    You can index it, but it's completely useless to do so. It's not possible to encrypt a parameter and compare to the stored encrypted value as the encryption routines are...

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

    #1077269

  • RE: SQL Server 2008 Enterprise installation failed Window 7 ultimate

    in addition, SQL Enterprise edition is only supported on server operating systems. Windows 7 is a client machine OS.

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

    #1077261

  • RE: Shrinking your database frags your clustered indexes bad...

    talltop-969015 (11/9/2009)

    I am still not exactly sure why the shrink does this, but what is important is to realize here is that it DOES, and to be mindful of...

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

    #1077259

  • RE: SQL 2005 - Looking for a DB deleted - The system cannot find the file specified

    There's still a database referencing those files. Query sys.master_files, see which db is referring to those files, then drop that 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 10, 2009 at 7:39 am

    #1077254

  • RE: Storing the results in IN MEMORY SQL Server

    Short answer: No.

    SQL caches data from tables and query execution plans, but it doesn't cache query 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 10, 2009 at 7:36 am

    #1077251

  • RE: What are the Potential Dangers of Too Many Statistics?

    Jack Corbett (11/10/2009)

    Well, if you have autocreate statistics on, I'm going to guess that SQL Server will end up creating most of the statistics recommended by DTA.

    DTA often suggests multi-column...

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

    #1077249

  • RE: how to alter primary key int datatype to uniqueidentifier

    Look up ALTER TABLE in books online (web version: http://msdn.microsoft.com/en-us/library/ms190273%28SQL.90%29.aspx)

    ALTER TABLE ... DROP CONSTRAINT ... to remove the pk

    ALTER TABLE ... ADD ... to add a new column

    ALTER 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 10, 2009 at 7:31 am

    #1077245

  • RE: What are the Potential Dangers of Too Many Statistics?

    GDI Lord (11/10/2009)

    It suggested an imperial shipload worth of statistics to be created on some of the tables, especially the main table which contains the historical data.

    Don't trust DTA. It's...

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

    #1077240

  • RE: why my differential backup files are HUGE?

    You sure you want to disable your index rebuild jobs?

    They'll be sQL agent jobs or maiontenance plans. Check with the DBA before you take any action.

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

    #1077235

  • RE: How save contents of sys.dm_exec_sessions ?

    Sure you can save it. It's just a view, it behaves like any other view in SQL. INSERT INTO (with a pre-created table) or SELECT ... INTO (to both create...

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

    #1077223

Viewing 15 posts - 35,956 through 35,970 (of 49,552 total)