SQL Server Precision And Scale Problems (2)
share
digg
by
gmmastros (0)
on
All Blogs (3)
6 days, 18 hours
ago
permalink
Many people are confused about SQL Server’s precision and scale. This is unfortunate because choosing the correct values for precision and scale is critically important when you perform math operations using the decimal/numeric data type. The point of this blog is to explain how SQL Server determines the data type for math operations, and the order in which conversions occur. For example: tsqlLine number On/Off | Show/Hide | Select allSELECT 10 / 3 UNION All ...
What Does Hyperinflation Look Like? Just Take A Look At The Weimar Republic In 1923 (1)
share
digg
by
SQL (0)
on
Musings, Rants and Ponderings Of A DB Architect (0)
6 days, 23 hours
ago
permalink
Germany went through its worst inflation in 1923. In 1922, the highest denomination was 50,000 Mark. By 1923, the highest denomination was 100,000,000,000,000 Mark. In December 1923 the exchange rate was 4,200,000,000,000 Marks to 1 US dollar. In 1923, the rate of inflation hit 3.25 × 106 percent per month (prices double every two days). Stores would close for lunch to change the prices on items. I have scanned a bunch of stamps from my ...
Setting a standard DateFormat for SQL Server (1)
share
digg
by
gmmastros (0)
on
All Blogs (3)
1 week, 3 days
ago
permalink
Each SQL Server has a default language. You can see what the default language is by executing these commands (in a query window). tsqlLine number On/Off | Show/Hide | Select allSP_CONFIGURE ‘default language’Code is hidden, SHOW This will tell you what the default language is (sort of). It actually returns a config_value with an integer that represents the language id. You can then run… tsqlLine number On/Off | Show/Hide | Select allSP_HELPLANGUAGECode is hidden, SHOW ...
Flickr Search Connectr for Windows 7 Search Federation (6)
share
digg
by
pthurrott (0)
on
SuperSite Blog (0)
1 week, 4 days
ago
permalink
Long Zheng offers a bit of Windows 7 goodness to the community: I’m announcing the availability of “Flickr Search Connectr” for Windows 7. If you have a copy of Windows 7 and the tubes aren’t blocked, I encourage you to try it for yourself. So what is this voodoo you might be asking? Well this is actually a combination of two components, both carefully put together in a couple of hours by amateur programmer yours ...
High Dynamic Range (HDR) - My way (4)
share
digg
by
Drew Gardner (0)
on
The Photographic world of Drew Gardner (0)
1 week, 4 days
ago
permalink
Search for high dynamic range (HDR) photography on Flickr and just see what you get?Well, the search will return more than a few photos which when viewed you feel like you have just partaken of some kind of mind altering substance.To be honest aesthetically not really my cup of tea.....To be clear High Dynamic Range photography is combining photographs of differing exposure to give a result rendering a greater range of tonal detail than the ...
Some of my reasons for upgrading to SQL Server 2008 (2)
share
digg
by
Denis Gobo (0)
on
SQLblog.com - The SQL Server blog spot on the web (0)
1 week, 4 days
ago
permalink
So Aaron posted My reasons for upgrading to SQL Server 2008 I thought it was an interesting list, not as interesting as the one by Jason Massie (10 Reasons to Upgrade to SQL Server 2008) but still interesting :-) I would like to give you my list. Date data type We have data that goes back to 1896 so we cannot use smalldatetime instead of datetime. When your table has billions of rows and grows ...
Troubleshooting Blocking 101 on SQL Server (2)
share
digg
by
onpnt (3)
on
All Blogs (3)
1 week, 5 days
ago
permalink
Today started off around 12:03 AM to my treo chimming about every 5 minutes. It wasn’t the way I wanted to wake up but we probably all know the feeling at one point or another. So why was my treo talking so much? Well at 12:03 AM a transaction decided to start blocking some updates. At this point SQLdm decided to let me know. By the time I logged in to check the blocked transactions ...
Detroit's 6 Mistakes and How Not to Make Them (35)
share
digg
by
Umair Haque (0)
on
Umair Haque (0)
1 week, 5 days
ago
permalink
The end of Wall St. as we know it? Scary - but just the beginning of a larger tsunami of economic reinvention, as our forecasts at the Lab have predicted for the last several years. Now that Wall St.'s been eviscerated, it's Detroit's turn to play the meltdown and bailout game. So what should we demand from a bailout of Detroit? There's a bigger point raised by the serial destruction of Wall St. and Detroit. ...
-
Daniel J. Pritchett said:
Umair writes for Harvard Business School Publishing: "To begin making that roadmap concrete, let's highlight the six critical mistakes Detroit made by following yesterday's rules, to draw out some of the new rules of 21st century business - new rules that you can use to start reconceiving, reinventing, and revolutionizing your own organizations."
-
vanlandw said:
Detroit needs to pick it up mostly because some areas are really nice. It's a shame, article is worth a read though.
-
Alex said:
Consider for a second the fact that as recently as this year, Detroit's lobbyists were hard at work, opposing stricter fuel efficiency standards. That's 20th century self-interest at its finest - not authentic interest for one's own long-run outcomes, but simply a childlike selfishness, both myopic and narrow, where cutting off the nose to spite the face is as rational as mutual nuclear annihilation
-
Claude said:
What a waste of bandwidth. The author completely ignores the damage entrenched unions have caused to these old businesses.And who says people want to buy accident prone little econo boxes? I wouldn't put my family in danger in one of those things in order to save gas or the planet.
-
Akshay said:
VERY insightful view on old to new industry mentalities.
Mostly Lisa Photo tip: Turning Blah into Beautiful (2)
share
digg
by
Mostly Lisa (0)
on
MostlyLisa.com (0)
1 week, 6 days
ago
permalink
100mm f/2.8 Macro lens, f/6.3, 1/40, ISO 400. Posted on TWiP. I try to rent different lenses for my dSLR as much as possible. I find it a great way to explore photography and keep myself inspired. I rented my first macro lens this weekend, the Canon EF 100mm f/2.8 Macro with the goal of DIYing a little macro studio and shooting some cool product shots. But, I really dropped the ball and ended up ...
The Social Upheaval/Zombie Movie Index (7)
share
digg
by
By Freakonomics (0)
on
Freakonomics (0)
1 week, 6 days
ago
permalink
Annalee Newitz, editor of the science-fiction blog i09, created a chart showing the number of zombie movies produced annually in the West (mostly the U.S. and Europe) since 1910: Chart design by Stephanie Fox. The chart shows several spikes in zombie-movie production that, according to Newitz, "always seem to happen eerily close to historical events involving war [...]
-
simonfl said:
Zombie analysis? Now that's a sweet job.
The Sperm-Supply Problem (7)
share
digg
by
By Daniel Hamermesh (0)
on
Freakonomics (0)
1 week, 6 days
ago
permalink
There's a shortage of sperm in Britain! Apparently, Britain needs donations for about 4,000 women per year; to reach that number, about 500 sperm donors per year are required, while only 300 are currently registered. Things were fine until 2005, when a law was enacted allowing children of sperm donors the right to discover the [...]
-
Lynn said:
part time job maybe?
-
Radu said:
sau cum sa faci rapid rost de bani
Free Google Apps, More Difficult to Find (32)
share
digg
by
Alex Chitu (14)
on
Google Operating System (14)
2 weeks
ago
permalink
Google Apps for Your Domain has been launched in 2006 as a solutions for organizations that wanted to use Google's applications on their own domains. In 2007, Google launched a premier edition for businesses that added corporate features, APIs, phone support and service-level agreement for Gmail. But how many businesses use Google Apps? A post from July mentioned that "500,000 organizations adopt Apps as part of their business, with another 3,000 signing up every day", ...
-
jerobins said:
i found this annoying as well
-
Jonathan Wong said:
I guess giving away something for free is not that great of an Internet business model after all. Google Apps is now in the same league as RealPlayer?
-
Tyler said:
Sign of things to come with Google? I sure hope not. This article describes some new Google tactics that sound a lot like Real Player tactics. Not cool! Do no evil, Google. NO EEEVIIIL!