Destructuring query language, one keyword at a time.
In case you don't already know, Daylight Savings Time starts three weeks earlier and ends four weeks later this year than in previous years. This does not affect SQL Server directly because it uses the Windows clock as its clock, but you might have some stored procedures, views, or functions that try to calculate DST based on the old dates. If you think you might, try running the following on each of your databases. Feel free to change the "LIKE" arguments or add "OR" clauses. -- proceduresSELECT ......
So I decided a while back to get a new mouse that would ease my shoulder and hand pain, and I happened upon this. Well I've been using it for a few weeks now on my Dell 4550 with Windows XP, and I thought I'd share my thoughts on the Perific wireless mouse for anybody considering a new mouse. Pros If your posture is good (or if you start trying harder to straighten your shoulders), it really does seem like it's good for the shoulder and whatnot. It's very easy to use it in your hand rather than on ......
I have a fun idea for a new McDonald's commercial. It opens with the latest jingle (bah dah bah bah bah), followed by Ronald McDonald driving his Hummer up to the edge of a rainforest. He precedes to light the rainforest on fire, and as he watches it burn, he eats several Big Macs and throws the wrappers on the ground. Then we cut to a fatter Ronald McDonald testifying before Congress that global warming isn't really happening. Then we cut to an even fatter Ronald marching the cows into the slaughterhouse ......
Has anybody else noticed that the weather forecast makes no logical sense sometimes? On occasion the low for one day is higher than the high for the next day. How can there be a gap? The only answer is that the forecast is not for a 24-hour period, which is just weird, even though people generally don't care what the weather will be like between midnight and 5 A.M.
This is a great explanation of the mssqlsystemresource database in SQL Server 2005 and how to look at what's inside it even though it's hidden.
http://www.aspfaq.com/sql2005/show.asp?id=28
I'm about to say something that many people will disagree with: Siamese Dream, the Smashing Pumpkins album, may be the best-produced album ever.
Here's what I want in a vehicle. I think so many people in the United States want the same thing (or something similar) that it's ridiculous that there's nothing for sale that even approaches it. - it should be 100% recyclable - it should be a plug-in hybrid and get around 80-90 mpg (if possible with the previous requirement) - it should contain airbags all over the place (along with all the other good safety features) - it should have night vision - it should be all-wheel drive - it should have ......
If you're looking to watch some new (i.e. new to you) shows on DVD (thru Netflix or whatever), here are some recommendations:Six Feet Under: completely original and addictive, very emotionalLost*: riveting and original storyline, good casting, marginal dialog Entourage: light and funny, and a nice view of what an acting career can be like Weeds: funny, original The West Wing: smart, great acting, great dialog * I've only seen the first season of Lost, so I can't comment on anything after that. ......
I love this article, it echoes my thoughts from yesterday about how high gas prices are a wonderful thing (yes the article is nine months old, but I just saw it for the first time, and it's still valid): http://www.slate.com/id/214... To add to what I said, it's not just high gasoline prices that we should be hoping for, it's high ENERGY prices. I'm sure this is obvious to most people, but I'll state it anyway: the higher the price of energy, the less people will use. I've communicated with Jorge ......
This is a very interesting post, the important thing to take away being that using "for" rather than "foreach" seems to be noticeably faster in big lists.
http://www.thinksharp.org/?p=50
Unless you don't like science (defined here as knowledge derived through observation and experimentation) and would prefer to live in the Dark Ages, it should be clear that humans can't continue polluting Earth without severe consequences. There are several kinds of people in this world: those who believe that non-cyclic global warming is happening (whether they care or not); those who know nothing about it because they're too concerned with their own lives (rightly or wrongly); those who believe ......
The brain of an expert has been trained to access a good deal of the knowledge that he or she has attained through study and experience in his or field. The brain of a guru can readily access almost anything about his or her field that he or she has learned, but at times can also see beyond that to find solutions that are new or unheard of.
I don't know if this would be considered a bug or not, or if I'm just missing something, but when you use ListBox.DataSource in Windows.Forms (.Net 2.0), and you add or remove an item from an ArrayList that is set as the DataSource, there is no method to refresh the listbox. The only thing I know that works is setting the DataSource to null and then setting it back to the ArrayList. That just doesn't seem right. addendum (the next day): I may have found another bug! When I move an item up or down ......
It's always bothered me that there's not a single word for multiples of ten and a single word for multiples of five. It bothers me because society determined long ago that these "round" numbers were far more important than others (e.g. the 75th anniversary gets far more attention than the 74th). To that end, I'm creating two new words. decager: any integer containing a zero in the ones column; examples are 0, 10, -20, 250, 370 quinteger: any integer containing a zero or a five in the ones column; ......
Did anybody ever figure out what happened to the 91 versions of Windows that should have been between Windows 3.0 and Windows 95? I'm pretty sure I never saw them...
In case anyone's interested, here's a line of C# that lets you check to see whether the selected user (Windows or SQL) has RESTORE permissions on a specific database. It uses SMO, and you'll need to use System.Security.Principal to get the Windows user logged on to your application, if not using SQL authentication. Pull out the stuff in quotes if you want to try it in Query Analyzer. This page is helpful in understanding the RESTORE command and who should have permissions to run it. Boolean canRestore ......
It never ceases to amaze me how little proofreading goes on at major media outlets. I can't remember the last time I went a full day without seeing a mistake. Check out the sentence below from an article on both the Houston Chronicle's website and the Boston Herald's website: "U.N. Secretary-General Ban Ki-moon is concerned that U.S. bombing in southern Somalia could escalate hostilities and harm civilians who are reported to have been killed in the airstrike, a spokeswoman said Tuesday." http://www.chron.com/disp/s... ......
This is an interesting post about how compatibility mode in SQL Server 2005 can really make a difference: http://mapamdug.blogspot.co... If anybody has run into any other gotchas or whatever related to the compatibility mode, I'd love to hear about it. I once tried upgrading a db from 80 to 90 and got so many errors it was unbelievable, mainly because of "incorrect syntax" or "ambiguous column name" in stored procedures. The following is from the BOL, I'm posting ......