Viewing 15 posts - 7,726 through 7,740 (of 59,072 total)
I think it's funny... way back when a 1GB disk was the "ultimate", people filled them up. Now we have easy access to inexpensive disks that measure in TeraBytes and,...
February 17, 2020 at 2:49 pm
Speaking of automated testing, you should write a followup article about who tests the automated test software? I can't speak for anyone else but we've had the occasional "whoops" occur...
February 17, 2020 at 2:42 pm
NUMERIC(18,0) for an Age column.
Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long time...
February 17, 2020 at 2:32 pm
First, to be sure, I'm not taking a shot at anyone for whatever methodology they use... I'm just talking about what we did in the various places I've worked and...
February 16, 2020 at 4:54 pm
To Frederico's point, here's my entry on the post he provided a link to above...
Just my entry on this post…
When I first laid eyes on the servers at where I...
February 16, 2020 at 2:49 pm
Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead
again...
February 16, 2020 at 12:23 am
Yep... I got that. It's not a problem if you know about it. I just wanted to be sure that people knew about it. Perhaps stripping the time would eliminate...
February 15, 2020 at 4:17 am
Jeff, it sounds like the OP has a permanent table Customers, and Info is a staging table that has updates & corrections.
Understood. The OP said as much in the...
February 15, 2020 at 2:57 am
Just a bit of caution for people reading this... if your DATETIME column only contains whole dates (no times) and you tell it to search for a date with no...
February 15, 2020 at 1:51 am
BTW... You already know this but you didn't write it quite right in the article. To determine the max number of iterations in a binary search, you have to do...
February 15, 2020 at 12:01 am
You can do this with no chance of deadlocks nor even blocking AND the total "offline" time will be measured in milliseconds.
You're replacing the entire table each time. So... create...
February 14, 2020 at 3:49 pm
5 Stars for realizing that you were stuck in a box and then for thinking outside the box. I wonder how many people would have actually thought of using a...
February 14, 2020 at 1:51 pm
I followed the advice Sue had given, I read the document she provided the link to and setup the link server, I can query the as400 tables as I...
February 14, 2020 at 12:38 am
I can recommend a standing desk.
Ummm... ok... why does your desk need exercise? 😀
February 13, 2020 at 10:57 pm
Heh... I can keep up with most folks... it's why I bought a 4 wheel drive truck with a V-8 and cup holders. 😀
February 13, 2020 at 10:56 pm
Viewing 15 posts - 7,726 through 7,740 (of 59,072 total)