Forum Replies Created

Viewing 15 posts - 151 through 165 (of 309 total)

  • RE: Can't log out.

    Luis Cazares (9/9/2014)

    On a server? Are you serious?:w00t:

    Yes on the server. I asked one of co-worker to RDP into the server and kick me out but he ended up getting...

  • RE: Getting error while inserting data in a table.

    Luis Cazares (9/5/2014)


    You might want to change your table definition to prevent truncation errors.

    CREATE TABLE dbo.TraceResults(

    TextData nvarchar(max) NULL,

    ApplicationName nvarchar(256) NULL,

    NTUserName nvarchar(256) NULL,

    LoginName nvarchar(256) NULL,

    CPU int NULL,

    Reads bigint NULL,

    Writes bigint NULL,

    Duration...

  • RE: Need some help with Server Side Trace.

    Grant Fritchey (9/4/2014)


    Start time, you need to schedule it to run somehow. Generally, I'd use SQL Agent, but you can put anything to work on it that can fire off...

  • RE: Need some help with Server Side Trace.

    I ran a profiler and selected Standard template and then save that to a file and this is what I have.

    This is what I need help with:

    How do I get...

  • RE: Index creation

    GilaMonster (8/7/2014)


    What does "Creating an index within the application" even mean?

    No Idea. I wanted to ask him the same thing, but I didn't. I don't know if this is something...

  • RE: Performance tuning classes?

    Grant Fritchey (7/31/2014)

    So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.

    Well we do have an open door policy...

  • RE: Performance tuning classes?

    Grant Fritchey (7/31/2014)


    Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.

    I live in Chicago, IL

  • RE: 1 Quick question for all the DBA's

    ScottPletcher (7/22/2014)


    I have also done some stuff to improve performance by creating appropriate indexes and by changing the way queries are written.

    I think that's one of the most value-added and...

  • RE: 1 Quick question for all the DBA's

    GilaMonster (7/22/2014)


    New Born DBA (7/22/2014)1) I haven't set up any alerts on the system since all the alerts are in place?(I am hoping that they are in place, but have...

  • RE: 1 Quick question for all the DBA's

    Thanks everybody for taking their time out and helping me. There are tons of things I need to learn and most of you guys have suggested me with some amazing...

  • RE: 1 Quick question for all the DBA's

    GilaMonster (7/22/2014)Not what I asked.

    Have you set up alerts on your systems?

    Have you set up automated restore tests?

    Have you set up job monitoring?

    Aaha! of course this is not what you...

  • RE: 1 Quick question for all the DBA's

    Grant Fritchey (7/22/2014)


    Learn PowerShell.

    Automate all the things.

    Would love to, but where should I start?

  • RE: 1 Quick question for all the DBA's

    Jeff Moden (7/21/2014)


    New Born DBA (7/21/2014)


    Jeff Moden (7/21/2014)Read about what? If it's not about SQL Server, T-SQL, or setting up one of the "silly" experiments you were talking about,...

  • RE: 1 Quick question for all the DBA's

    Jeff Moden (7/21/2014)Read about what? If it's not about SQL Server, T-SQL, or setting up one of the "silly" experiments you were talking about, etc, etc, then you're not...

  • RE: 1 Quick question for all the DBA's

    GilaMonster (7/21/2014)


    Do you have scheduled test restores? Agent alerts? Job failure alerts?

    We do get alerts time to time but its mostly because space issues or sometimes network issues. (its rare)

    Have...

Viewing 15 posts - 151 through 165 (of 309 total)