Viewing 15 posts - 106 through 120 (of 196 total)
select * from table_name where dateDiff(d,@varDate,Created_Date) =0
It seems to me that this test simply wants to compare an element to a static variable to determine if they match (which is...
February 28, 2008 at 6:16 am
On occasions where I've been snowed in (very different definition, based on the amount of snow, than Steve would have) and worked all day from home I have generally accomplished...
February 19, 2008 at 8:08 am
I personally think that Primary Keys should be enforced by default on "regular" UNIQUE, non-clustered indexes. If it so happens that the PK and the UCI happen to match -...
February 14, 2008 at 7:36 am
What should the default be? Should all PKs be non-clustered? It has to be one way or the other in the system and I'd like to think that whoever build...
February 13, 2008 at 6:19 am
Matt,
Thank you. I did not detect any disrespect, intended or not. But I could see my original train of thought got a little muddied in the way I stated it.
February 13, 2008 at 6:12 am
Matt,
Actually I am fully aware of the differences between primary keys and clustered indexes. Having worked with SQL Server since v4.2.1, I've had ample time to explore many of the...
February 12, 2008 at 5:51 am
Perhaps we should relegate the testing to Consumer Reports...
February 11, 2008 at 8:34 am
Like most everybody who has posted, I'm also straddling the fence. And while it could have been put more nicely, I must agree that there is some loss in formal...
February 11, 2008 at 8:26 am
Perhaps public view of the code is the last resort.
I agree that there should be independent expert testing and, generally speaking, the chemistry black box test should be sufficient.
In some...
February 8, 2008 at 8:21 am
I can see middle managers not being leaders, but C-levels should be leaders. Especially at the pay rates they demand.
Yes, Steve, and sad but true, especially in places where those...
February 6, 2008 at 9:20 am
Each morning on CNN at 6:30 or so EST, I hear about how there are 1700+ aircraft in the air over the US and Canada. How many are flying elsewhere...
January 31, 2008 at 1:23 pm
Andy,
What a thought provoking article! I can see the value in my organization immediately. And while I am not a manager, I passed the article on to 2 people who...
January 29, 2008 at 7:13 am
It is argued, in the example, that the entire responsibility is on the former employee. Now if the employee had gone in and stole that amount of cash, I would...
January 25, 2008 at 6:20 am
Given the level of testing administered to new hires in the US (and not debating the right or wrongs), perhaps we are remiss in not applying the same or tougher...
January 18, 2008 at 5:51 am
Steve,
Congratulations. You certainly deserve the recognition for making SQLServerCentral the one-stop-shopping site and clearinghouse for all this SQL that it is today. A well deserved recognition!
January 7, 2008 at 8:24 am
Viewing 15 posts - 106 through 120 (of 196 total)