Forum Replies Created

Viewing 15 posts - 41,911 through 41,925 (of 49,552 total)

  • RE: Help - why is this simple update not working?

    Michael Baas (1/7/2009)

    Ok, case closed - many thanks for asking. I really forgot these triggers, but they guys only support updating one record at a time, so that explains...

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

    #922401

  • RE: Database Corrupted

    There should be an entry in the SQL error log saying why the database has been marked suspect. Can you look through the error log and see if there's anything...

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

    #922393

  • RE: Where does SQL Server store function parameters and body?

    matsinopoulos (1/7/2009)

    [

    However, I realized that it does not contain the line breaks. The whole value of definition is one line string. How should I recover the body of 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 7, 2009 at 3:00 am

    #922382

  • RE: can not create index more than 249

    Thought so.

    Those aren't indexes. They're automatically created system statistics and they can be safely dropped if they're causing problems (as they are here). The optimiser will recreate any that 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

    January 7, 2009 at 1:33 am

    #922347

  • RE: indexes size same as database/tables

    How many indexes do you have?

    Are you sure there are no redundant indexes?

    Are they all been used?

    Please post SQL 2000-related questions in the SQL 2000 forums in the future. If...

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

    #922343

  • RE: User Defined Function: order by won't work

    ALZDBA (1/7/2009)

    However there may be a TEMPORARY bypass by using the startup parameter that has been provided for the "views with order by nolonger work" problem.

    http://support.microsoft.com/kb/926292

    With one caveat:

    From the kb...

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

    #922342

  • RE: Auto Update Stats and Auto Create Stats

    You should leave those on unless you know exactly what turning them off will do, you're happy with the risks and you have some manual stats update job in place.

    http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/

    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

    January 7, 2009 at 12:14 am

    #922336

  • RE: Adding a Watermark

    Continued here - http://www.sqlservercentral.com/Forums/Topic631160-150-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

    January 7, 2009 at 12:11 am

    #922334

  • RE: Bookmark Lookup

    Bookmark lookups happen when SQL uses a nonclustered index to fetch rows and all of the columns that the query needs are not contained in the nonclustered index.

    That clustering key...

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

    #922332

  • RE: User Defined Function: order by won't work

    tfifield (1/6/2009)

    If all the data being fetched was in a covering index, would that guarantee the order?

    Todd Fifield

    Once more with feeling...

    The only way to absolutely guarantee an order is to...

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

    #922331

  • RE: can not create index more than 249

    Replication does not create indexes.

    Please run the following for the table in question. What does it return?

    SELECT object_name(id), name, INDEXPROPERTY(id, name, 'IsStatistics') FROM sysindexes

    WHERE id = object_ID('Table Name')

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

    #922329

  • RE: Getting Deadlocks Continuously?????????

    madhu.arda (1/6/2009)

    If I do DBCC TRACEON(1222,-1), the trace will be on for ever?

    Until you turn it off (DBCC TRACEOFF(1222,-1)) or until the SQL service is restarted.

    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 6, 2009 at 3:16 pm

    #922221

  • RE: syscolumns

    Continued here - http://www.sqlservercentral.com/Forums/Topic630987-169-1.aspx

    No more replies to this thread please.

    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 6, 2009 at 2:53 pm

    #922207

  • RE: Hash Joins and Indexes

    markmeiller (1/6/2009)

    I'm pretty sure that a hash join is unavoidable, but looking at my execution plan the hash doesn't look to be using the indexes. I've ran a second...

    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 6, 2009 at 2:51 pm

    #922204

  • RE: How to link view and table together

    This might help you

    http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/

    If you want to ensure that the data inserted has no time, you'll either need a trigger (which is the more complex and probably slower route), or...

    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 6, 2009 at 2:44 pm

    #922196

Viewing 15 posts - 41,911 through 41,925 (of 49,552 total)