Forum Replies Created

Viewing 15 posts - 886 through 900 (of 1,518 total)

  • RE: Fill factors, index fragmentation and indexing strategy

    Matt Miller (10/15/2008)

    You might worry about it if the columns making up the key change a lot. in a similar way to why you worry about fill factor for...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 15, 2008 at 12:19 pm

    #885407

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    Grant Fritchey (10/14/2008)

    Excellent. Well done. I'll have to see if we can use this one on our servers.

    Thanks!

    I'm attaching the 2 .vbs scripts here with .txt extensions to make it...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 14, 2008 at 7:49 am

    #884627

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    SQLEngine (10/13/2008)

    Marios,

    Very useful article, thanks. This opens up other posibilities with SCOM.

    Thanks!

    I will post the .vbs as a .txt file in the next day or so.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 13, 2008 at 8:31 pm

    #884393

  • RE: Detecting offline databases by querying system tables

    noeld (10/10/2008)

    Marios Philippopoulos (10/10/2008)

    I'm looking at the BOL documentation of view sys.sysdatabases (http://msdn.microsoft.com/en-us/library/ms179900(SQL.90).aspx) and the status column is supposed to have the value of 512 for an offline database.

    Yet, when...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 10, 2008 at 11:54 am

    #883580

  • RE: Detecting offline databases by querying system tables

    Steve Jones - Editor (10/10/2008)

    It's bitmapped. Meaning the 512 is the bit (#9) that determines if the database is offline. So you OR it with 512 to check the status...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 10, 2008 at 9:07 am

    #883489

  • RE: Table Variables and performance

    GilaMonster (10/10/2008)

    ...Also, because they don't take part in transactions they will keep any logged rows even if the tran is rolled back.

    Another use of table variables - from Gail's last...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 10, 2008 at 8:12 am

    #883428

  • RE: Table Variables and performance

    Grant Fritchey (10/8/2008)

    If you're using table variables that are more than a few rows in size, switch them to temp tables. Except for a primary key, table variables have not...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 9, 2008 at 3:40 pm

    #883153

  • RE: Auditing changes in SSIS packages

    Greg Charles (10/2/2008)

    If the config file path was wrong in the job step, wouldn't that indicate that the job was changed rather than the package?

    Unfortunately, I don't think a modification...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 2, 2008 at 3:05 pm

    #880213

  • RE: SQL Server 2005 Memory Limits

    EdVassie (10/2/2008)

    The more you read about how 32-bit Windows uses memory above the 4GB line, the more you will realise that the information quoted in your original post is correct....

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 2, 2008 at 7:57 am

    #879962

  • RE: SQL Server 2005 Memory Limits

    What's stunning about this is that AWE is not even the ideal solution for SQL Server accessing more memory: only the buffer cache benefits from it.

    So when it is stated...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    October 1, 2008 at 7:07 am

    #879447

  • RE: SQL Server 2005 Memory Limits

    Adam Angelini (9/30/2008)

    correct, the only things necessary is the AWE option and the lock pages in memory permission for your SQL account.

    Yes, I have been using this link to configure...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 30, 2008 at 3:30 pm

    #879209

  • RE: SQL Server 2005 Memory Limits

    Adam Angelini (9/30/2008)

    I know for a fact that it is necessary to use AWE - I've tried it without doing so.

    Thanks, I'm also quite incredulous about this...

    I'm just stunned at...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 30, 2008 at 2:56 pm

    #879186

  • RE: SQL Server 2005 Memory Limits

    george sibbald (9/30/2008)

    as long as you are using 32 bit SQL server, you will need to enable AWE to access memory over 4GB

    Could it be that not mentioning AWE is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 30, 2008 at 2:53 pm

    #879184

  • RE: SQL Server 2005 Memory Limits

    Adam Angelini (9/30/2008)

    yes, you can use 64GB, but you need to enable AWE for 32 bit.

    Thank you, I've always thought so too, but AWE is not mentioned anywhere in these...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 30, 2008 at 2:51 pm

    #879181

  • RE: Memory used by a sql process is 2.5 GB on 32-bit box. WHY??

    Tim Peters (9/30/2008)

    To edit the boot.ini file...

    1. Right-click My Computer, and then click Properties.

    -or-

    Click Start, click Run, type sysdm.cpl, and then click OK.

    2. On the Advanced tab,...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 30, 2008 at 10:36 am

    #878991

Viewing 15 posts - 886 through 900 (of 1,518 total)