Forum Replies Created

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

  • RE: What Do We Need in SQL Server?

    david_wendelken (9/22/2010)


    Products get better by improving on their strengths and adding better ideas from whatever source. That other source is often competing products. So don't get your knickers...

  • RE: Software Vendor Security

    Is this the same FootPrints that is used for tracking trouble tickets?

    Yep, that's the one. It's an OK app from the users perspective (I guess) but deserves all the...

  • RE: Software Vendor Security

    Two thumbs up. We have an application (FootPrints) that we wont consolidate onto our primary SQL cluster because they insist on using the SA account for their database interaction....

  • RE: The Schema Debate

    I’ll pile on to the “favor schemas” with:

    •Organization- I have multiple departments (marketing, accounting, hr) / applications (crm, rpt.) that I support. Being able to group them in a...

  • RE: I am not a Schema

    I use schemas to make separate logical divisions within a database to partition off common functionality. I’ll also create a file group to hold data for some schemas. ...

  • RE: Essential Software

    Steve-3_5_7_9 (4/9/2010)


    SQLCompare

    SQLDataCompare

    Ultraedit

    SSMS

    SQLServerProfiler

    Yes to those, PowerShell and and a few utilities I wrote myself.

  • RE: Sharepoint Growth is Good

    Like Steve, it gives our organization one more DBA opportunity so, it's not all bad. I haven't drunk the kool-aid on this product but I do see potential. ...

  • RE: Don't Build a Monitoring System

    Sounds like a good plan. Do a tool comparison but don't select a "winner" because that's a matter of preference. Then drill in with a how to on...

  • RE: BCP Format File Builder

    Thanks for the kind words. I'm in the process of building a utility that will read the file and do a sample "load" based on the format file. I...

  • RE: BCP Format File Builder

    Looks like I need to re-read my comments and use spell check before I post to the SQL Server Central. 🙂

  • RE: BNF Basics

    Nice treatment of an unfamiliar topic. I had figured out most of what the syntax/convention was before reading this but didn't know it had a name and defined rules.

    <opinion...

  • RE: GetDateTimeString Function

    DCDBA (7/31/2009)


    How about this:

    CREATE FUNCTION dbo.fGetDateTimeString

    (

    @dt datetime

    )

    RETURNS varchar(12)

    AS

    BEGIN

    RETURN Convert(varchar(8), @dt, 112) + Replace(Convert(varchar(5), @dt, 114), ':', '')

    END

    DCDBA is the winner.

    I...

  • RE: Drive space checking monitoring procedure

    I liked the code sample. I cleand it up by removing unused/unneeded variables, unneeded columns and tightend up on the error and loopin logic. Hope you approve of...

  • RE: Four Rules for NULLs

    Maybe I went blind last night while typing in the code..... nope, no blindness. Bear, where did you see the cursor? I looked under every letter and couldn't...

  • RE: Four Rules for NULLs

    hmmm... the solution provided by "bear in a box" looks very Oracle-ish. I believe MS & Oracle spend HOURS trying to figure out how to make their competitors code...

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