Forum Replies Created

Viewing 15 posts - 931 through 945 (of 1,187 total)

  • RE: Finding DML statements in stored procedures with SQL Profiler

    Dev (7/25/2008)

    I would also like to know if this is possible?

    Dev,

    Here is a trace template definition I used that you may want to try. (It's for SQL 2000 Profiler,...

    July 25, 2008 at 4:23 pm

    #848722

  • RE: Finding DML statements in stored procedures with SQL Profiler

    Steve Jones - Editor (7/24/2008)

    You can profile at the statement level, which I think will catch statements inside stored procedures.

    Thanks, Steve, this lead was very helpful! It took me a...

    July 25, 2008 at 4:05 pm

    #848720

  • RE: DBCC command turning up repeatedly in Profiler

    GilaMonster (7/15/2008)

    Then someone's running a proc/sql batch on the other server that's checking your statistics.

    Have a look at the server that's the source of this. See what you can see...

    July 15, 2008 at 7:50 am

    #843109

  • RE: Short cut key

    jpowers (7/14/2008)

    Did anyone else notice the date for this QOTD is a month in the future?

    Doc Brown rules!

    :blink:

    Yes, I did. Time travel is real! 🙂

    July 15, 2008 at 7:47 am

    #843104

  • RE: DBCC command turning up repeatedly in Profiler

    GilaMonster (7/15/2008)

    Shouldn't do.

    What user and application are you seeing those statements from? What SPID?

    The SPID was 206. The user was the user we set up for the linked server...

    July 15, 2008 at 7:43 am

    #843098

  • RE: DBCC command turning up repeatedly in Profiler

    SQL ORACLE (7/14/2008)

    Did you check the setting of the update statistics for each database?

    Thank you for your response.

    Do you mean the 'Auto Update Statistics' option in the Options tab of...

    July 14, 2008 at 2:48 pm

    #842701

  • RE: Data Compression

    Great question. I was guessing on this one, and I almost picked the right answer. But the Backup choice lured me away. 🙂

    July 14, 2008 at 8:31 am

    #842417

  • RE: Reformat via query?

    This is a great question to keep people from cheating by running it. 🙂

    Cheers,

    webrunner

    July 11, 2008 at 8:01 am

    #841502

  • RE: The Value of an MBA in IT

    Here are my two cents.

    Motivation:

    I think most people who go for an MBA want it to help them with the starting salary, not necessarily with the subsequent yearly increases. In...

    July 10, 2008 at 8:51 am

    #840885

  • RE: What's an MVP?

    Steve,

    In your editorial you write, "I'm not sure why I was picked."

    That's very humble. But as someone who has benefited from the SQL expertise that you and many others bring...

    July 9, 2008 at 10:21 am

    #840337

  • RE: To Certify or Not To Certify

    Excellent parody - a perfect balance of humor and poignancy. Thanks!

    webrunner

    July 3, 2008 at 8:45 am

    #837909

  • RE: Windows Event Log entries prior to maintenance are gone

    Thanks so much for the replies.

    webrunner

    June 13, 2008 at 7:47 am

    #828495

  • RE: Friday the 13th

    Timothy Baker (6/13/2008)

    I went along with it too since I'm not superstitious either. Which is a god thing since I went to WalMart this morning to get a few...

    June 13, 2008 at 7:39 am

    #828486

  • RE: Physical Database Architecture

    Timothy Ford (5/28/2008)

    Tricky question, but a fair one. I almost got suckered into the 8KB calculation...

    Yes, tricky. I was in fact suckered into the 8 KB calculation. :hehe:

    May 28, 2008 at 7:39 am

    #821177

  • RE: Function execution

    thisisfutile (5/21/2008)

    If you force a square peg into a round hole, you will shave the corners...

    I have to admit, I didn't read all the posts

    ...but, some seem to be implying...

    May 21, 2008 at 8:32 am

    #818602

Viewing 15 posts - 931 through 945 (of 1,187 total)