Viewing 15 posts - 2,026 through 2,040 (of 3,658 total)
I didn't include UNION because I could not think of an alternative to the UNION statement that didn't involve creating temporary tables.
INTERSECT and EXCEPT can be modelled with joins and...
July 21, 2009 at 7:46 am
In the graphical execution plan if you move the mouse pointer over the left hand graphic the costs are revealled.
July 21, 2009 at 5:25 am
The problem with a compound key where one of the fields is a ServerId is when you are running a disaster recovery site.
You have to remember NOT to synchronise the...
July 16, 2009 at 3:30 pm
True Paul but the trick is to work out if you actually need those features and if not, why pay for them.
You wouldn't try and run your entire operation on...
July 16, 2009 at 3:24 pm
Nice but I would use a table variable for this rather than a temporary table.
July 15, 2009 at 9:57 am
If you have separate databases then you can move them around to suit your needs.
In a virtual environment you can tailor the virtual server to the needs of the database.
If...
July 15, 2009 at 9:41 am
Gaby A. (7/15/2009)
What's wrong with a bigint identity(1, 1).
Nothing provided you are running on a single server. The instant you go multi-site or employ a sharding strategy all sorts...
July 15, 2009 at 9:34 am
I would only use guids where they are necessary and never in a clustered index.
As already pointed out GUIDs are not as unique as they should be though you are...
July 15, 2009 at 9:09 am
mike.mcquillan (7/15/2009)
I'm reminded of something Fred Brooks said in The Mythical Man-Month (which echoes what Steve was saying):
"Plan to throw one away (you will anyway)"
Truer words have never been spoken...
Ah,...
July 15, 2009 at 8:55 am
When I'm running scripts like this I make sure that the failure notices print ****FAILURE as this standard out like a sore thumb when the output is echoed to a...
July 13, 2009 at 2:17 am
You've got it lucky. In my day we used to get asked to fix household appliances, rewire houses and mend video recorders. Thats if we were lucky:hehe:
July 6, 2009 at 1:36 am
I've currently got a big push from developers to allow nHibernate into the databases.
My concerns are security implicit in direct table access and performance.
The "Oh everyone uses it" argument doesn't...
July 2, 2009 at 3:02 pm
We've been evaluating MySQL Vs SQL2008. So far the cheapness of MySQL means that a scaleout architecture is a practical proposition. Performance wise scale-up is not so hot....
July 2, 2009 at 8:11 am
Thanks, you have just confirmed my worst nightmares and I have to say I'm not altogether surprised.
By none functional requirements I meant things like "
a. must support x queries...
June 27, 2009 at 3:32 pm
We have an experienced architect who has worked with agile development for a number of years.
He has some pearls of wisdom
1. It takes 18-24 months for the agile methodologies to...
June 26, 2009 at 2:57 pm
Viewing 15 posts - 2,026 through 2,040 (of 3,658 total)