Viewing 15 posts - 136 through 150 (of 607 total)
There's an option to not allow the cell to break, you could use that. Might end up with some strange proportions on the prior/following page, but at least would give...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 25, 2020 at 4:12 pm
First Brexit/Meghxit, now Kentrance/Peshctrance, nicely transactional
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 25, 2020 at 4:00 pm
I tried, but I went blind
If I were going to pick a DBA celebrity to have all the answers, I would pick Kendra. I would ask Steve to be...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 20, 2020 at 5:55 pm
So what have you tried so far, and where are you stuck?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 13, 2020 at 3:02 pm
CTE is like a derived table, so it could, or it could just be a collection of values, like "SELECT 1 as someNum UNION SELECT 2 UNION SELECT 3"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 12, 2020 at 11:38 pm
….aaand now I'm wondering what I've screwed up during my tenure. Thanks Joe!
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 11, 2020 at 10:24 pm
I have never heard of a "tibble", so I googled it. Nothing. Not sure how widespread that term is.
I also tried to google the "problems with old Sybase UPDATE..FROM...WHERE syntax",...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 11, 2020 at 8:54 pm
I don't think that's the issue (not exactly), I think you are telling it to update on the aliased table. Try taking the alias off, just say UPDATE Orders SET...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 10, 2020 at 10:37 pm
...and every report in your system that your team or any other reporting team has built, to see if they are using those NULL columns. Or, as previously mentioned, blow...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 10, 2020 at 10:30 pm
Hahaha, had an upgrade weekend myself. Things went fairly smoothly, other than timing being WAY off from estimated and me validating tables in the back of a bowling alley while...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 10, 2020 at 10:06 pm
Sean, you should look into NABBA, really fun brass band organization that has a national competition each year. I used to coach the trombone section for the youth one in...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 6, 2020 at 4:40 pm
In your definition of 'a' you've included a line with the summed subtotal, did you intend to do that?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 5, 2020 at 3:42 pm
I think the trick is that we're all in the same boat, so stating why you oppose something but knowing that the final decision might be somewhere else is just...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 3, 2020 at 2:34 pm
what everyone else said - plus in some of the teams we have a database per change request being done.
one of our teams has almost always over 100...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 31, 2020 at 7:27 pm
Very interesting editorial, Kendra. You've mentioned a lot that I've never heard of before, such as SQL Provision or other tooling to mask/de-identify production data. I've never worked anywhere,...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 31, 2020 at 4:09 pm
Viewing 15 posts - 136 through 150 (of 607 total)