Are the posted questions getting worse?

  • Jeff Moden

    SSC Guru

    Points: 997215

    Luis Cazares wrote:

    Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me?

     

    I'm working on a code that has scalar functions inside scalar function inside scalar functions and I'm not sure if I'll get to the bottom of this. The worst part will be testing.

    Normally for me, it requires either a good scotch or Drambuie and ice cream. 😀  The cool part about such finds is that they continue to justify my existence in the company not to mention good fodder for presentations.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 721105

    ZZartin wrote:

    Luis Cazares wrote:

    Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me?

    I encountered this code to date stamp a file, fortunately I didn't have to fix it just replace it.

    for /F "tokens=2,3,4 delims=/ " %%i in ('date/t') do set y=%%k
    for /F "tokens=2,3,4 delims=/ " %%i in ('date/t') do set d=%%k%%i%%j
    for /F "tokens=5-8 delims=:. " %%i in ('echo.^| time ^| find "current" ') do set t=%%i%%j
    set t=%t%_
    if "%t:~3,1%"=="_" set t=0%t%
    set t=%t:~0,4%
    set "theFilename=%d%_%1%.txt"
    echo %theFilename%

     

    Now that's interesting

  • Thom A

    SSC Guru

    Points: 98760

    Luis Cazares wrote:

    Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me? I'm working on a code that has scalar functions inside scalar function inside scalar functions and I'm not sure if I'll get to the bottom of this. The worst part will be testing.

    Sounds like the Avaya database we have at the office, which has SP's that call SP's that call SPs, all with (normally scalar) functions that call further functions. Just to add to it, it even has a delimited string splitter than uses a WHILE loop! I don't think any amount of alcohol or coffee will help with the disaster it is.

    I really hope Avaya don''t still make their databases like that (as we're still using their software from 2009 at the moment).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Ed Wagner

    SSC Guru

    Points: 286987

    ZZartin wrote:

    Luis Cazares wrote:

    Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me?

    I encountered this code to date stamp a file, fortunately I didn't have to fix it just replace it.

    for /F "tokens=2,3,4 delims=/ " %%i in ('date/t') do set y=%%k
    for /F "tokens=2,3,4 delims=/ " %%i in ('date/t') do set d=%%k%%i%%j
    for /F "tokens=5-8 delims=:. " %%i in ('echo.^| time ^| find "current" ') do set t=%%i%%j
    set t=%t%_
    if "%t:~3,1%"=="_" set t=0%t%
    set t=%t:~0,4%
    set "theFilename=%d%_%1%.txt"
    echo %theFilename%

    Heh - that looks familiar.  Here's a snip of one of my batch files:

    :GetDate yy mm dd
    ::-----------------------------------------------------------------------------------
    ::returns the date components in the format yyyy, mm, dd
    setlocal ENABLEEXTENSIONS
    set t=2&if "%date%z" LSS "A" set t=1
    for /f "skip=1 tokens=2-4 delims=(-)" %%a in ('echo/^|date') do (
    for /f "tokens=%t%-4 delims=.-/ " %%d in ('date/t') do (
    set %%a=%%d&set %%b=%%e&set %%c=%%f))
    endlocal&set %1=%yy%&set %2=%mm%&set %3=%dd%&goto :EOF
    ::-----------------------------------------------------------------------------------

    All I do is call it, passing 3 variables that'll be returned with the year, month and day. It's not technically a function, but it's close. 🙂

    I have another one for setting the time.

    • This reply was modified 1 year, 5 months ago by  Ed Wagner.
    • This reply was modified 1 year, 5 months ago by  Ed Wagner.
  • TomThomson

    SSC Guru

    Points: 104773

    Thom A wrote:

    You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen. One would hope that they at least have awareness of the print screen key. ??

    Maybe they're just stuck with systems such as the Samsung NP550P7C which don't have a print screen key.   Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    Tom

  • Luis Cazares

    SSC Guru

    Points: 183639

    TomThomson wrote:

    Thom A wrote:

    You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen. One would hope that they at least have awareness of the print screen key. ??

    Maybe they're just stuck with systems such as the Samsung NP550P7C which don't have a print screen key.   Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    I do check them. I've found out that the "Ñ" key is actually a luxury on this side of the Atlantic.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Ed Wagner

    SSC Guru

    Points: 286987

    TomThomson wrote:

    Thom A wrote:

    You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen. One would hope that they at least have awareness of the print screen key. ??

    Maybe they're just stuck with systems such as the Samsung NP550P7C which don't have a print screen key.   Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    They must also be pre-Windows 7.  I believe that's when the snipping tool was first included in the OS.  It's a good chance that it's simply a PEBKAC error.

  • Ed Wagner

    SSC Guru

    Points: 286987

    Luis Cazares wrote:

    TomThomson wrote:

    Thom A wrote:

    You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen. One would hope that they at least have awareness of the print screen key. ??

    Maybe they're just stuck with systems such as the Samsung NP550P7C which don't have a print screen key.   Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    I do check them. I've found out that the "Ñ" key is actually a luxury on this side of the Atlantic.

    So do I.  I know it sounds trivial, but I like the back-lit keyboard that I can turn on and off; it's nice when working in low light.

    I also want a numeric keypad and I don't want the keys right on top of one another.  If the keyboard is too small to have normal-sized keys or a numeric keypad, then it's too small for me to use.  I don't even look at one if it's less than 17".  Then there's the power and internals, but I'm sure we all look at that.

  • Thom A

    SSC Guru

    Points: 98760

    Ed Wagner wrote:

    They must also be pre-Windows 7. I believe that's when the snipping tool was first included in the OS.

    I hope not, anyone me older than Windows 7 is well out of support now. Although I know many of us still have to suffer unsupported versions of SQL Server (I'm glad that we got our 2008 switched off last month).

    TomThomson wrote:

    Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    Most definitely. I'm not a fan of Tenkeyless keyboards at all, so when buying a laptop I made sure it had a full size keyboard. As for the keyboard I use on my work/home PC, they're the same model for both. Made sure they were both UK QWERTY (as there's a lot of good models that have limited availability or some switches are only available in US QWERTY), and again made sure they were full keyboard size.

    For those of us that spend a lot of our time typing, choosing the right keyboard is really important. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • TomThomson

    SSC Guru

    Points: 104773

    Luis Cazares wrote:

    TomThomson wrote:

    Maybe they're just stuck with systems such as the Samsung NP550P7C which don't have a print screen key.   Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    I do check them. I've found out that the "Ñ" key is actually a luxury on this side of the Atlantic.

    I gave up all hope of ever having a complete keyset a long time ago, because I am typing stuff in (Modern)English, Irish Gaelic, Scottish Gaelic, French, Spanish, Italian, Middle English, and German and that means that instead of just 52 alphabetic characters (26 lower case and 26 upper case) needed for English I have to work with another 66 vowels and 17 consonants (9 lower case, and 8 upper case) plus of course 35 Modern English punctuation marks and  5 other punctuation marks.   So I have to work around a keyboard which doesn't offer all that, and use character macros and have a page with all the difficult characters on it so that I can copy and paste if I don't remember the macro for some character.

    And of course on top of that stuff I still occassionally write about mathematics and in particular set theory and logic and that tends to require quite a few Greek and Hebrew characters.

    • This reply was modified 1 year, 5 months ago by  TomThomson.
    • This reply was modified 1 year, 5 months ago by  TomThomson.

    Tom

  • Grant Fritchey

    SSC Guru

    Points: 396716

    Luis Cazares wrote:

    Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me? I'm working on a code that has scalar functions inside scalar function inside scalar functions and I'm not sure if I'll get to the bottom of this. The worst part will be testing.

    That doesn't sound like a job for wine. That's a job for scotch.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Thomas Rushton

    SSC-Insane

    Points: 22648

    TomThomson wrote:

    Thom A wrote:

    You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen. One would hope that they at least have awareness of the print screen key. ??

    Maybe they're just stuck with systems such as the Samsung NP550P7C which don't have a print screen key.   Do you check the keyboard layout before chosing a PC/Laptop/Tablet?

    Yes.  I like to have a separate numeric keypad.  It makes using Sibelius a lot easier.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • Brandie Tarvin

    SSC Guru

    Points: 172760

    Yesterday night, a job failed with a weird error I'd never seen before. I hop onto Google this morning to search for it and find all sorts of interesting responses. Including this little gem:

    Change your query to SCHEMA.dbo.TableName

    Because … reasons.

    <headdesk>

    This thread is from 3 years ago and no one called out that comment or bothered to down vote it. Even a comment posted to that comment said "and how exactly will this help?" as if the respondent to the erroneous comment also failed to notice the problem.

    This makes me very very very sad.

     

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin

    SSC Guru

    Points: 172760

    Annnnnddddd...

    Because I just realized y'all are going to ask.

    https://stackoverflow.com/questions/35951765/the-metadata-could-not-be-determined-because-every-code-path-results-in-an-error

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Luis Cazares

    SSC Guru

    Points: 183639

    Brandie Tarvin wrote:

    Yesterday night, a job failed with a weird error I'd never seen before. I hop onto Google this morning to search for it and find all sorts of interesting responses. Including this little gem:

    Change your query to SCHEMA.dbo.TableName

    Because … reasons. <headdesk> This thread is from 3 years ago and no one called out that comment or bothered to down vote it. Even a comment posted to that comment said "and how exactly will this help?" as if the respondent to the erroneous comment also failed to notice the problem. This makes me very very very sad.  

    It's obvious that if you change to a different database, everything will work as expected. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 15 posts - 63,451 through 63,465 (of 65,179 total)

You must be logged in to reply to this topic. Login to reply