Viewing 15 posts - 9,016 through 9,030 (of 59,078 total)
What privs the actual owner of the database have?
July 17, 2019 at 4:32 pm
If the poster is using the old Sybase MONEY data types, be sure to tell him to look up the rounding errors in multiplication and division that make this...
July 17, 2019 at 4:27 pm
I agree with Steve... this could turn into a great mentor moment.
July 17, 2019 at 3:34 pm
Ah, apologies. I'd camped out too long on this post and didn't refresh before answering and so missed the fact that Mr. Burrows already posted the correct and for SQL...
July 17, 2019 at 3:31 pm
My take on it is that the nature of data has never changed. It's always been private data and people are just now having their feet held to the fire...
July 17, 2019 at 3:28 pm
Thanks, Thom.
On the subject of whether or not to do this in SQL Server, please see my reply to Joe.
On the subject of what the poster is going to use...
July 17, 2019 at 3:16 pm
I want to separate money values in my tables with (/) character Also separate decimal by (") Character. Example: 2/498/489"25 help me please
I'll make you a deal... tell me...
July 17, 2019 at 1:27 pm
No. SQL is based on a tiered architecture, like all modern programming. We do not format data for display in the database tier. Essentially you're trying to write some...
July 17, 2019 at 1:23 pm
Our vendor recommends 4 LUN with 4 data files.
To what end? WHY does the vendor recommend that?
In almost every case that I've seen, people are splitting databases up...
July 17, 2019 at 12:19 pm
Next, identifiers cannot be numeric because you don't do any math on them.
This continues to be the most horribly stupid thing you've ever said, Joe.
July 16, 2019 at 9:29 pm
I have a suggestion for you Jeff. Your company may bill by the quarter hour, but that doesn't mean that you have to enter your time that way. Tell...
July 16, 2019 at 3:13 pm
I DO agree that we have our own personal experiences to contend with. Ironically, I find that people that don't know how to use date math make some pretty complicated...
July 16, 2019 at 2:11 am
Thanks for the feedback, George. And, yes, I understand that you already handled my objections and, no, I'm not trying to change your convictions. A lot of people could be...
July 16, 2019 at 12:13 am
Not so sure it is as bad as you stated, here is what it shows on my system.
The key here is that you have to make it system agnostic. ...
July 15, 2019 at 11:51 pm
This is a great excuse to write a recursive query 🙂
Heh... no it's not. ( https://www.sqlservercentral.com/articles/hidden-rbar-counting-with-recursive-ctes )
July 15, 2019 at 9:49 pm
Viewing 15 posts - 9,016 through 9,030 (of 59,078 total)