Viewing 15 posts - 5,266 through 5,280 (of 59,068 total)
None of this will ever pass an audit if this is in a prod or even a test system. Good luck!
May 5, 2021 at 3:58 pm
@jeff Moden
No I don't have this column in my table, just a datetime column for the date and time of an added row
Ok... that's kind of the same...
May 5, 2021 at 3:55 pm
Ok... so with that diagram, ask yourself what happens when you want to buy two plane tickets and a half dozen train tickets in a single payment transaction. 😉
May 4, 2021 at 10:05 pm
Hi friends,
I’d like to have your help. I have a SQL Server database, and a table dbo.OnData on it. I would like to receive an email alert from...
May 4, 2021 at 3:45 pm
Let's hope they have such a temporal column available on the table and that it defaults to the current date and time on insert.
May 4, 2021 at 3:42 pm
IMHO, if this is on a production box, you've given the Developers way too many privs to begin with. Who is doing the QA/UAT on the reports before they're "officially"...
May 4, 2021 at 3:26 pm
Hi All please disregard issue has been solved.
Mods is there anyway i can delete my own posts?
It would be real nice and friendly of you to post what...
May 4, 2021 at 2:27 pm
Make it easy on yourself... add a trigger to the table to count "what's happening" to the table and capture it in a "what happened at what time" history table. ...
May 3, 2021 at 7:47 pm
Agreed. And I'd make sure that I didn't use the Payments table as an Invoice table like what currently appears to be happening.
To be honest, this has been done in...
May 3, 2021 at 12:52 pm
To add to what Grant stated about statistics above...
We're one of "those" shops where folks seem to have seriously embraced IDENTITY columns for everything. That means the Clustered Indexes are...
May 3, 2021 at 12:45 pm
To be sure, I'm not talking about Bob Martin himself any more than I'm talking about Knuth himself. They are both are spot on.
No... I'm talking about the lot of...
May 2, 2021 at 10:00 pm
Is there a way of knowing Indexes:
One of the best tools for that question and a whole lot of questions that follow that can be found at the...
May 2, 2021 at 8:26 pm
Where possible use the techniques from Bob Martin's clean code so code comments can be kept to a minimum
It's unfortunate that people interpret his book/witings as that. It's kind...
May 2, 2021 at 8:12 pm
@jeff-moden LOL. I did get an email ack:
@gbritton1 : Thanks for your contribution! The author(s) have been notified to review your proposed change.
(It's Gerald btw)
Oh my. My apologies, Gerald. ...
April 30, 2021 at 11:39 pm
Sorry - I don't follow...how are you passing results of one job step to another job step when using xp_CmdShell?
That's just it... I'm not. 😀 I don't need...
April 30, 2021 at 5:20 pm
Viewing 15 posts - 5,266 through 5,280 (of 59,068 total)