Forum Replies Created

Viewing 15 posts - 451 through 465 (of 1,518 total)

  • RE: Popup dialog asks me for credentials when launching Report Manager URL

    Thank you, actually the odd thing is that I RDP to the web-server computer with the same credentials that I use to launch the site from my desktop.

    I will take...

    __________________________________________________________________________________
    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 7, 2010 at 10:52 am

    #1217448

  • RE: Default Server Collation for SQL - does it depend on the O/S version (standard vs. enterprise)?!

    I found the culprit!

    The Windows locale is different in Server2 from that everywhere else in my environment.

    On Server2 it is English/Canada.

    On the rest of my env it is English/US.

    This affects...

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

    August 13, 2010 at 7:58 pm

    #1206981

  • RE: Default Server Collation for SQL - does it depend on the O/S version (standard vs. enterprise)?!

    I actually tried a brand new installation of SQL 2008 SP1 Enterprise Ed. on the server with O/S Windows Server 2008 Standard SP2, and while attempting to set the SQL_Latin1_General_CP1_CI_AS...

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

    August 13, 2010 at 7:34 pm

    #1206979

  • RE: Memory settings of SQL instances in failover cluster

    Perry Whittle (8/5/2010)

    With locked pages in memory sql server will never release below the min memory setting. It is important to set both the min and max memory when using...

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

    August 5, 2010 at 1:23 pm

    #1203088

  • RE: Memory settings of SQL instances in failover cluster

    Perry Whittle (8/4/2010)

    keep the locked pages but you will need to review your MAX Memory settings!

    Hmm, I thought if I have locked pages disabled, that I would be able to...

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

    August 5, 2010 at 12:59 pm

    #1203073

  • RE: Better to have an MSDTC resource group for each node in a SQL 2008 cluster vs. one for the whole group?

    Two advantages of using a dedicated MSDTC instance for each SQL instance are:

    (1) Better performance: The MSDTC always runs on the same physical node as SQL Server, minimizing communications overhead.

    (2)...

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

    August 4, 2010 at 12:11 pm

    #1202293

  • RE: Need to script out contents of datasource folder for safekeeping - SSRS 2008

    tfowler (7/27/2010)

    This has been posted on this board multiple times for various reasons, but RSScripter has become an essential tool for Report Sever Management for me. very simple to use.

    link:...

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

    July 27, 2010 at 1:37 pm

    #1198937

  • RE: Invalid subquery does not give error when running as part of main query!

    Thank you both, that makes sense.

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

    July 27, 2010 at 12:17 pm

    #1198890

  • RE: db Mirroring: The principle server has been fixed - tips to make it the primary server again

    Here is the procedure to fail over back to the original principal server:

    (1) Switch mirroring from asynchronous to synchronous mode (if already running in sync mode, no need for 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]

    July 26, 2010 at 3:25 pm

    #1198462

  • RE: Missing Indexes in SQL Server 2005

    As great as "missing indexes" is, it is good to be aware of some pitfalls of the feature:

    http://msdn.microsoft.com/en-us/library/ms345485.aspx

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

    July 23, 2010 at 12:30 pm

    #1197677

  • RE: Missing Indexes in SQL Server 2005

    Memory pressure may also cause this information to be erased from the cache, so the time frame during which this info is maintained may be even shorter than the latest...

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

    July 23, 2010 at 7:34 am

    #1197503

  • RE: SYSTEM_USER returns incorrect value for Win-auth user after Active-Directory change

    Yup, our support staff looking after AD changes don't like it because it means more work for them, but it seems renaming AD accounts does not jive well with SQL...

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

    July 20, 2010 at 7:46 am

    #1195523

  • RE: SYSTEM_USER returns incorrect value for Win-auth user after Active-Directory change

    S.K. (7/19/2010)

    Hi Marios,

    Has the SQL Instance been restarted at all? My account was renamed, and instances that we haven't renamed yet still link my SID back to my old...

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

    July 20, 2010 at 7:39 am

    #1195513

  • RE: SYSTEM_USER returns old username

    Hi,

    We are having the same problem, but it involves the renaming of a single user in Active Directory.

    Do we still need to restart the SQL instance to get this fixed?

    Would...

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

    July 13, 2010 at 3:18 pm

    #1192364

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

    Thank you, I'm glad it was helpful.

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

    July 12, 2010 at 7:58 am

    #1191479

Viewing 15 posts - 451 through 465 (of 1,518 total)