Viewing 15 posts - 26,671 through 26,685 (of 59,102 total)
Brandie Tarvin (6/7/2013)
...users can always find a way to mess with our data no matter how dummy-proof we make it.
Idiot's Razor: "If you make something idiot proof, only idiots will...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 12:52 pm
Brandie Tarvin (6/7/2013)
Co-worker points out problems with future process.
Boss responds: "Don't bring reality into this..."
And yes, he was joking. It was a commentary on...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 12:43 pm
plivingstone (6/10/2013)
it would be Tuesday
An example from last month:
May 27th was Bank Hoiliday Monday, so if the [Date] columns shows any date after 22nd May then it cannot be deleted.
So...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 12:41 pm
David.Poole (6/10/2013)
Post-It notes for defects are good as well though for some reason I've started to have nightmares about Sesame Street.
Heh... and "Agile Scrums". 🙂 "Big Bird" attends both.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 12:34 pm
opc.three (6/10/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 12:32 pm
And I'll encourage anyone and everyone to turn it on and leave it on because having it on isn't a security problem. Only those that can use it can...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 8:11 am
plivingstone (6/10/2013)
StackOverFlow: calculate 3 working days before in stored proc using Holidays lookup table
It's a funny thing that people think that recalculating the same thing over and over is the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 8:05 am
EdVassie (6/10/2013)
Back in the late 1990's a number DB2 shops stopped taking full backups...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 7:43 am
Compassionate (6/9/2013)
1) LDF - 1024KB
2) MDF - 154MB
3) Recovery modle - simple
Now I have 83GB space to restore...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2013 at 9:09 pm
opc.three (6/9/2013)
Note that xp_dirtree is an undocumented stored procedure.
I absolutely agree. It would be much better to use something that's not only well documented, but tried and true, as...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2013 at 9:02 pm
Compassionate (6/9/2013)
I have two data servers S1 and S2. I have a database D1. D1 exists in both S1 and S2. S2 is a prod database and we have to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2013 at 11:05 am
micheltomes (6/8/2013)
I think my friend , gave you right script. So not need to give more details. Please check the code and use it. I think will some all problem.
Spam...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 8, 2013 at 11:26 pm
Steven Willis (6/7/2013)
Jeff, keep it up!
I've learned more from your articles and posts here and elsewhere just in the last year or so than in the previous decade....
--Jeff Moden
Change is inevitable... Change for the better is not.
June 8, 2013 at 8:51 am
nil.hajare (6/7/2013)
Thanks,I am new on sql server. Any suggestions would be helpful for me to rewrite this trigger.
Could you please help me on this?
Yes. Before you take anyone's word...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 7, 2013 at 4:45 pm
Lowell (6/7/2013)
the only thing i could not determine was the primary key that woudl related the INSERTED to the DELETED ; your example...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 7, 2013 at 4:44 pm
Viewing 15 posts - 26,671 through 26,685 (of 59,102 total)