Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,518 total)

  • RE: Can DBCC SHRINKFILE cause the transaction log to bloat?

    MANU (4/2/2009)

    Yes, it is possible as DBCC SHRINKFILE is logging database file page movement information in log file.

    MJ

    Thank you for the input.

    __________________________________________________________________________________
    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]

    April 5, 2009 at 3:36 pm

    #972228

  • RE: Getting strange object name when running DBCC PAGE

    GilaMonster (3/26/2009)

    Marios Philippopoulos (3/3/2009)

    I run the following to get the object name:

    SELECT object_name(99)

    I get the following: ALLOCATION

    It's one of the GAM/SGAM/PFS pages. One of the allocation structures of the database.

    This...

    __________________________________________________________________________________
    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]

    March 27, 2009 at 7:09 am

    #967405

  • RE: Getting strange object name when running DBCC PAGE

    Gift Peddie (3/26/2009)

    GAM (1:3578624) = ALLOCATED

    SGAM (1:3578625) = NOT ALLOCATED

    These are in the physical index architecture check below for details from the owners of the relational engine.

    http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx

    I'm getting...

    __________________________________________________________________________________
    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]

    March 26, 2009 at 4:57 pm

    #967133

  • RE: Getting strange object name when running DBCC PAGE

    Any ideas anyone, I haven't been able to find a satisfactory explanation to this yet.

    __________________________________________________________________________________
    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]

    March 26, 2009 at 3:32 pm

    #967092

  • RE: Migrating 32-bit SQL to 64-bit SQL - Any issues?

    umar iqbal (3/25/2009)

    32 bit driver for oracel and syabse would not work here. if you are replicating data to or from other platform.

    Thanks, we are actually only using linked...

    __________________________________________________________________________________
    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]

    March 25, 2009 at 10:24 am

    #966098

  • RE: Migrating 32-bit SQL to 64-bit SQL - Any issues?

    umar iqbal (3/25/2009)

    memeoy configuration and drivers if you are usiing linked server. there are seperate drives for 64 bit. other than that it should not give trouble

    Thank you for the...

    __________________________________________________________________________________
    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]

    March 25, 2009 at 10:18 am

    #966093

  • RE: Do DBAs Still Read Techincal Books?

    My dream is an audio book with subliminal messages on SQL Server: go to bed a newbie, wake up a SQL MVP! 😀

    __________________________________________________________________________________
    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]

    March 25, 2009 at 7:20 am

    #965964

  • RE: A Simple Approach to SQL Server 2005 Encryption

    Mike Good (3/23/2009)

    I don't think so. A sysadmin is always going to be able to grant herself rights required to open the key.

    So I think you'd need...

    __________________________________________________________________________________
    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]

    March 24, 2009 at 2:14 am

    #965006

  • RE: A Simple Approach to SQL Server 2005 Encryption

    Is there a way to prevent sysadmins (at the SQL instance level) from being able to decrypt data using the approach described in this article?

    BTW, thank you for the great...

    __________________________________________________________________________________
    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]

    March 23, 2009 at 5:51 pm

    #964907

  • RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

    scotta_miller (3/23/2009)

    Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. ...

    __________________________________________________________________________________
    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]

    March 23, 2009 at 5:15 pm

    #964893

  • RE: Error trapping while stopping/starting services in powershell

    Mike (3/23/2009)

    I think what you have will work just fine. However this is a good article on doing some error trapping in powershell. Perhaps you can get some...

    __________________________________________________________________________________
    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]

    March 23, 2009 at 3:32 pm

    #964833

  • RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

    scotta_miller (3/23/2009)

    The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result....

    __________________________________________________________________________________
    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]

    March 23, 2009 at 1:53 pm

    #964742

  • RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

    scotta_miller (3/23/2009)

    Both, it is blank locally and on the report server.

    I will run the Supp Material code later today and see if I can reproduce the issue. Will send out...

    __________________________________________________________________________________
    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]

    March 23, 2009 at 1:48 pm

    #964731

  • RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

    scotta_miller (3/23/2009)

    The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result....

    __________________________________________________________________________________
    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]

    March 23, 2009 at 1:27 pm

    #964716

  • RE: Real-Time Tracking of Tempdb Utilization Through Reporting Services

    scotta_miller (3/23/2009)

    The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value > 0, false, true) --- I tried setting the hidden property to false and got the same result....

    __________________________________________________________________________________
    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]

    March 23, 2009 at 12:57 pm

    #964693

Viewing 15 posts - 661 through 675 (of 1,518 total)