Viewing 15 posts - 106 through 120 (of 197 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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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 -...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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.
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
February 12, 2008 at 5:51 am
Perhaps we should relegate the testing to Consumer Reports...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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...
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
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!
------------
Buy the ticket, take the ride. -- Hunter S. Thompson
January 7, 2008 at 8:24 am
Viewing 15 posts - 106 through 120 (of 197 total)