Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 1,518 total)

  • RE: Database send mail error

    balbirsinghsodhi (7/25/2008)

    It's working when I use SP_send_dbmail instead of xp_sendmail don't know why it's like that but it's working.

    Thanks guys.

    xp_sendmail (SQL MAIL) requires an OUTLOOK client. If there is no...

    __________________________________________________________________________________
    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 25, 2008 at 3:28 pm

    #848712

  • RE: Operations Manager and SQL Server

    SanjayAttray (7/23/2008)

    Good article. But, OpsMgr is not as accurate and trust worthy as it has to be. I implemented it couple of weeks back and even though my...

    __________________________________________________________________________________
    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, 2008 at 12:16 pm

    #847270

  • RE: Operations Manager and SQL Server

    This is something I have been looking forward to for a while.

    There is not a lot of SQL-Server-specific SCOM info out there.

    Thanks!

    __________________________________________________________________________________
    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, 2008 at 10:12 am

    #847174

  • RE: Prod Server ... High CPU with Lastwaitype "SOS_SCHEDULER_YIELD"

    shalu (7/21/2008)

    These are the information I have with me now. Do let me what do think about the counters and how should I proceed further.

    System info:

    Hardware: Intel Xeon MP...

    __________________________________________________________________________________
    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 22, 2008 at 8:15 am

    #846429

  • RE: Need MDX query to calculate weighted averages

    Well, I have finally been able to come up with the right MDX query, but, although it works in SSMS, it gives me an error in the BIDS project (calculated...

    __________________________________________________________________________________
    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 18, 2008 at 2:49 pm

    #845264

  • RE: Time out occurred while waiting for buffer latch

    neeraj_nagpal (7/10/2008)

    I hope its not the case for you, but I got these errors when table had corruption. If you are seeing warnings for a particular object, please run checktable...

    __________________________________________________________________________________
    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 17, 2008 at 9:30 am

    #844489

  • RE: Call a web service from T-SQL

    noeld (7/16/2008)

    But I would go even further. When you find yourself in this situation you should try to call the webservice from the "CLIENT" not on the server.

    There are...

    __________________________________________________________________________________
    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 16, 2008 at 12:25 pm

    #843995

  • RE: What is the proper procedures of SP2 installation ?

    EdVassie (7/16/2008)

    I recommend that master DB and resource DB mdf and ldf should always remain in their default locations. The SP2 install does not honour the method given in BOL...

    __________________________________________________________________________________
    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 16, 2008 at 10:07 am

    #843907

  • RE: mssqlsystemresource database

    Be very careful about moving master and systemresource db files. They must be in the same location for the SQL 2005 SP2 upgrade to work!

    Believe me, I'm talking from...

    __________________________________________________________________________________
    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 16, 2008 at 9:15 am

    #843871

  • RE: Prod Server ... High CPU with Lastwaitype "SOS_SCHEDULER_YIELD"

    What is the Max Degree of Parallelism on your instance?

    __________________________________________________________________________________
    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 16, 2008 at 8:25 am

    #843804

  • RE: Blockings related to SQL Server

    Try sp_blocker_pss80:

    http://support.microsoft.com/kb/271509

    __________________________________________________________________________________
    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 16, 2008 at 8:13 am

    #843795

  • RE: What is the proper procedures of SP2 installation ?

    onlo (7/15/2008)

    Dear all,

    What is the proper procedures of SP2 installation ?

    My production server has been running for more than 2 years, I want to upgrade it from SP1 to SP2...

    __________________________________________________________________________________
    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 16, 2008 at 8:01 am

    #843784

  • RE: Prod Server ... High CPU with Lastwaitype "SOS_SCHEDULER_YIELD"

    This looks like a good link:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=790196&SiteID=1

    __________________________________________________________________________________
    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 16, 2008 at 7:51 am

    #843773

  • RE: query

    GilaMonster (7/16/2008)

    Marios Philippopoulos (7/15/2008)

    last_execution_time[/b] value in the DMV is, say, from a week ago, wouldn't it be safe to assume that query plans that are a week...

    __________________________________________________________________________________
    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 16, 2008 at 7:27 am

    #843749

  • RE: query

    GilaMonster (7/15/2008)

    HanShi (7/15/2008)

    Keep in mind that the results are reset whenever the SQL-service is restarted.

    Entries disappear from the query_stats DMV when the query plan is discarded from the plan cache....

    __________________________________________________________________________________
    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 15, 2008 at 6:13 pm

    #843465

Viewing 15 posts - 1,051 through 1,065 (of 1,518 total)