Forum Replies Created

Viewing 15 posts - 32,116 through 32,130 (of 49,552 total)

  • RE: Securing Tables and Stored Procedures

    Excellent.

    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

    June 30, 2010 at 2:19 am

    #1186914

  • RE: Unpredictive Index Drops in SQL Server 2005

    DDL trigger (filtered to drop index) or a server-side trace.

    A well-written DDL trigger shouldn't have much if any impact. DDL should be a relatively infrequent operation (other than stats...

    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

    June 30, 2010 at 1:42 am

    #1186893

  • RE: Non-logged table ?

    Michael Valentine Jones (6/29/2010)

    I was saying that it is not logged because it is not a database object in tempdb, not because it is not stored in tempdb. 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

    June 30, 2010 at 1:33 am

    #1186891

  • RE: Non-logged table ?

    Lowell (6/29/2010)

    i thought table variables were exempt? i know if they are in a transaction, and the transaction is rolled back, the table variable is unaffected...does that mean it's 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

    June 30, 2010 at 1:25 am

    #1186883

  • RE: Extremely puzzling >_<

    n00b (6/29/2010)

    I'm trying to find out how to delete this post but can't seem to find the button. Sorry for this.

    Threads can't be deleted. Don't worry about 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

    June 30, 2010 at 1:09 am

    #1186878

  • RE: Can we have more than one identity columns in a table

    From Books Online:

    When you use the IDENTITY property to define an identifier column, consider the following:

    * A table can have only one column defined with the IDENTITY property, and...

    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

    June 30, 2010 at 1:08 am

    #1186877

  • RE: Manually Grow w/Multi files.

    digdave7 (6/29/2010)

    Hi Gail,

    I ran

    ALTER DATABASE [VSD] MODIFY FILE ( NAME = N'VSD', SIZE = 29864824 MB )

    29 Terabytes? That's what the alter database you have there sets 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

    June 30, 2010 at 1:04 am

    #1186876

  • RE: DBCC CHECKDB: 2+ hours?

    *

    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

    June 29, 2010 at 12:14 pm

    #1186595

  • RE: DBCC CHECKDB: 2+ hours?

    How much memory on the server? How much allocated to SQL?

    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

    June 29, 2010 at 12:06 pm

    #1186589

  • RE: Why 'ALTER INDEX REBUILD' didn't change 'avg_fragmentation_in_percent' returned from sys.dm_db_index_physical_stats?

    hl6a (6/29/2010)

    I ran 'Rebuild Index Task' in maintenance plan, then used the following the query to check index fragmentation level. To my surprise, some tables still have very high 'avg_fragmentation_in_percent'...

    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

    June 29, 2010 at 11:49 am

    #1186572

  • RE: Why 'ALTER INDEX REBUILD' didn't change 'avg_fragmentation_in_percent' returned from sys.dm_db_index_physical_stats?

    weitzera (6/29/2010)

    Extent Fragmentation is a measure of page fullness

    No it's not, and neither is logical_fragmentation (which is what SSMS displays). The column avg_page_used_in_percent is a measure of page fullness. Logical...

    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

    June 29, 2010 at 11:47 am

    #1186570

  • RE: DBCC CHECKDB: 2+ hours?

    Are there any entries in the log? Long duration for checkDB can be a sign that it's encountered a potential or actual corruption.

    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

    June 29, 2010 at 11:42 am

    #1186566

  • RE: Few disk space

    Steve Jones - Editor (6/29/2010)

    You can also detach the dbs, and then restore a backup using the WITH MOVE option.

    If you detach the DB, why not move the files and...

    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

    June 29, 2010 at 11:33 am

    #1186563

  • RE: Table locked?

    stricknyn (6/29/2010)

    Actually the data in the table is just testing dummy data. So no fear at all to lose anything. That's why I went ahead and ran 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

    June 29, 2010 at 9:19 am

    #1186459

  • RE: Table locked?

    Apologies, that should have read sys.dm_exec_requests. Post edited.

    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

    June 29, 2010 at 9:17 am

    #1186458

Viewing 15 posts - 32,116 through 32,130 (of 49,552 total)