Forum Replies Created

Viewing 15 posts - 8,056 through 8,070 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (11/2/2011)

    I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run...

    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

    November 2, 2011 at 11:47 am

    #1402332

  • RE: Help with getting info from another table

    littlelisa1111 (11/2/2011)

    I added the Id from the leads table. Since the IDs are different but the names are the same it makes me think that the users...

    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

    November 2, 2011 at 10:04 am

    #1402244

  • RE: What else have you done?

    Nothing exciting like that for me. Stock and bag groceries and then manage a convenience store. Then I got into IT very early in my career.

    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

    November 2, 2011 at 9:43 am

    #1402230

  • RE: SSIS TransactionProperty

    It should be started on the 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

    November 2, 2011 at 9:26 am

    #1402222

  • RE: Help with getting info from another table

    It sounds like you have multiple entities in the leads table that match each name. Do you have another field you can use in your join?

    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

    November 2, 2011 at 9:24 am

    #1402220

  • RE: Script to enable Auto-growth

    Kenneth Fisher-475792 (11/2/2011)

    I had thought of using sp_msforeachdb. But for each database you have to scan through all of the data files (and/or log files depending on what 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

    November 2, 2011 at 9:05 am

    #1402205

  • RE: Today's Random Word!

    Revenant (11/2/2011)

    SQLRNNR (11/2/2011)

    L' Eomot Inversé (11/2/2011)

    SQLRNNR (11/1/2011)

    Rameumptom

    Zoramite

    Google?

    Mormons

    Yup

    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

    November 2, 2011 at 9:03 am

    #1402202

  • RE: Triggers

    Nice question. I liked it. It made me take a quick second thought - but types practically gave it away.

    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

    November 2, 2011 at 8:34 am

    #1402163

  • RE: Today's Random Word!

    L' Eomot Inversé (11/2/2011)

    SQLRNNR (11/1/2011)

    Rameumptom

    Zoramite

    Google?

    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

    November 2, 2011 at 8:31 am

    #1402159

  • RE: Today's Random Word!

    Genghis

    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

    November 2, 2011 at 8:30 am

    #1402156

  • RE: Autoshrink in our client's databases

    Sachin Nandanwar (11/2/2011)

    I wouldnt worry about fragementation for indexes having less than 1000 pages.

    That doesn't hold true. It is a myth. The person that said it said 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

    November 2, 2011 at 8:19 am

    #1402149

  • RE: Log Growing Pains

    Jack Corbett (3/11/2010)

    Nice article Jason. I'll be interested in what you find from Event Notifications.

    Wow, this has been some time coming. I have not forgotten about the need...

    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

    November 1, 2011 at 7:36 pm

    #1401954

  • RE: Autoshrink in our client's databases

    That is good to hear. Keep hanging out and you should be able to keep learning. 🙂

    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

    November 1, 2011 at 6:42 pm

    #1401948

  • RE: Script to list all logins and permissions

    Here is another little script you could take a look at.

    http://jasonbrimhall.info/2010/03/19/security-audit/

    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

    November 1, 2011 at 6:41 pm

    #1401947

  • RE: Field Level Auditing using Change Data Capture - Part 1

    Nice article.

    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

    November 1, 2011 at 6:17 pm

    #1401942

Viewing 15 posts - 8,056 through 8,070 (of 19,560 total)