Forum Replies Created

Viewing 15 posts - 15,661 through 15,675 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/31/2010)

    I'm sure I missed a few things while I was gone. I'll try to get through this thread, once I remove about 600 messages from my...

    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

    March 31, 2010 at 6:04 pm

    #1143570

  • RE: Why I cannot connect SQL Server on any port other than 1433 remotely?

    rainleta (3/31/2010)

    If I use machine_name,1533 in SMSS, it works. It seems the SQL Browser doesn't work?

    I am not sure the Browser service works that way. If there are multiple...

    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

    March 31, 2010 at 6:03 pm

    #1143569

  • RE: Index usage overview

    crainlee2 (3/31/2010)

    Wilfred and Jason,

    Thanks to both of you for taking the time to implement and publish your queries.

    I have an immediate use for them at work.

    LC

    You are welcome.

    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

    March 31, 2010 at 6:00 pm

    #1143568

  • RE: Wildcard range search

    The same result occurs if you eliminate the >= '1%'.

    If you do it this way though, it will work.

    Declare @var1varchar(10)

    ,@var2varchar(10)

    Select @var1 = '1%',@var2 = Number

    From Example

    where Number like...

    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

    March 31, 2010 at 5:59 pm

    #1143566

  • RE: Why I cannot connect SQL Server on any port other than 1433 remotely?

    Are you able to connect if you specify the port number?

    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

    March 31, 2010 at 5:49 pm

    #1143560

  • RE: SSIS will not start

    Are there any other error messages along with that message?

    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

    March 31, 2010 at 5:39 pm

    #1143559

  • RE: User & Their Databases access with Access levels

    Check out this article:

    http://jasonbrimhall.info/?p=391

    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

    March 31, 2010 at 5:35 pm

    #1143556

  • RE: MSSQLServerADHelper Error in event log

    Try this

    http://www.eventid.net/display.asp?eventid=100&eventno=4016&source=MSSQLServerADHelper&phase=1

    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

    March 31, 2010 at 5:33 pm

    #1143555

  • RE: The Missing Certification

    Lynn Pettis (3/31/2010)

    Jeff Moden (3/31/2010)

    Lynn Pettis (3/31/2010)

    Gift Peddie (3/31/2010)

    Jeff Moden (3/29/2010)

    Gift Peddie (3/29/2010)

    All I want is please leave the doors open to all [font="Arial Black"]with the ability[/font].

    Exactly... 🙂

    Thanks Jeff I...

    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

    March 31, 2010 at 5:27 pm

    #1143553

  • RE: Index usage overview

    I have taken this script provided by Wilfred and updated it to SQL 2005.

    If interested, you can read about it at:

    http://jasonbrimhall.info/?p=407

    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

    March 31, 2010 at 4:18 pm

    #1143542

  • RE: The Missing Certification

    Steve Jones - Editor (3/31/2010)

    Why do I feel this discussion has gotten way off track?

    It was lunch time.

    We will get back on track. Need time to digest the 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

    March 31, 2010 at 3:59 pm

    #1143532

  • RE: The Missing Certification

    GilaMonster (3/31/2010)

    Lynn Pettis (3/31/2010)

    GilaMonster (3/31/2010)

    WayneS (3/31/2010)

    dma-669038 (3/31/2010)

    One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')

    Makes me wonder 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

    March 31, 2010 at 3:23 pm

    #1143513

  • RE: Problem renaming database files

    cjohn5552 (3/31/2010)

    Hi,

    Thanks for all the replies. Database ownership isn't something I had really considered until recently. Is there a system table that lists the owners of all...

    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

    March 31, 2010 at 3:20 pm

    #1143511

  • RE: An interesting thing about isnull

    Thanks Hugo for providing that test case to demonstrate the bug.

    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

    March 31, 2010 at 2:50 pm

    #1143490

  • RE: The Missing Certification

    GSquared (3/31/2010)

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table scan and index...

    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

    March 31, 2010 at 2:45 pm

    #1143485

Viewing 15 posts - 15,661 through 15,675 (of 19,560 total)