Viewing 15 posts - 31 through 45 (of 58 total)
Jeff Moden (2/26/2010)
March 2, 2010 at 6:45 am
I agree that GMT is the only sensible way to store a date and time in the database. If it is supposed to represent a specific point in time, GMT...
February 26, 2010 at 5:25 am
Thanks for the update - I wasn't aware that Lutz had added the expiration code.
I know there's no charge for the update (at the moment!), but the expiry date still...
February 4, 2010 at 1:05 pm
Steve Jones - Editor (2/3/2010)
... why would you expect someone to upgrade a tool for free?
I don't. My concern is not that they will charge me for the next version,...
February 3, 2010 at 1:43 pm
Steve Jones - Editor (2/2/2010)
Tools cost money to build. I'm not sure there's a problem with someone charging for their work. I'm sure you charge for the work you do.
I...
February 3, 2010 at 6:05 am
SQL Search is a very nice tool, but unfortunately it's not going to be free for long:
Will SQL Search be free forever?
No. SQL Search will be free for as long...
February 2, 2010 at 6:10 am
I have to admit that I've been guilty of the occasional "tibble" in my time, but I've usually managed to avoid prefixing tables or databases. Of course, you should always...
January 25, 2010 at 6:06 am
The wording of this question is ambiguous - if the question is "what would you expect this query to return", then any answer you select is correct by definition, as...
November 30, 2009 at 5:52 am
I agree with the general feeling that the differences are mostly aesthetic, and there's nothing major you can do in one language that you can't do in the other. The...
November 13, 2009 at 6:11 am
Great catch!
Paul Nielsen posted a script back in 2007 to auto-generate indexes for foreign keys:
http://sqlblog.com/blogs/paul_nielsen/archive/2007/02/08/codegen-to-create-indexes-for-fks.aspx
November 9, 2009 at 6:35 am
in the US it seems to be one of those days that I find companies get very little work done
This year, I hope it's one of those days when companies...
October 29, 2009 at 10:24 am
I think it's quite ironic that Exchange - a 64-bit only product - still uses Jet, when Microsoft have explicitly stated that they are never going to release a 64-bit...
July 20, 2009 at 9:14 am
If you don't trust your administrators, then they shouldn't be administrators! 😛
Trying to prevent a sysadmin from reading your data is like giving someone the keys to your house and...
July 8, 2009 at 5:02 am
It's 6th October already? What was I drinking last night?! :rolleyes:
June 17, 2009 at 5:24 am
Since this only works in SQL 2005 (due to the "OVER" clause on the "COUNT(*)" statement), you could replace the temporary table with a CTE.
Alternatively, for SQL 2000, you could...
January 19, 2009 at 6:08 am
Viewing 15 posts - 31 through 45 (of 58 total)