Viewing 15 posts - 2,041 through 2,055 (of 3,678 total)
If I am a fan of a tool then I have no qualms about pushing that tool regardless of who produces it.
There will always be people who complain about a...
September 14, 2009 at 4:01 am
The advantages of partitioning where only one filegroup is used is in the simplicity of splitting, merging and switching partitions to achieve a rapid delete of a large volume of...
September 10, 2009 at 4:11 pm
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
Viewing 15 posts - 2,041 through 2,055 (of 3,678 total)