Forum Replies Created

Viewing 15 posts - 41,761 through 41,775 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/13/2009)

    I replied and attempted to politely tweak him.

    Ouch. 😀

    It's possible to read that straight, or dripping with sarcasm. I wonder which he will 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

    January 13, 2009 at 12:17 pm

    #926162

  • RE: SQL Server 2000 Stored Proc. Tuning

    Grant Fritchey (1/13/2009)

    Thanks. I was trying to figure out if I was missing something.

    If you are, I'm missing it too.

    Although, on SQL 2000, if those sub-procedures had no stable plan...

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

    #926150

  • RE: SQL Server 2000 Stored Proc. Tuning

    nitinpatel31 (1/13/2009)

    If proper transaction are not mantained then it may cause the deadlock. For example if some table has s-lock in parent sp and x-lock in child sp and there...

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

    #926126

  • RE: KERBEROS

    http://letmegooglethatforyou.com/?q=Kerbtray

    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 13, 2009 at 11:26 am

    #926119

  • RE: Log File of a database

    Whisper9999 (1/13/2009)

    You can, for example, add as many log files as you want to a database and give them whatever extension you want.

    Thought it's not usually a good idea...

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

    #926115

  • RE: Stored procedure in User defined function?

    RBarryYoung (1/13/2009)

    And the SQL parser, optimizer and data engine rely heavily on the assumption that functions cannot cause changes in the database while they are being invoked. Almost all...

    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 13, 2009 at 11:19 am

    #926114

  • RE: Profiler Help - Find Long Running Queries

    Don't use profiler, at least not the gui. Use the server-side trace procedures (sp_trace_*) and write the output to a file on a fast disk. That's the lowest impact way...

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

    #926106

  • RE: How does DTA decide on an index for large join queries?

    Grant Fritchey (1/13/2009)

    Let me restate "Ask Microsoft or Gail"

    There, that's better.

    Nah. I know what it runs and vaguely what that does, but not the details. I mean, DBCC Autopilot????

    Besides, that'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

    January 13, 2009 at 10:47 am

    #926084

  • RE: Image is Everything

    Steve Jones - Editor (1/13/2009)

    OK, I'm really confused now. I was going to change the picture to a new shirt, but most people like the shirt.

    Hmmmmm, I think 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 13, 2009 at 10:47 am

    #926082

  • RE: How does DTA decide on an index for large join queries?

    DTA's got two undocumented features that it uses to do evaluations of cost improvement. One is the hypothetical index (an index that has all the metadata and stats of 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 13, 2009 at 7:41 am

    #925878

  • RE: KERBEROS

    Can you ask the domain administrator (whoever runs the AD there) to see if the two SQL Servers are enabled for Kerberos delegation? It's a setting at the AD level,...

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

    #925871

  • RE: Error message when you try to change a column of a table by using the ALTER TABLE statement in SQL Server 2005

    jonathan (1/13/2009)

    But what I don't understand is, I have tried to run the same SQL script to a different

    SQL 2005 Server but I did not hit the error...

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

    #925867

  • RE: Sql Server vs Sql server

    karthikeyan (1/13/2009)

    what do you mean by database activity ?

    Activity within the database. Users running queries.

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

    #925688

  • RE: user tables in database where the number of rows is less than 100

    Abhijit More (1/13/2009)

    select distinct object_name(object_id) as Table, rows

    from sys.partitions where index_id >= 1

    and object_name(object_id) not like 'sys%'

    and rows > 100

    Msg 156, Level 15, State 1, Line 1

    Incorrect syntax near 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 13, 2009 at 1:02 am

    #925685

  • RE: Error message when you try to change a column of a table by using the ALTER TABLE statement in SQL Server 2005

    Check the SQL error log. The message just indicates that your query has been forcefully disconnected. That's usually the result of the connection been killed by someone, or the result...

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

    #925682

Viewing 15 posts - 41,761 through 41,775 (of 49,552 total)