Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 19,560 total)

  • RE: Databases are under "Suspect" Mode

    SQLCrazyCertified (1/8/2013)

    Thanks, I did that.

    I ran dbcc chekcdb(dbname)....and looked at the error, I see an error 'An error occurred in the service broker manager, error:823, state 2.

    I also see another...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 8, 2013 at 4:07 pm

    #1575023

  • RE: How's this for a Job Description

    Evil Kraig F (1/8/2013)

    Scott D. Jacobson (1/8/2013)

    hisakimatama's latest post is beyond frightening. This is like saying "I need you to be a DBA but also drive a tractor trailer". There...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 8, 2013 at 3:47 pm

    #1575017

  • RE: How's this for a Job Description

    Grant Fritchey (1/8/2013)

    hisakimatama (1/8/2013)

    No kidding. I saw the SQL-related bits and figured the salary was acceptable enough, then I caught the rest of it... Ack. Amusingly, there's...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 8, 2013 at 2:17 pm

    #1574994

  • RE: sql server memory

    I have had Apache cause that several times for me. I have even had malware scanners cause it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 11:08 pm

    #1574619

  • RE: Total across multiple reports

    Each report has different parameters I would assume (to at least query different data from the database). Why not add an additional query that sums all data being summed...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 10:14 pm

    #1574610

  • RE: MCTS Certificate for SQL Server 2008

    At this point I would go the MCSA and MCSE route.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 10:09 pm

    #1574608

  • RE: Coalesce and Conversion

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 10:07 pm

    #1574607

  • RE: When to Index

    dwilliscp (1/7/2013)

    SQLRNNR (1/7/2013)

    dwilliscp (1/7/2013)

    GSquared (1/7/2013)

    "When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

    There's no way to tell,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 9:59 pm

    #1574606

  • RE: 1 sp out of 4 not executing even though user has execute permissions on all 4

    If you stub a proc with the same permissions, do you get results from the openquery piece of the query? Eliminate the Join and the insert - make sure...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 9:54 pm

    #1574605

  • RE: Help needed to trobleshoot opening Report manager Url

    Mac1986 (1/3/2013)

    Yes its all resolved now. I connecttion string in the datasource was not correct.

    Good to hear.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 9:47 pm

    #1574604

  • RE: RANK - 1

    Yippee skippee - thanks Ron.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 1:13 pm

    #1574504

  • RE: When to Index

    dwilliscp (1/7/2013)

    GSquared (1/7/2013)

    "When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

    There's no way to tell, from what...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 1:07 pm

    #1574501

  • RE: 1 sp out of 4 not executing even though user has execute permissions on all 4

    And the linked table, does this role have the appropriate permissions on it?

    Have you tried to run the proc while logged in as a user in that role (not yourself)...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 11:35 am

    #1574453

  • RE: When to Index

    Looking at this query, I wouldn't look at indexes with an improvement_measure of less than 1000. But that is nothing set in stone. It is a starting point.

    What...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 11:32 am

    #1574450

  • RE: 1 sp out of 4 not executing even though user has execute permissions on all 4

    Does the table involved in the insert, or any of the tables in the non-functioning sp, have deny permissions for the users or role?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 7, 2013 at 11:22 am

    #1574445

Viewing 15 posts - 5,296 through 5,310 (of 19,560 total)