Viewing 15 posts - 1 through 15 (of 148 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...
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...
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...
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...
October 25, 2017 at 6:15 pm
@Tom_Hogan Sorry for my lack of clarity Tom. I think I...
October 25, 2017 at 6:12 pm
March 5, 2017 at 12:27 am
Thanks all for your excellent suggestions, I particularly like Eddie...
February 8, 2017 at 5:07 pm
...Case Statement Update...
Shouldn't that say "case EXPRESSION update"?
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,...
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...
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...
April 8, 2016 at 10:17 pm
as long as it's not arbitrarily used to force uniqueness
Hahaha! That's awesome!
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...
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...
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...
April 4, 2016 at 5:04 pm
Viewing 15 posts - 1 through 15 (of 148 total)