Forum Replies Created

Viewing 15 posts - 106 through 120 (of 1,518 total)

  • RE: Database mail

    I have been bitten badly by this bug.:-)

    I was recently trying to copy db mail settings from one server to another and somehow managed to mess up the "good" profile...

    __________________________________________________________________________________
    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 27, 2012 at 4:33 pm

    #1480767

  • RE: Unable to create a plan guide for a SELECT statement inside a stored procedure

    Thanks both; yes, I did not consider the obvious option of adding the OPTIMIZE FOR hint directly in the code:

    SELECT ...

    ...

    OPTION (OPTIMIZE FOR (@UserId = 4))

    I will try that now.

    If...

    __________________________________________________________________________________
    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 26, 2012 at 6:10 am

    #1479616

  • RE: Unable to create a plan guide for a SELECT statement inside a stored procedure

    The weirdest thing; the SQL stmt is actually enclosed inside a "SELECT * INTO #tempTable FROM ..." statement.

    As soon as I included that as well, it worked:

    EXEC sp_create_plan_guide

    @name = N'guide__procName',

    @stmt...

    __________________________________________________________________________________
    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 25, 2012 at 2:44 pm

    #1479352

  • RE: appdomain message

    I'm not familiar with this particular error, but I have seen appdomain errors in the past as being caused by the SQL buffer pool taking up all available memory on...

    __________________________________________________________________________________
    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 17, 2012 at 4:02 am

    #1474603

  • RE: Confio Ignite tool for measuring SQL waits and performance

    Thanks all!

    Since my post three and a half years ago, I have had the chance to use IGNITE extensively and am now a devoted fan. This tool has become an...

    __________________________________________________________________________________
    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 1, 2012 at 6:30 am

    #1467395

  • RE: msdb indexes heavily fragmented - blocking on msdb.dbo.sp_jobhistory_row_limiter

    opc.three (3/27/2012)

    I include msdb it in my index maintenance job. It does not require downtime, it may just block other processes while the indexes are being rebuilt...a normal side effect...

    __________________________________________________________________________________
    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, 2012 at 5:44 pm

    #1465417

  • RE: Is there any option to reduce the size of the log resulting from a reindex/reorg operation? Affecting mirroring to DR env

    Thanks both for your suggestions.

    I'm also looking into some large indexes that over the last couple of months have hardly been used for seeks/scans/lookups (<10) but have undergone millions of...

    __________________________________________________________________________________
    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, 2012 at 3:48 am

    #1463248

  • RE: Alter Index... Sort_In_Tempdb On

    Christoph D (1/12/2011)

    Seems like a good way to go but keep in mind to do a complete rebuild once in a while, reorganize won't "refresh" the Fillfactor (except if you...

    __________________________________________________________________________________
    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 22, 2012 at 6:25 am

    #1462646

  • RE: Changing data type of column from INT to BIGINT in large table so as to maintain LOG size at current levels in FULL recovery database

    Thanks, I'll need all the luck I can get. 🙂

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

    February 18, 2012 at 6:07 am

    #1448892

  • RE: Changing data type of column from INT to BIGINT in large table so as to maintain LOG size at current levels in FULL recovery database

    Revenant (2/17/2012)

    Jeffrey Williams 3188 (2/17/2012)

    It makes sense to test as you have outlined.

    I am thinking that you won't find much in the way of usage of the transaction log. ...

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

    February 17, 2012 at 4:53 pm

    #1448839

  • RE: Changing data type of column from INT to BIGINT in large table so as to maintain LOG size at current levels in FULL recovery database

    I would agree on this one. I would just go the route of altering the column; this statement is supposedly best optimized to handle this sort of change.

    Related it 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]

    February 17, 2012 at 8:14 am

    #1448543

  • RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

    After reading through this article - http://www.sommarskog.se/grantperm.html#certcrossdb - I think I will go with certificates, specifically a certificate shared in common by the 2 databases that I need to work...

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

    February 4, 2012 at 4:25 pm

    #1442778

  • RE: Should all database backups across the enterprise be scheduled at the same time? Or should they be staggered to balance IO load on fabric/SAN?

    Thank you all for your replies.

    Anyone else? I would be interested in a few more replies, just to get a better feel of what people are doing out there.

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

    January 26, 2012 at 1:56 pm

    #1439024

  • RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

    Thank you all for the suggestions, we are considering all these options.

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

    January 26, 2012 at 4:00 am

    #1438668

  • RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

    Jeff Moden (1/23/2012)

    SQLKnowItAll (1/23/2012)

    Is EXECUTE AS not an option?

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

    It might not be an option if you've written a nice, high performance, inline Table Valued Function.

    Sorry, I don't follow, can you...

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

    January 24, 2012 at 5:46 am

    #1437611

Viewing 15 posts - 106 through 120 (of 1,518 total)