Viewing 15 posts - 16 through 30 (of 89 total)
Eric M Russell (6/14/2016)
June 15, 2016 at 3:14 am
If two users are changing the same text simultaneously and the stored procedure does not produce an error in that case, one update will be lost without further notice to...
June 14, 2016 at 5:42 am
Well, heaps do have a slight advantage in certain cases. Because SQL Server (unlike other SQL systems) had a provision for identity columns from day one, it has been a...
May 24, 2016 at 2:11 am
On the other hand, if setting up security requires more effort than necessary, some administrators might choose an easy way out by simply granting permission to (nearly) everyone. Even with...
January 15, 2016 at 3:39 am
I would definitely opt for the positive way, if I had not been hunting down database defaults overwritten by ORM-defaults on insert. Great if you define an Active or IsActive...
October 23, 2015 at 8:26 am
@[Phil Factor]
You are absolutely right as long as reports will be assembled by skilled people using their own naming convention rules. However I've learned over the years that this is...
October 5, 2015 at 3:44 am
As much as I do agree with all the arguments against using SELECT * I still think that your developer does not have to change this bad habit until it...
June 17, 2015 at 4:29 am
Sometimes queries do benefit from covering indexes. Below are the covering indexes I would suggest in this case. I used the prefix CIX to denote that these are ment as...
April 16, 2015 at 8:40 am
Working both as DBA and as .NET developer I can see the added value of NOSQL (not only SQL) solutions during the rapid development of new solutions. Reports are generally...
April 13, 2015 at 9:46 am
Eirikur Eiriksson (3/17/2015)
ScottPletcher (3/16/2015)
CELKO (3/12/2015)
Since BIGINT is larger than the number of atoms in the universe, we do not use it very often.
No, not even close. There are...
March 18, 2015 at 5:03 pm
I usualy do not reply with a link but in this case the information is too much and too complex to repeat it right here,
You can find relevant information about...
March 18, 2015 at 4:48 pm
Trying to solve problems with the knowledge at hand undoubtedly has some benefits. At least one person on your site will have hands-on experience with it because he or she...
March 15, 2015 at 7:17 am
ZA_Crafty (12/11/2014)
So certainly, if you look on the flip side of your...
December 11, 2014 at 6:01 am
astone-1154729 (8/19/2014)
It's not the artistic nature of people that leads to poor application development. It's just simple ignorance or lack of experience, maybe indifference.
For most forms of art, even...
August 19, 2014 at 8:04 am
In my humble opinion the behavior you expect is more like an engineer than a scientist. The latter might be involved in some innovative research project or the exploration of...
August 19, 2014 at 5:54 am
Viewing 15 posts - 16 through 30 (of 89 total)