Viewing 15 posts - 31 through 45 (of 378 total)
I do like to spend time to design better early on and do various tests to confirm i am on the right track.
And doing so by making mini-scripts and specific...
July 23, 2015 at 3:54 am
This article triggers a modeling thoughts in me.
Lets categorize some FK relationships first:
1. Collections such as order-lines in an order, or class members in a class.
Objectively we can say these...
June 30, 2015 at 5:21 am
It might be my memory...
I distinctly remember that in the past any function used in a constraint needed to be deterministic.
Querying a table violates that rule, obviously.
When did this change..or...
May 12, 2015 at 4:57 am
I also entered a PM session with ChrisM and he brought up a related problem that I think I just solved as well :).
If you want to know details,...
April 21, 2015 at 10:36 am
Even with some of the harsh feedback that comes with publishing I feel the need to write at least one article myself.
Certainly I owe many of the previous writers that...
April 21, 2015 at 8:50 am
Set types and scalar types follow different logic and sets are not...
March 31, 2015 at 4:18 am
The forum ate my post due to a parsing error...grrr...not going to type it all again...just this:
Set types and scalar types follow different logic and sets are not null-able, nor...
March 30, 2015 at 8:02 am
Gary Harding (3/26/2015)
Solomon Rutzky (9/4/2014)
Jeff Moden (9/3/2014)
March 26, 2015 at 9:41 am
It seems I disagree with both of you on all points then.
These are my most critical reasons for doing so:
The target audience are the database people, not the code people...
January 20, 2015 at 10:01 am
Solomon Rutzky (1/20/2015)
peter-757102 (1/20/2015)Why does code need to be maintained as .NET assemblies by parties that likely are no stakeholder?
So who would create a library and not be a stakeholder?...
January 20, 2015 at 9:08 am
I agree with the OP.
Why does code need to be maintained as .NET assemblies by parties that likely are no stakeholder?
Why not create a type/class of stored procedure that uses...
January 20, 2015 at 3:28 am
During development writing code is only part of the story.
What I usually do is spend significant extra time in the data modelling phase.
With respect to performance, primarily how the data...
December 30, 2014 at 4:29 am
I suppose we...
December 11, 2014 at 8:20 am
One solution is to add to the particular sensitive query an "optimize for" hint and supply a known value that gives the desired plan.
Or use "optimize for unknown", so...
December 11, 2014 at 7:51 am
Excellent analysis and excellently written article.
December 11, 2014 at 5:31 am