Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 3,543 total)

  • RE: Organizations With No DBAs

    p.s. I also want to say that when I say "developers", I'm talking about the greater populous... there are some individual developers that I'm NOT including in my rant,...

  • RE: Single Page Restore

    OK, the author (me), can't type

    Well at least they did not flame you about the actual question 😉

  • RE: SQL Bulk Insert - using " to wrap text fields

    Change the terminator on the last line to

    "\"\r\n"

    If your data contains the header row you will need

    FIRSTROW=2

    to ignore it

    If you wish to keep the header then note that DATE_ORD is...

  • RE: SQL Bulk Insert - using " to wrap text fields

    btw Jeff, I have tried your params and it worked :w00t:

    Don't know why it did not before, but then it was a while ago, maybe I was too green then...

  • RE: SQL Bulk Insert - using " to wrap text fields

    Also, know your data. As long as the data is structured and delimited properly then many problems can be avoided. This sort of problem is normally caused by the...

  • RE: Congratulations to Our New MVPs

    what I'd really like to do is raise a glass at the bar!

    Yeah, you do that, you deserve it :rolleyes:

    And a tip for you....

    When you get there lower the bar.........

  • RE: Congratulations to Our New MVPs

    Outstanding! 😀

    You've raised the bar again Jeff 😎

    Gosh it must be dizzy at those heights :hehe:

  • RE: CLR Assemblies

    Greetings!! 😀

    are you going to make the trek to Pass

    Unfortunately not :crying:

    Wish I could 🙂

    Just cannot seem to get the company to splash out the funds...

  • RE: CLR Assemblies

    "If you don't write the bloody things, you don't have to worry about stuff like this!"

    ever the cynic eh Jeff 😎

  • RE: Text Column Updates

    Just to get me point 😀

  • RE: Is a Temporary Table Really Necessary?

    Control disk space and where it is used

    Reduce interference from other apps/databases ie locks

    Minimise effect of rogue apps/databases filling tempdb

    I did state ir was off the cuff.... didn't say it...

  • RE: Is a Temporary Table Really Necessary?

    :ermm: Out of the blue... off the cuff remark...

    Wouldn't it be nice to create a temp table and be able to specify the database in which is created 😀

  • RE: Finding Available Keys When Merging Two Tables

    Good approach, I think... my question would be, how do you find and change all the references to such a table?

    Trust you to think of that one :rolleyes:

    Now THAT...

  • RE: Moving Databases

    Nice article Andy.

    re:

    First, you need to know how to move logins. I won't go into details here, but read this MS article on how to move your logins

    I have...

  • RE: Writing

    Actually, the real reason why I write is because...

    I can't remember stuff no mo'.

    And you are ? :blink:

    lol only kidding Jeff 😉

    Keep think about submitting something but can't think...

Viewing 15 posts - 1,441 through 1,455 (of 3,543 total)