Forum Replies Created

Viewing 15 posts - 31 through 45 (of 691 total)

  • RE: Tricky SQL - Please Help

    David Moutray (6/5/2012)

    (If I recall correctly, I do believe I heard Adam recommend using block comments exclusively as opposed to inline comments.)

    Nope, that wasn't me either. I don't know why...

    June 5, 2012 at 8:57 am

    #1497102

  • RE: Tricky SQL - Please Help

    drew.allen (6/5/2012)

    I respectfully disagree. It's not the same amount of work for two reasons.

    1) The first field is often an ID field, and it is much less likely...

    June 5, 2012 at 8:41 am

    #1497092

  • RE: Tricky SQL - Please Help

    David Moutray (6/4/2012)

    You must have me confused with someone else.

    Eh, my apologies. I was at a PASS convention. Whoever said it was incredibly handsome and had a smokin'...

    June 4, 2012 at 8:26 pm

    #1496857

  • RE: Tricky SQL - Please Help

    David Moutray (6/4/2012)

    I don't know what was in the Original Poster's mind, but I heard Adam Machanic recommend putting the commas for multi-line statements at the beginning of the line...

    June 4, 2012 at 8:13 pm

    #1496855

  • RE: Performance Issue In DB

    TravisDBA (1/19/2012)

    Come on guys. :w00t: Drop the crack pipe and step back away please. RIF (Reading Is Fundamental) 😀

    Oooohhh, Reading! Yeah, I *totally* agree. You should start reading a wider...

    January 19, 2012 at 1:42 pm

    #1436158

  • RE: Performance Issue In DB

    SQLKnowItAll (1/19/2012)

    Resistance is Futile?!?! LMAO

    Running is Fantastic?

    Rocking it Futuristic?

    Rollicking in Fields?

    Running in Fear?

    I JUST DON'T KNOW WHAT THE ANSWER IS - SOMEONE HELP ME! 😀

    January 19, 2012 at 1:39 pm

    #1436154

  • RE: Performance Issue In DB

    TravisDBA (1/19/2012)

    Fact. RIF.

    Realistic Imitation Firearm ? 😀

    Room Inventory Form? 😀

    Ruhe in Frieden? 😀

    Routing Information Field? 😀

    Rain-Induced Fade? 😀

    Rapid Innovation Fund? 😀

    😀 😀 😀 😀 😀 😀 😀 😀 😀 :-D...

    January 19, 2012 at 1:30 pm

    #1436150

  • RE: Performance Issue In DB

    TravisDBA (1/19/2012)

    Well..Brad McGeHee wrote a entire book on it and he does not say that at all, quite the contrary, so who should I listen to? Him or you? BTW,...

    January 19, 2012 at 11:28 am

    #1436094

  • RE: Baseline Using Adam Machanic Tool From PASS SUMMIT 2011

    Hi Carol,

    Please e-mail me at the e-mail address on the bio slide in the book you received when you attended the seminar. I'll be happy to assist you privately.

    Best,

    Adam

    January 12, 2012 at 1:13 pm

    #1432856

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    Marios Philippopoulos (8/31/2011)

    I noticed that there are 3 threads for that session: 3 records returned. Why would that be?

    3 threads? You're not joining to any views that deal with threads....

    August 31, 2011 at 3:09 pm

    #1375732

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    What do you get from the original_login_name column? And what does "blank" mean? NULL? Or an empty string?

    August 31, 2011 at 8:07 am

    #1375493

  • RE: CXPACKET Wait - advice on Max Dop setting

    Grant Fritchey (6/10/2011)

    It's not automatic that the query will generate a parallel plan. The storage engine makes that determination, not the optimizer.

    The storage engine? Are you sure about that?

    July 26, 2011 at 1:40 pm

    #1358788

  • RE: sp_WhoIsActive , quick question from newbie...

    I understand that it's a bit confusing at first, but once you get used to it it works much more nicely as a default. After a while you'll no longer...

    May 10, 2011 at 7:21 pm

    #1322709

  • RE: sp_WhoIsActive , quick question from newbie...

    colin.Leversuch-Roberts (5/10/2011)

    funny enough I just posted about this, sort of, on my blog. I never use procs for this type of thing - far too restrictive and not flexible in...

    May 10, 2011 at 6:51 pm

    #1322703

  • RE: sp_WhoIsActive , quick question from newbie...

    Lowell (5/9/2011)

    John I downloaded the proc and put it on my dev server that i know is fairly busy, and even with those two bits turned on, I couldn't get...

    May 10, 2011 at 6:48 pm

    #1322702

Viewing 15 posts - 31 through 45 (of 691 total)