TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 51, comments - 60, trackbacks - 14

November 2003 Blog Posts

It's Feburary the 31st. Do you know where your data is? MySQL knows...

Damian was kind enough to send this little nugget: http://sql-info.de/mysql/ It's not exactly a debunking of MySQL, but it does have a list of what it describes as "gotchas" regarding MySQL's behavior. A little explanation: the term "gotcha" is used, and not "bug" or "heinous, idiotic application flaw" because most of these "gotchas" are DOCUMENTED IN THE PRODUCT MANUALS! It seems MySQL considers February 31st to be a valid date...valid enough that you can actually compare it to other dates without throwing an error! This is considered ACCEPTABLE, DOCUMENTED BEHAVIOR! MySQL will also alter your table definitions without warning, if...

posted @ Wednesday, November 19, 2003 11:15 PM | Feedback (3) | Filed Under [ Stupidness ]

Keepin' The Tradition Alive...

If you want to learn things about SQL Server that you'll never find anywhere else, you must read Ken Henderson's Guru's Guides to SQL Server.  I just got his most recent book, The Guru's Guide to SQL Server Architecture and Internals, and like his previous books it is amazing.  This one is totally packed with everything that wasn't included in the earlier volumes:  how SQL Server uses WinAPI calls, thread scheduling, virtual memory management, how the different network libraries operate, how to “debug” the internal processes, how to discover undocumented calls, more XML not previously covered, Notification Services, replication, and...

posted @ Thursday, November 06, 2003 7:29 PM | Feedback (3) | Filed Under [ Coolness ]

Powered by:
Powered By Subtext Powered By ASP.NET