Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 1,518 total)

  • RE: Running SELECT Query and Sprocs same dataset

    ... or try the following (don't use * though, not a good practice - use named list instead):

    ="SELECT * FROM Employees; EXEC dbo.insert_into_table_Sprocs @parameter=" & Parameters!XXX.Value

    Give that a try. Play...

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

    #795078

  • RE: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn "

    I'll confess I'm addicted to this site...

    Every time I get an email notification on a new posting, it's as if it goes straight to my veins! :w00t:

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

    #794968

  • RE: Newbie: which sql job is maxing the CPU

    Also, it may be that Max. degree of parallelism (MAXDOP) is set to an excessively high value on your instance.

    Run the following query to get the top 10 wait types...

    __________________________________________________________________________________
    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, 2008 at 4:47 pm

    #794936

  • RE: DTA Stopped unexpectedly

    Since DTA stops unexpectedly, run the following statement to ensure there are no hypothetical indexes left behind:

    SELECT *

    FROM sys.indexes

    WHERE is_hypothetical = 1

    Drop any such...

    __________________________________________________________________________________
    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, 2008 at 4:14 pm

    #794923

  • RE: DTA Stopped unexpectedly

    I think the DTA still needs a lot of work on behalf of the SQL Server dev team.

    I have only been able to get it to work on individual queries...

    __________________________________________________________________________________
    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, 2008 at 4:03 pm

    #794917

  • RE: Newbie: which sql job is maxing the CPU

    Provided your instance has been running long enough for adequate stats - say a few days - the following query will yield the top 10 most CPU-intensive queries since last...

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

    #794914

  • RE: Flush the queries from the RAM

    GilaMonster (3/27/2008)

    284MB for the plan cache on a server with 16 GB is nothing. I really wouldn't worry.

    What are your server's max and min memory settings? Anything else on 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 27, 2008 at 3:41 pm

    #794909

  • RE: How to kill Rollback process

    Adam Haines (3/27/2008)

    Simple recovery does not mean the log is not used. If transaction were not logged in the t-log how would you rollback transactions? This is why...

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

    #794837

  • RE: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn "

    rbarryyoung (3/26/2008)

    On second thought, maybe you should just brung Brian along. 😉

    I don't think I can afford him... 😉

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

    #794715

  • RE: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn "

    rbarryyoung (3/26/2008)

    Marios Philippopoulos (3/24/2008)

    So at the moment I'm stuck with a less than ideal scenario, and I want to try the Kerberos-auth option...

    Good luck. Make sure that you've got...

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

    #794713

  • RE: CacheMiss event in SQL Server 2005

    colin Leversuch-Roberts (3/26/2008)

    if your proc call is not the same case as your proc def then you'll get a cache miss event. What's more worrying is that in a highly...

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

    #794187

  • RE: Annotate text SELECTIVELY in Value property of a textbox in Report Designer

    Tim Mitchell (3/25/2008)

    I don't think you can do what you describe if you only use one control. Controls are rendered as a whole rather than character-by-character.

    Is there any reason...

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

    #794088

  • RE: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn "

    There's a great document which details how to configure and troubleshoot Kerberos delegation related problems here (it's essential reading for CRM 3.0 configurations where all the tiers are on separate...

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

    #794032

  • RE: Displaying locks used in an Execution Plan

    Grant Fritchey (3/25/2008)

    ...For details on locking, I'd look at Inside SQL Server 2005 "The Storage Engine."

    ...pages 345 ff 🙂

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

    #793780

  • RE: Ready Made Code Snippet Tool Box Courtesy of SCOM

    I have the exact same issue - some more info on the file location would be appreciated

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

    #793615

Viewing 15 posts - 1,306 through 1,320 (of 1,518 total)