Viewing 15 posts - 1,981 through 1,995 (of 3,616 total)
I've seen that this article is going to be published again in the 3rd week in September 2009. A great deal has changed in the 18 months since I...
August 28, 2009 at 6:34 am
It depends on the personality of the person you are speaking to.
Some managers view any resistence as dissent to be crushed. A carefully phrased question can start a productive...
August 10, 2009 at 9:09 am
It isn't as complex as it looks. The complexity is in having to rename directories as a result of the timestamp facility but Red-Gate have that down as a...
August 10, 2009 at 8:58 am
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
Viewing 15 posts - 1,981 through 1,995 (of 3,616 total)