Forum Replies Created

Viewing 15 posts - 976 through 990 (of 1,518 total)

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    Well, after a long while, I have an answer to this, thanks to Microsoft.

    To remind everyone of the issue, I had the following query (just the scheleton shown for simplicity):

    CREATE...

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

    #862793

  • RE: OS pages per second very high on database server

    Michael Valentine Jones (8/25/2008)

    You need to look at the type of paging to know if there is a problem.

    Running backups can cause paging as the OS allocates file system 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]

    August 25, 2008 at 10:54 am

    #862658

  • RE: OS pages per second very high on database server

    TheSQLGuru (8/25/2008)

    1) >> We are using AWE: we have locked the working set to 11.5 GB (we should probably increase that).

    NO you shouldn't, not if you 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]

    August 25, 2008 at 10:53 am

    #862657

  • RE: OS pages per second very high on database server

    Sean Kohler (8/24/2008)

    What are the box specifics? Mem, CPU, Page File size, OS

    SQL 2005? 64bit?

    Any other applications running outside of normal Windows processes?

    Are you limiting memory to 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]

    August 24, 2008 at 6:50 am

    #862285

  • RE: Need help with Blocking SPIDs query

    charshman (8/22/2008)

    I noticed in the second half of your OR condition, you check:

    [font="Courier New"]R.blocking_session_id = 0 AND R.session_id IN ...[/font]

    It looks like your query will show the blocked processes, but...

    __________________________________________________________________________________
    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 22, 2008 at 11:04 am

    #862048

  • RE: Column Encryption in SQL Server 2005

    Abhijit (8/22/2008)

    yes we can implement column level encryption using the ASYMMETRIC KEY and SYMMETRIC KEY to encrypt & decrypt the column data.

    check msdn for brief help on ASYMMETRIC KEY and...

    __________________________________________________________________________________
    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 22, 2008 at 3:59 am

    #861740

  • RE: Enabling Database Mail

    I don't know if this was mentioned already...

    What version are you 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]

    August 18, 2008 at 6:38 pm

    #859755

  • RE: Enabling Database Mail

    Maquis (8/18/2008)

    If I get a "1" as a result from the query

    SELECT is_broker_enabled

    FROM sys.databases

    WHERE name = N'msdb';

    then I don't even need to stop the SQL Server Agent, 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]

    August 18, 2008 at 1:37 pm

    #859640

  • RE: Script to configure all jobs in an instance to write to the Event Log on failure

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

    August 15, 2008 at 4:44 am

    #858600

  • RE: Enabling Database Mail

    Maquis (8/14/2008)

    We've been using sp_SQLSMTPMail for months, and today it decided to die with this error:

    Error setting Message configuraton field "smtpserver".

    CDO.Configuration.1

    A dynamic link library (DLL) initialization routine failed.

    I've read 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]

    August 14, 2008 at 2:57 pm

    #858424

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/13/2008)

    Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know...

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

    #857401

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/12/2008)

    Sorry I haven't been taking part in the discussion. Rhode Island celebrates VJ Day so I had the day off... Whatever.

    Adding in reporting or views would be a...

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

    #857008

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/12/2008)

    Thanks.

    I've been remiss in my writing just lately (Tom, who I'm supposed to be working with, is going to kick my butt). There will be another OpsMgr article...

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

    #856918

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/12/2008)

    Lots of cursing. If you run out of good words, let know. I used to be a sailor.

    😉

    Maybe that's the recipe of success with SCOM, I'll keep 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]

    August 12, 2008 at 10:07 am

    #856838

  • RE: Operations Manager Custom Collection

    Grant Fritchey (8/12/2008)

    Here's the bad news, the amount of good information in a single source on writing custom reports in OpsMgr is even less than that for programming against it.

    Have...

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

    #856825

Viewing 15 posts - 976 through 990 (of 1,518 total)