Viewing 15 posts - 76 through 90 (of 137 total)
Steve, if anyone does share with you their big cloud operations please beg for permission to share the gist of it with us.
One application that comes to mind for $2m/day...
August 2, 2012 at 7:19 am
GSquared (7/25/2012)
July 25, 2012 at 7:46 pm
It seems everyone is agreed that it's a flawed system. Considering the audience here is comprised of DBA and developers, I'm surprised there haven't been more improved-system suggestions. ...
July 20, 2012 at 8:38 am
Jeff Moden (7/13/2012)
Mike Dougherty-384281 (7/13/2012)
Ola L Martins-329921 (7/13/2012)
...hence I never delete a-n-y-t-h-i-n-g from the tables. I use a switch "bit_deleted" and a view to get the not-deleted records...
consider a deleted...
July 14, 2012 at 10:22 am
Ola L Martins-329921 (7/13/2012)
...hence I never delete a-n-y-t-h-i-n-g from the tables. I use a switch "bit_deleted" and a view to get the not-deleted records...
consider a deleted [small]datetime: null indicates not...
July 13, 2012 at 3:00 pm
Another reason to accept being proven wrong is that it shows someone else is aware enough to see/understand your mistake. As long as they've "got your back" you can...
July 11, 2012 at 2:17 pm
Jeff Moden (6/24/2012)
June 25, 2012 at 11:28 am
richard.noordam (6/20/2012)
Mike Dougherty-384281 (6/20/2012)
I would not want to be the person to inherit your role.
Really? you wouldn't want to open up a Sharepoint WorkGroup site with it...
June 20, 2012 at 12:02 pm
If the job fails to schedule its next occurrence then the job never runs again? So for quarterly jobs, you won't find out about the failure for at least...
June 20, 2012 at 7:36 am
http://www.crockford.com/ec/dining.html
While not specifically about database, it's a good story about concurrency and security. It gives the reader a nice introduction into a capability-based access methodology. I...
June 13, 2012 at 8:10 am
Can someone explain to me what purpose is served by ignoring duplicate keys?
In an ideal world there would be data uniquely related to the key in such a...
June 8, 2012 at 11:16 am
mtassin (5/22/2012)
May 23, 2012 at 7:50 am
Hugo Kornelis (5/23/2012)
I guess that depends on the expectation. The code in this QotD contains no error-handling and an unconditional COMMIT statement.
My expectation is that those two conditions never exist...
May 23, 2012 at 7:29 am
Use-case?
Part of what makes SQLServerCentral articles interesting to read is the story that explains the code. What prompted you to write these functions?
Even if this solution "works" - what...
May 22, 2012 at 8:05 am
Why do we want a database that can be accessed without a login?
Between functional/role-based logins for applications and trusted machines, I can't think of a reason for this other than...
May 22, 2012 at 7:59 am
Viewing 15 posts - 76 through 90 (of 137 total)