Forum Replies Created

Viewing 15 posts - 106 through 120 (of 1,239 total)

  • Reply To: Change Log Backup Frequency Automatically

    Thanks Grant.  The next day or so is going to be spent testing things.  I want to make sure I'm not planning something completely stupid before I spend any more...

  • Reply To: Changing Algorithms

    I have to say I think this is a bit naughty.  The usual assumption is that all servers involved in a question are up to date. In this case though,...

  • Reply To: T-SQL Query Help

    rjhare wrote:

    Thanks Neil,

    I assumed this level of disdain, to those less experienced, had disappeared twenty years ago from technical forums - apparently not.

    I will not be asking too many questions...

    • This reply was modified 4 years, 11 months ago by  Neil Burton.
  • Reply To: T-SQL Query Help

    rjhare wrote:

    I'm a little taken aback by the language used to the OP in answers on here, is this the standard?

    Wow...

    Absolutely not.  Mr Celko, while undeniably hugely knowledgeable, seems to...

  • Reply To: Stored Procedure Documentation

    Jeff Moden wrote:

    jonas.gunnarsson 52434 wrote:

    As in most development the code should speak for it self, and you should use:

     

      <li style="list-style-type: none;">
      <li style="list-style-type: none;">

     

      <li style="list-style-type: none;">
      <li style="list-style-type: none;">

    • Source control...
  • Reply To: The 2019 Techie Gifts

    If you're worried about Alexa listening to everything, I can say that it (she?) doesn't listen when I ask to switch the bloody cellar lights on so I'd be surprised...

  • Reply To: SQL Cursor Trouble

    OK, we're getting somewhere now.

    The big question is how to you unambiguously tie folder to folder2.  I can see what you want to do but there's no way to guarantee...

  • Reply To: SQL Cursor Trouble

    Hello and welcome to the forum.

    You almost certainly don't need a cursor for this but to get the best help we'll need a bit from you.  It's much easier to...

  • Reply To: The Derived Table

    This may sound like an extremely basic question but what's the difference between an execution error and a syntax error in this case?  The message that I get suggests that...

  • Reply To: Ending a line with a Backslash

    But why are you copying the code the get the answer in the first place..?

    Trust but verify 🙂  Besides, a true smart-alec would have known that a '\' would be...

  • Reply To: Ending a line with a Backslash

    I copied,  pasted and ran the code as-is and got the wrong answer.

     

  • Reply To: The Costumed DBA

    It'll have to be a cowboy outfit.

  • Reply To: Finding out mismatch between time lines.

    I did have a solution that worked without a calendar table but I spotted a mistake.

    It's probably worth pointing out that there is no 31st of June.

    • This reply was modified 5 years, 1 month ago by  Neil Burton. Reason: Mistake spotted
  • Reply To: Are the posted questions getting worse?

    Thom A wrote:

    BrainDonor wrote:

    SQL Saturday in Edinburgh  - 1st Feb, anybody from here thinking about going?

    Haven't been to Edinburgh since I was about 14, but planning to go there next...

  • Reply To: Are the posted questions getting worse?

    We have a table with one column as UTC and another as local time.  So far this hasn't caused any (major) problems but I'm pretty sure that it will bite...

Viewing 15 posts - 106 through 120 (of 1,239 total)