Forum Replies Created

Viewing 15 posts - 47,131 through 47,145 (of 49,552 total)

  • RE: ALLOW_PAGE_LOCKS : to use or not to use

    Generally, in my experience, if the code is written optimally and the indexes are well designed, there's little need to fiddle with the locking mechanism.

    Are you seeing lots of blocking?

    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 20, 2008 at 7:36 am

    #791987

  • RE: SQL 2KDatabase performance slowdown

    I would suggest you run profiler during the peak period to see what queries are running long, or doing lots of IOs.

    Once you've identified the slow running or resource hogging...

    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 20, 2008 at 6:48 am

    #791958

  • RE: DB Status

    Select name, state_desc from sys.databases

    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 20, 2008 at 6:37 am

    #791954

  • RE: High CPU. Many processes have SOS_SCHEDULER_YIELD

    The last wait time is a scheduler yield, but from what I can see, the curent wait type is 0 (0x000) and the wait time is 0. Hence the process...

    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 20, 2008 at 5:31 am

    #791926

  • RE: Indexed Views in SQL Server 2000

    Not sure about the second and third.

    1st probably uses the base table rather than the view because the column Salary isn't in the view, hence a scan 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

    March 20, 2008 at 5:06 am

    #791918

  • RE: I want to add constraint for existing column

    For not null, it'll be an ALTER TABLE <Table Name> ALTER COLUMN ...

    The other two will be forms of ALTER TABLE <Table Name> ADD CONSTRAINT ...

    If you look up ALTER...

    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 20, 2008 at 1:15 am

    #791867

  • RE: One DB per user, what do you think?

    Pavle (3/19/2008)

    Does SQL Server store one execution plan per DB meaning that even if there are 10 identical stores procedures in 10 Db,s the server will store 10 times 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

    March 20, 2008 at 1:03 am

    #791866

  • RE: Indexed Views in SQL Server 2000

    Which edition of SQL 2000? (Enterprise, standard, ...)

    I was asing what the definition code for your indexed view is. (Create View ....)

    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 20, 2008 at 12:57 am

    #791863

  • RE: optimizing query

    Only if you don't mind potentially getting wrong data from time to time.

    Nolock allows reading of uncommitted data. Also, because of the way it's implemented, there's a chance of missing...

    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 20, 2008 at 12:54 am

    #791861

  • RE: Rebuild of system databases, what else needs to be recreated

    DTS packages

    Linked servers

    Server-scoped DDL triggers

    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 20, 2008 at 12:42 am

    #791859

  • RE: Indexed Views in SQL Server 2000

    What edition of SQL are you using?

    What's the indexed view's definition, and what does the query look like?

    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 20, 2008 at 12:23 am

    #791858

  • RE: CPU per File Group?

    That best practice is for TempDB only, and it's only really necessary if you have high volumes of temp table creation and/or are seeing blocking on the allocation structures 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 20, 2008 at 12:21 am

    #791857

  • RE: Querying an indexed table

    rbarryyoung (3/19/2008)

    Column order in predicates is only relevant if SQL Server has no statistics available on the referenced columns.

    Could you explain more 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

    March 20, 2008 at 12:18 am

    #791856

  • RE: Are temp tables better than table variables

    GSquared (3/19/2008)

    If you're using transactions to reduce the workload on the server, then yes, short transactions are good. If you're using transactions to control data integrity, sometimes you have...

    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 20, 2008 at 12:16 am

    #791855

  • RE: COUNT (Distinct Column) = 0 with GROUP BY

    Please don't cross post. It wastes people's time and scatters replies. Many of the regular readeers read all the forumns.

    Please direct any replies to the following thread.

    http://www.sqlservercentral.com/Forums/Topic472063-338-1.aspx

    Thanks

    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 20, 2008 at 12:15 am

    #791854

Viewing 15 posts - 47,131 through 47,145 (of 49,552 total)