Viewing 15 posts - 2,011 through 2,025 (of 3,658 total)
create PROCEDURE [dbo].[usp_Dynamic]
@location_id int = NULL
...
November 11, 2009 at 2:32 pm
David, can you elaborate on this?
The other things that strike me is that the "text in row" option may apply and also the maximum replicated text size (defaults to 64Kb).
sp_tableoption...
October 24, 2009 at 9:31 am
Personally I believe that VARCHAR(MAX) is a datatype of last resort.
To give an extreme example the longest possible telephone number is 15 digits so allowing for formatting I allow VARCHAR(20)....
October 23, 2009 at 6:33 am
If you have one publisher then multiple distribution databases won't do you any good because a publisher is associated with one distributor.
MySQL is great for one master, multiple slaves.:hehe:
We did...
October 22, 2009 at 7:42 am
Was it described as software that could query mixed datasources in situ?
To me it sounds like some form of ETL system that can merge data from several systems into a...
October 8, 2009 at 1:46 pm
My first exposure to agile lead me to think of it as the bodge it and wing it methodology. It fundamentally isn't. It isn't even a methodology, it...
September 22, 2009 at 1:24 pm
The thing that impresses me most about MySQL are the MySQL tech staff. These are a bunch of guys I consider myself privileged to have worked with.
The trainers were...
September 19, 2009 at 5:14 am
I would be surprised if it was the FKs that made the difference. I suspect it was the clustered keys primary or otherwise.
I have run into this problem on...
September 19, 2009 at 4:23 am
I've just been reading "The Mythical Man Month" by Fred Brooks. Some people think his book is brilliant other people deride it with comments such as "it taught me...
September 19, 2009 at 4:15 am
For me the most important thing about "agile" is that it emphasise communication and that the best communication is face to face.
Short itterations mean that developers and business people get...
September 18, 2009 at 12:26 pm
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
Viewing 15 posts - 2,011 through 2,025 (of 3,658 total)