Forum Replies Created

Viewing 15 posts - 5,386 through 5,400 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 3:44 pm

    #1231341

  • RE: Are the posted questions getting worse?

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 3:39 pm

    #1231333

  • RE: Disk Defrag

    Jon.Morisi (10/4/2010)

    Hi,

    I've been operating with the preference to take SQL server offline when defragmenting the disks in which SQL Server datafiles or logfiles reside on in order to avoid possible...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 3:36 pm

    #1231328

  • RE: Are the posted questions getting worse?

    GilaMonster (10/4/2010)

    For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx

    There are days I just don't want to know...

    I'm apparently rather grumpy today. I had started writing a parody of how to hack...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 3:34 pm

    #1231325

  • RE: Audit database usage

    Dant...

    Dynamic SQL isn't just what's pumped in from a website. It's what's typed into SSMS, ran from a job and not proc called, etc. EXEC sp_yay @blah is...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 3:04 pm

    #1231306

  • RE: Converting Daily OHLCV data into weekly and monthly OHLCV

    Digs (10/4/2010)

    Jeff I get an Error when I run your code

    FROM dbo.Tally t

    INVALID OBJECT !

    Assuming Jeff is busy at the moment, check my signature for the dbo.Tally. You'll want...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 2:43 pm

    #1231290

  • RE: How would you create this stored procedure

    blacklabellover2003 (10/4/2010)

    Well, the consensus is that the final check isn't necessary, my remainings concern are error-handling, emailing that rowcount automatically, and possibly lifting the phone numbers using OpenRowset.

    But otherwise, you...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 2:30 pm

    #1231281

  • RE: Women and Men - Same or Different?

    jay holovacs (10/4/2010)

    Craig Farrell (10/4/2010)

    I would counter, however, there are women who do that. At the same time, these women, by their own gender(!) are called 'butch', 'alphagirl', ......

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 2:26 pm

    #1231277

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    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.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    October 4, 2010 at 12:00 pm

    #1231173

Viewing 15 posts - 5,386 through 5,400 (of 5,678 total)