Forum Replies Created

Viewing 15 posts - 28,411 through 28,425 (of 49,552 total)

  • RE: RE

    If you have a backup from before the delete, yes. If you don't, no.

    p.s. Please don't type in all caps. It's the online equivalent of shouting.

    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

    January 17, 2011 at 7:58 am

    #1274251

  • RE: Dump Tran for all DBs

    Profiler won't cause a transaction log to grow.

    You need to investigate the matter, not just throw away the ability to recover your database. Start by querying sys.databases and looking at...

    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

    January 17, 2011 at 7:19 am

    #1274236

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/17/2011)

    We recently had a project that brought in a highly paid Microsoft consultant (somone I worked with in the past, who is actually extremely good) on a project...

    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

    January 17, 2011 at 7:13 am

    #1274234

  • RE: PRACTICAL APPROACH to know On which columns of a table & when we have to apply indexes?

    Create indexes on columns used in the where clause and on join columns.

    As for practical...

    Run the query, see what the execution plan looks like.

    Add an index.

    Run the query, see...

    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

    January 17, 2011 at 7:07 am

    #1274232

  • RE: Page Splits on Non-clustered unique primary Key

    With a unique nonclustered index (which you have because it's the primary key) the clustering key won't be present at the intermediate level at all. It'll only be at 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

    January 17, 2011 at 7:02 am

    #1274230

  • RE: Unable to delete or edit

    Generally if you have locks hanging around so long that the timeout (default 30 sec) is hit, you have either badly written code or poor indexing.

    If a query encounters 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

    January 17, 2011 at 6:33 am

    #1274216

  • RE: Page Splits on Non-clustered unique primary Key

    You can only get page splits due to updates if you're increasing the data stored in a variable-length column or updating a column from null to not null.

    Can the clustered...

    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

    January 17, 2011 at 6:16 am

    #1274211

  • RE: find collation type in the tables

    Tables don't have a collation. Columns have a collation.

    This should get you started

    SELECT object_name(object_id) as TableName, name as ColumnName, collation_name

    FROM sys.columns

    WHERE collation_name IS NOT NULL

    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

    January 17, 2011 at 5:24 am

    #1274200

  • RE: Page Splits on Non-clustered unique primary Key

    It shouldn't page split due to inserts. As you say, it's an increasing column and new rows will always be at the 'end'. The clustering key will be present, but...

    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

    January 17, 2011 at 5:19 am

    #1274198

  • RE: SSMS Delete vs T-SQL DROP

    SSMS executes a DROP TABLE against SQL when you say select 'delete 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

    January 17, 2011 at 5:12 am

    #1274195

  • RE: transaction log

    I've added a small disclaimer and reading list to an earlier post in this thread.

    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

    January 17, 2011 at 3:56 am

    #1274179

  • RE: transaction log

    Koen (da-zero) (1/17/2011)

    This comes from the following article:

    http://articles.techrepublic.com.com/5100-10878_11-5173108.html

    What is this buffer they speak of? Do they mean the data cache?

    Considering there are some blatant inaccuracies in that article (shrink 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

    January 17, 2011 at 3:33 am

    #1274174

  • RE: IS Shrink part of Full Backup by default or as an option

    EdVassie (1/17/2011)

    You need to know how your disk subsystem works before using a program of this type. If your data is stored on a SAN, then where possible always...

    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

    January 17, 2011 at 3:28 am

    #1274172

  • RE: transaction log

    Koen (da-zero) (1/17/2011)

    It depends. If someone else has made changes to the table and the transactions are not yet checkpointed in the log file, you'll probably read it from 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

    January 17, 2011 at 3:13 am

    #1274162

  • RE: transaction log

    When you query SQL it reads from pages in memory, not pages on disk. Always.

    If the page is not in memory, it's fetched in by the storage engine, then...

    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

    January 17, 2011 at 3:06 am

    #1274155

Viewing 15 posts - 28,411 through 28,425 (of 49,552 total)