Forum Replies Created

Viewing 15 posts - 11,131 through 11,145 (of 19,560 total)

  • RE: Server Type in SMS?

    Multiple SQL instances don't share the same id. One SSRS instance per server is allowed.

    Perms for SSRS 2008 are not performed through SSMS. You have to connect to...

    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 21, 2011 at 9:45 am

    #1276644

  • RE: Variables won't update from a Script Task

    Nice catch Phil

    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 21, 2011 at 9:31 am

    #1276632

  • RE: Server Type in SMS?

    Is this SSRS 2008, SSRS 2005, IIS, or something else that you are trying to set permissions on?

    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 21, 2011 at 9:11 am

    #1276620

  • RE: Today's Random Word!

    Unfortunate

    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 21, 2011 at 8:40 am

    #1276600

  • RE: 2nd problem w/ newbie in SQL in need

    Lynn Pettis (1/21/2011)

    CirquedeSQLeil (1/21/2011)

    Lynn Pettis (1/20/2011)

    If you took the time to do a little research in Books Online, you would probably have been able to figure this one out 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 21, 2011 at 8:39 am

    #1276597

  • RE: How to make Net Meeting a success

    Roy Ernest (1/21/2011)

    Thanks Jason. Yes murphys law is something that always peeks its head out when it is not welcome... 😀 We had the problem with Waynes presentation. 🙁

    We found...

    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 21, 2011 at 7:05 am

    #1276524

  • RE: 2nd problem w/ newbie in SQL in need

    Lynn Pettis (1/20/2011)

    If you took the time to do a little research in Books Online, you would probably have been able to figure this one out yourself.

    There are...

    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 21, 2011 at 6:59 am

    #1276521

  • RE: Temporary table performing much better than table variable

    Ajit Goswami-482889 (1/20/2011)

    All your guesses are true but my issues is not mainly about the performance but the weird behavior that is being demonstrated by SQL.

    I am using 3 table...

    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 21, 2011 at 6:57 am

    #1276519

  • RE: 2nd problem w/ newbie in SQL in need

    There is more than one way to do this one. A common method would be to use count(), group by, and order by.

    See what you can get by looking...

    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 20, 2011 at 9:18 pm

    #1276356

  • RE: SQL Server Port Number Identifier

    Looks good. Thanks for posting the script.

    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 20, 2011 at 8:18 pm

    #1276351

  • RE: Temporary table performing much better than table variable

    I would pay close attention to what Wayne has to say about the topic. He has some very good information.

    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 20, 2011 at 8:05 pm

    #1276347

  • RE: 2nd problem w/ newbie in SQL in need

    What have you tried so far to get the desired result?

    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 20, 2011 at 8:03 pm

    #1276346

  • RE: Help a newbie w/ complex SQL

    mailboxo71 (1/20/2011)

    I have the following database structure and I need a SQL query to retrieve a list of order ids and their totals (including shipping amount). And I need to...

    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 20, 2011 at 8:01 pm

    #1276344

  • RE: Is this a Proper Backup?

    Your full backup takes 8hrs and you only backup the transaction logs once a day? How many transactions a day are you running?

    Do you need to be able to...

    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 20, 2011 at 7:11 pm

    #1276337

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    Thanks for the article Perry.

    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 20, 2011 at 5:05 pm

    #1276314

Viewing 15 posts - 11,131 through 11,145 (of 19,560 total)