Forum Replies Created

Viewing 15 posts - 40,426 through 40,440 (of 49,552 total)

  • RE: prevent clients to retrieve information_schema and sys metadata

    clive (3/10/2009)

    Can anyone provide a statisfactory solution.

    On SQL 2000?

    If I may be blunt, the first thing I would look at is changing the DTS so that they use a username/password...

    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

    March 11, 2009 at 1:12 am

    #957286

  • RE: Updating mulitple rows with an update trigger using IF, Then, Else

    TaylrJ (3/10/2009)

    Thank you for the replies.

    I think I have a handle on it with one exception. I only want to update a record if it is inserted...

    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

    March 10, 2009 at 3:02 pm

    #957105

  • RE: Index Fragmentation/Identity Property

    Dave Mason (3/10/2009)

    Oh, as far as the fragmentation threshold goes, it was 3% (or more) this morning. Prior to that, it was 5%.

    I wouldn't worry until it reaches 25-30....

    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

    March 10, 2009 at 2:56 pm

    #957102

  • RE: Index Fragmentation/Identity Property

    Dave Mason (3/10/2009)

    I was under the impression that updates to non-indexed columns don't affect index fragmentation.

    It does if the update makes the row grow (null to non-null, longer entries 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

    March 10, 2009 at 2:32 pm

    #957088

  • RE: Index Fragmentation/Identity Property

    Dave Mason (3/10/2009)

    MJ,

    I rebuild indexes once per day at 6am. On some days, a second index rebuild is required.

    Auto_shrink? Manual shrink?

    What's your threshold for rebuilding the indexes and how...

    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

    March 10, 2009 at 2:09 pm

    #957072

  • RE: Updating mulitple rows with an update trigger using IF, Then, Else

    TaylrJ (3/10/2009)

    if exists(select usr_Ipaddress from Database1.dbo.usr_hardwareasset where usr_IPAddress like '10.4.10.%')

    update usr_hardwareasset

    set usr_location = 'Some location1'

    What you're saying there is if there are any rows at all (even 1)...

    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

    March 10, 2009 at 2:04 pm

    #957069

  • RE: updatable view

    Why do you want to update through the view instead of updating the base tables?

    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

    March 10, 2009 at 1:58 pm

    #957064

  • RE: Straighten me out using "Top 1"

    Tony (3/10/2009)

    Thank you both for the replies! My questions were for my own knowledge, but they stemmed from a query that one of our developers uses constantly:

    SELECT TOP 1...

    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

    March 10, 2009 at 1:55 pm

    #957058

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/10/2009)

    Hey Lynn... somebody is impersonating you 😉

    http://www.sqlservercentral.com/Forums/Topic672323-1291-1.aspx

    A jedi master he is not.

    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

    March 10, 2009 at 1:17 pm

    #957031

  • RE: Insert write delay

    Check what jobs are running at that time.

    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

    March 10, 2009 at 1:16 pm

    #957030

  • RE: FILESTREAM and DELETE does not work properly

    There's a garbage collector that cleans up the files later, after it's certain that they're not needed any longer. iirc it runs when the log is truncated ie on log...

    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

    March 10, 2009 at 1:14 pm

    #957029

  • RE: There is insufficient system memory in resource pool 'internal' to run this query"

    From the error it sounds like the resource governor's enabled. What's the configuration for the internal resource pool?

    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

    March 10, 2009 at 1:09 pm

    #957027

  • RE: Straighten me out using "Top 1"

    Tony (3/10/2009)

    I know that omitting an ORDER BY clause when using TOP 1 will return the first record found in the table. My question is, what is the “first...

    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

    March 10, 2009 at 1:09 pm

    #957026

  • RE: Sql Server 2005 Error 109

    Try starting the service from the service control app and then checking the error log file. Post the whole thign here if you're not sure how to interpret 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

    March 10, 2009 at 1:03 pm

    #957024

  • RE: How do i identify last SQL Services start date time?

    and you can also check the login_time of session_id 1 in sys.dm_exec_sessions. Since the system sessions connect at startup and never disconnect, that will be the system start time.

    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

    March 10, 2009 at 9:37 am

    #956899

Viewing 15 posts - 40,426 through 40,440 (of 49,552 total)