Forum Replies Created

Viewing 15 posts - 14,356 through 14,370 (of 19,560 total)

  • RE: How to get new data source location

    What happens if you extract the query from crystal and run it directly on the new server?

    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

    April 30, 2010 at 12:38 pm

    #1160683

  • RE: How to restore original layout of SSMS2008

    Do you have those two panes "pinned?" If they are unpinned mine does the same thing. Pinning the windows (panes) fixes that.

    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

    April 30, 2010 at 12:35 pm

    #1160681

  • RE: Browser service - use or don't use???

    david.aldridge (4/29/2010)

    Also, I thought that keeping the Browser Service from running increases your security – the instances do not show up in a browse window. Am I right or wrong...

    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

    April 30, 2010 at 12:29 pm

    #1160676

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    Nice article Jeff. Nice to see it republished so we can review it again.

    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

    April 30, 2010 at 12:14 pm

    #1160673

  • RE: Are the posted questions getting worse?

    Steve,

    What is this new content of plagiarism? Where can it be 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

    April 30, 2010 at 12:09 pm

    #1160670

  • RE: Configuring a dedicated port to SQL Server instances.

    Mani-584606 (4/30/2010)

    Thanks,

    Does the Browser services MUST need to be enabled even if we configure static port in CLUSTERED Environment.

    From SQLServer2008FailoverCluster document:

    If you assign static IP ports to all of your...

    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

    April 30, 2010 at 12:01 pm

    #1160664

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/30/2010)

    Right, obviously not SQL Compare. We should use Access.

    SOM

    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

    April 30, 2010 at 10:43 am

    #1160596

  • RE: SQL error on SELECT - MSG4104

    Brandie Tarvin (4/30/2010)

    Wow. I need to add an example like this into my SQL Saturday JOINS class.

    Good catch, Jason.

    That sounds like a good idea. I think it is something...

    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

    April 30, 2010 at 10:37 am

    #1160592

  • RE: Backup when mssqlservice is stopped

    GregoryF (4/30/2010)

    I'm reminded of how many vendor's say their application only will work when connected as sa, and a similar number who say their application must have sa rights.

    No offence...

    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

    April 30, 2010 at 10:34 am

    #1160588

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    Great advice from Nabidavid.

    Good practices in coding seem to dramatically reduce a lot of maintenance and upgrade work.

    Use of the Upgrade advisor will help you in your planning for the...

    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

    April 30, 2010 at 10:31 am

    #1160585

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/30/2010)

    CirquedeSQLeil (4/30/2010)

    tosscrosby (4/30/2010)

    CirquedeSQLeil (4/30/2010)

    Lynn Pettis (4/30/2010)

    Should I be scared? Nearly half of those who have answered the QotD have gotten it wrong. Could be...

    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

    April 30, 2010 at 10:28 am

    #1160581

  • RE: Would You Like a Stay Interview?

    However my feeling is that good managers are probably doing this on a regular basis, and bad ones don't care. So what's the point.

    I think this statement hits it 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

    April 30, 2010 at 10:26 am

    #1160578

  • RE: Backup when mssqlservice is stopped

    GregoryF (4/30/2010)

    I've also seen this behavior with Websense, and currently, we have a finincial compliance/disclosure 3rd party app that creates a new DB every day.

    I often wonder if the people...

    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

    April 30, 2010 at 10:21 am

    #1160573

  • RE: Backups

    Nice Marmot (4/30/2010)

    LOL This is just like one of the certification questions. Nice one, Lynn.

    I imagine there are plenty of these types of questions on the current exams. 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

    April 30, 2010 at 10:20 am

    #1160572

  • RE: Are the posted questions getting worse?

    tosscrosby (4/30/2010)

    CirquedeSQLeil (4/30/2010)

    Lynn Pettis (4/30/2010)

    Should I be scared? Nearly half of those who have answered the QotD have gotten it wrong. Could be people not fully...

    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

    April 30, 2010 at 10:15 am

    #1160568

Viewing 15 posts - 14,356 through 14,370 (of 19,560 total)