Forum Replies Created

Viewing 15 posts - 121 through 135 (of 381 total)

  • RE: Security - Hit or Miss

    These are all for sql logins so I don't understand how I could possibly have inherited permissions. The statements that you see are the statements I ran across ever...

    June 16, 2011 at 6:54 pm

    #1340140

  • RE: Execution Plan Aging

    GilaMonster (5/26/2011)

    Neither. There's one execution plan, created when the procedure runs that contains the query plans for both branches of the query.

    Gale,

    So if the query plan does the branches, can...

    May 26, 2011 at 12:21 pm

    #1330571

  • RE: Recompilation and CPU issues

    Grant Fritchey (5/26/2011)

    Jack Corbett (5/26/2011)

    Grant,

    Isn't the compile time for large procedures why they changed to statement level compile with 2005? In theory the whole procedure should not need to...

    May 26, 2011 at 12:11 pm

    #1330565

  • RE: Recompilation and CPU issues

    Grant Fritchey (5/26/2011)

    You're still guaranteed a recompile each time a temp table is created and first referenced.

    Grant,

    I understand that I will get recompile each time a temp table is created...

    May 26, 2011 at 12:09 pm

    #1330564

  • RE: Recompilation and CPU issues

    Grant Fritchey (5/26/2011)

    When you create temporary tables, you get a recompile. When you add a row to temporary tables, you get a recompile because of the stats updates. Then, statistics...

    May 26, 2011 at 6:29 am

    #1330239

  • RE: Execution Plan Aging

    GilaMonster (5/26/2011)

    If you want the exact time it goes away, profiler (server side trace better) the performance statistics event (under Performance)

    Hmm, that event needs a blog post.

    I would love to...

    May 26, 2011 at 6:20 am

    #1330232

  • RE: Execution Plan Aging

    Grant Fritchey (5/26/2011)

    That's a good idea to know exactly how long it was there. To just get an idea of how long it's been there at a moment in time,...

    May 26, 2011 at 6:19 am

    #1330230

  • RE: Recompilation and CPU issues

    Jack Corbett (5/25/2011)

    As I'm reading this whitepaper, http://msdn.microsoft.com/en-us/library/ee343986.aspx, I'm wondering if all the connections have the same SET options. Several SET options cause re-compiles.

    This same whitepaper also mentions that...

    May 25, 2011 at 2:16 pm

    #1329943

  • RE: Recompilation and CPU issues

    Jack Corbett (5/25/2011)

    Here are a couple of questions I have:

    How do you know that this is a huge number of recompiles? What metrics do you have to compare this...

    May 25, 2011 at 2:06 pm

    #1329936

  • RE: Tie multiple users to a single login

    Yea, I already had the role setup and it does make it easier. Just wish I didn't have to create users each time. :p Just me being...

    April 26, 2011 at 9:59 am

    #1315984

  • RE: Tie multiple users to a single login

    K. Brian Kelley (4/25/2011)

    Do you have the option of using Windows groups and Windows authentication? If so, this is trivial. Put both sets of users in a Windows group. Make...

    April 25, 2011 at 7:19 pm

    #1315668

  • RE: Running Total's CTE Challenge

    Jeff Moden (4/22/2011)

    Shifting gears, if you still need help with this, let me know and I'll see what I can do over the weekend.

    Below is what I ended up doing....

    April 22, 2011 at 2:20 pm

    #1315032

  • RE: Running Total's CTE Challenge

    Jeff Moden (4/21/2011)

    I don't believe running totals are going to help here, folks. This isn't a flat file... it's a Hierarchy.

    You are correct. That is why the running...

    April 22, 2011 at 2:16 pm

    #1315028

  • RE: Junior DBA

    Won't speak for everyone, but I was given the grunt work. When jobs failed, it was my job to find out why and report them to the DBA and...

    April 19, 2011 at 7:53 am

    #1313353

  • RE: Unit Testing With Visual Studio

    Grant,

    I realize that this is a rather old article, so I hope you will actually get this. VS 2010 Pro and Ultimate now include the database unit testing in...

    January 24, 2011 at 12:30 pm

    #1277418

Viewing 15 posts - 121 through 135 (of 381 total)