Viewing 15 posts - 1 through 15 (of 149 total)
Arrgh! Consultants! Get thee behind me! 🙂 Unfortunately the ratio of good outcomes to poor outcomes from bringing in the consultants, in my lengthy experience has been about 1:3. The...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 20, 2020 at 4:23 am
Synonyms are important for dependency management. As Jeff Moden alluded to, sooner or later your friendly infrastructure maven is going to come a-knocking and say "Hey, good news guys, we're...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 7, 2019 at 7:45 pm
frederico_fonseca - Monday, October 30, 2017 2:14 PM...fact of 50 Million rows, 20 dimensions of 500 rows each...
Thanks Frederico. Some good suggestions...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 31, 2017 at 3:24 am
Paulo de Jesus - Wednesday, October 25, 2017 8:34 AMAlthough you'll get better performance...
Thanks Paulo
I was thinking as I wrote this, that...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 25, 2017 at 6:15 pm
@Tom_Hogan Sorry for my lack of clarity Tom. I think I...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 25, 2017 at 6:12 pm
or the DatasSQLDatasSQL mug
"...£10.90 per mug..." Who knew trainee DBAs were on such a good wicket.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 5, 2017 at 12:27 am
Thanks all for your excellent suggestions, I particularly like Eddie...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 8, 2017 at 5:07 pm
...Case Statement Update...
Shouldn't that say "case EXPRESSION update"?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 12, 2016 at 6:04 pm
This and the calendar table articles are great pieces of work for people who aren't yet using their databases to their fullest potential. Forgive me if I'm missing something obvious,...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
September 19, 2016 at 4:32 pm
Serious question from a rather naive non-DBA:
Say your organization is running very complex software and a database licensed from a third-party vendor, and it contains thousands of tables in regular...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 30, 2016 at 8:58 pm
Storing XML is not ideal, to be sure. But a particularly frustrating variant of it is when the structure of the XML being stored turns out to be identical in...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 8, 2016 at 10:17 pm
as long as it's not arbitrarily used to force uniqueness
Hahaha! That's awesome!
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 5, 2016 at 1:52 am
If an application is that badly coded there's little you can do on the database side to fix it.
I would have thought that's one reason why you put constraints in...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 4, 2016 at 8:11 pm
On the other hand if SQL is the system of record they do not and are a very handy tool to use.
We're talking about two different kinds of unique. If...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 4, 2016 at 6:29 pm
there are perfectly valid reasons to do this, for example order numbers
Well... kinda. I don't think I explained myself very well. My apologies. Incrementing integers CAUSE uniqueness. They don't enforce...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 4, 2016 at 5:04 pm
Viewing 15 posts - 1 through 15 (of 149 total)