Forum Replies Created

Viewing 15 posts - 39,346 through 39,360 (of 49,552 total)

  • RE: Integrity checking

    ananda.murugesan (5/2/2009)

    Thanks for your 's reply Steve & Gail..

    I should be disabled Re-organaize index page from maintenance plan.

    Absolutely not. You need to be rebuilding your indexes on a regular...

    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

    May 2, 2009 at 3:50 am

    #987685

  • RE: list of data types

    select * from sys.types

    select * from sys.database_principals

    where type_desc = 'DATABASE_ROLE'

    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

    May 1, 2009 at 3:40 pm

    #987613

  • RE: Comparison of Dates in SQL

    Tao Klerks (5/1/2009)

    GilaMonster (5/1/2009)

    Short answer. UDFs are not considered 'inline'. If they're run in a query, the run once for each row.

    Long answer - http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

    Do you have a ready blog...

    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

    May 1, 2009 at 1:26 pm

    #987543

  • RE: TIMEOUT error (client thinks it's SQL Server)

    Personally when I'm checking performance of queries, I just use the RPC:Completed and T-SQL Batch Completed events. The starting events give no useful information and I find they just clutter...

    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

    May 1, 2009 at 12:54 pm

    #987520

  • RE: Are the posted questions getting worse?

    Florian Reischl (5/1/2009)

    Well, since even Steve didn't know this. Maybe these 3 persons have been the only...

    Never noticed it either. I usually change the url directly if I want 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

    May 1, 2009 at 12:27 pm

    #987500

  • RE: Comparison of Dates in SQL

    Tao Klerks (5/1/2009)

    Does that make sense? Can a UDF really be that expensive?

    Yes.

    Short answer. UDFs are not considered 'inline'. If they're run in a query, the run once for...

    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

    May 1, 2009 at 12:22 pm

    #987495

  • RE: TIMEOUT error (client thinks it's SQL Server)

    Part of this article goes over scripting a profile trace. I don't know why you want RPC:Starting. It's the competed events that have duration and other performance-related columns

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-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

    May 1, 2009 at 11:11 am

    #987442

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/1/2009)

    Silly question, but you guys read any of the spinoff books by Kevin Anderson et al?

    I've read quite a few. The Jedi Academy trilogy I found very good,...

    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

    May 1, 2009 at 11:08 am

    #987441

  • RE: Comparison of Dates in SQL

    No. Nor the version that casts to int.

    DECLARE @Today2 DATETIME2 = GETDATE()

    SELECT CAST(FLOOR(CAST (@Today2 AS FLOAT)) AS DATETIME2)

    Msg 529, Level 16, State 2, Line 5

    Explicit conversion from data type datetime2...

    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

    May 1, 2009 at 10:51 am

    #987435

  • RE: Comparison of Dates in SQL

    Ed (5/1/2009)

    Using -3 millliseconds will give you the maximum time Sql Server can use.

    True with datetime, but no longer true on SQL 2008 if you start messing with the higher...

    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

    May 1, 2009 at 9:41 am

    #987390

  • RE: Best Practices/Standards - to include or not to include database owner for table names

    nataliehinnen (5/1/2009)

    I interpreted the email to mean that they plan on using different schemas for security reasons.... could that be it?

    Could be, but again there's no logical reason hit 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

    May 1, 2009 at 9:39 am

    #987388

  • RE: Best Practices/Standards - to include or not to include database owner for table names

    Paul White (5/1/2009)

    I have the oddest feeling that they don't have separate dev/test/prod environments.

    I suspect as much, which is a far bigger stuff-up than dropping schema names from procs.

    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

    May 1, 2009 at 3:56 am

    #987192

  • RE: Best Practices/Standards - to include or not to include database owner for table names

    nataliehinnen (4/30/2009)

    One of the issues with specifying the owner is that when a developer is developing a stored procedure, they would have to be logged in as “dbo” in order...

    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

    May 1, 2009 at 3:45 am

    #987190

  • RE: Are the posted questions getting worse?

    WayneS (4/30/2009)

    Gail - can you give a good answer to this?

    Offhand, no, but I suspect it has something to do with Statement level recompile and/or temp table caching. 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

    April 30, 2009 at 4:48 pm

    #987076

  • RE: Converting Temp Table to Table Variable... Is this possible and how?

    WayneS (4/30/2009)

    There's an article coming out soon (ask Steve, not me, when that will be) that will tell you everything that you need to know in comparing table variables 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

    April 30, 2009 at 4:34 pm

    #987064

Viewing 15 posts - 39,346 through 39,360 (of 49,552 total)