Forum Replies Created

Viewing 15 posts - 5,401 through 5,415 (of 5,685 total)

  • RE: New User, just wanted to say hi

    Hey Eric, nice to meetcha.

    *tosses you a pair of well worn keys* Those are to the liquor cabinet in the corner.

    Nice link, btw. Gave me a good...

    October 4, 2010 at 2:06 pm

    #1231263

  • RE: Women and Men - Same or Different?

    wendyp (10/4/2010)

    Craig, I completely agree that there has been a great outpouring of comments about the subject. Sorry it sounds like you wasted your time reading my commentary. I...

    October 4, 2010 at 1:58 pm

    #1231258

  • RE: Audit database usage

    dant12 (10/4/2010)

    @craig-2

    Our application database is usually managed by us.

    This new client doesn't want us managing the database and we don't want him running any selects around. It is being put...

    October 4, 2010 at 1:46 pm

    #1231251

  • RE: Audit database usage

    dant12 (10/4/2010)

    Unfortunately, I can't start a trace through the SPs to save the trace on table. And I can't leave profiler running. It has to be background and as invisible...

    October 4, 2010 at 1:11 pm

    #1231221

  • RE: Audit database usage

    dant12 (10/4/2010)

    What would be the easiest way to audit usage of a single database by a specific user, without creating a server-wide trigger?

    Assume sql server 2008 enterprise

    Easiest? Run a...

    October 4, 2010 at 12:52 pm

    #1231206

  • RE: Women and Men - Same or Different?

    cmcc (10/4/2010)

    Back to the topic:

    Women aren't complaining about the inequality in pay/work, we just know it's out there. I don't actually want to know what my colleagues make. I don't...

    October 4, 2010 at 12:41 pm

    #1231196

  • RE: DBCC Checkdb on instance startup

    Edited: Removed inquiry, and stepping aside. I didn't read the logs.

    October 4, 2010 at 12:00 pm

    #1231173

  • RE: Women and Men - Same or Different?

    Grant Fritchey (10/4/2010)

    I tried negotiating a job offer. I told them what my base would have to be. They didn't meet it. Then they were shocked as hell when I...

    October 4, 2010 at 11:48 am

    #1231169

  • RE: Can Wives Shorten Work Hours?

    WayneS (10/2/2010)

    Craig Farrell (9/29/2010)

    ... I've gotten a list of questions that I always ask the employer. One of the top 3 is "What's your average employee's work schedule like,...

    October 4, 2010 at 11:24 am

    #1231152

  • RE: Are the posted questions getting worse?

    Stolen from the front page:

    Top Members (last 30 days) # Name Score Level

    30 days All-time

    1. Saru V 1127 1149 Ten Centuries

    2. bslchennai 1083 1083...

    October 1, 2010 at 5:40 pm

    #1230628

  • RE: Are the posted questions getting worse?

    GilaMonster (10/1/2010)

    Craig Farrell (10/1/2010)

    ... only 4:12 PM here. 🙂

    Shouldn't you be in the pub then? Maybe it's an African thing (I doubt), but friday post 4pm here just about no...

    October 1, 2010 at 5:36 pm

    #1230626

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/1/2010)

    Craig Farrell (10/1/2010)

    GilaMonster (10/1/2010)

    Ow! My mail! And on a friday night too. Get away from thy computers and go do something normal for a friday night! (and before anyone...

    October 1, 2010 at 5:35 pm

    #1230625

  • RE: Are the posted questions getting worse?

    GilaMonster (10/1/2010)

    Ow! My mail! And on a friday night too. Get away from thy computers and go do something normal for a friday night! (and before anyone complains, I've been...

    October 1, 2010 at 5:13 pm

    #1230620

  • RE: Join VS IN VS Exists

    GilaMonster (10/1/2010)

    The join is faster because that CASE expression is not SARGable. Not sure why you have the CASE there in the first place.

    This may be of interest: http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/

    :ermm:...

    October 1, 2010 at 5:08 pm

    #1230619

  • RE: SELECT from a table that refers to itself?

    Nope, can do it in 2k5 and 2k8 with a recursive CTE definition.

    If you'd like a sample of how to build it, check out the first link in my sig...

    October 1, 2010 at 4:43 pm

    #1230613

Viewing 15 posts - 5,401 through 5,415 (of 5,685 total)