Bills Posts

Blondes may have more fun but redheads have more sex, according to new research in Germany. The study by Hamburg Sex Researcher Professor Dr Werner Habermehl looked at the sex lives of hundreds of German women and compared them with their hair color.

Dr Habermehl said: “The sex lives of women with red hair were clearly more active than those with other hair color, with more partners and having sex more often than the average. The research shows that the fiery redhead certainly lives up to her reputation.”

He added that women who dyed their hair red from another color were signaling they were looking for a partner, and added: “Even women in a fixed relationship are letting their partners know they are unhappy if they dye their hair red. They are saying that they are looking for something better.”

 Psychologist Christine Baumanns said however that it may not be the women who were to blame for the better sex lives of redheads.

She said: “Red stands for passion and when a man sees a redhead he will think he is dealing with a woman who won’t mess around, and gets straight to the point when it comes to sex.”

“Redheads have a fiery temperament. I love that sense of danger, not knowing whether the woman is going to smash a vase in a fit of wild anger or tear my clothes off in a fit of animal lust. That fire and passion will hold my interest over the long haul, no question.”

Five important facts about redheads:

1. Only four percent of all people have natural red hair.
2. Only 2% of the US population are natural redheads.
3. Redheads require more anesthesia than blondes and brunettes.
4. Redheads don’t turn grey–rather their hair turns sandy and then white.
5. The sales of red hair color and dyes has increased 17% since 2000.

create function getDayOfWeek
    (@date datetime)
returns varchar(10)
as
    begin
        declare @retVal varchar(10)
        select @retVal=
            case datepart(dw,@date)
                when 1 then 'Sun'
                when 2 then 'Mon'
                when 3 then 'Tue'
                when 4 then 'Wed'
                when 5 then 'Thu'
                when 6 then 'Fri'
                when 7 then 'Sat'
            end
        return @retVal
    end

Then you can just call it as any other function in a select (or however you need it):

select dbo.getDayOfWeek(getdate())

USE [dbName]
GO
CREATE TABLE #temp (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET NOCOUNT ON
INSERT #temp
EXEC sp_msforeachtable 'sp_spaceused ''?'''
SELECT a.table_name,
a.row_count,
COUNT(*) AS col_count,
a.data_size
FROM #temp a
INNER JOIN information_schema.columns b
ON a.table_name collate database_default
= b.table_name collate database_default
GROUP BY a.table_name, a.row_count, a.data_size
ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC
DROP TABLE #temp

Reference articles:

• Tip/Trick: Url Rewriting with ASP.NET by Scott Guthrie – Examines four approaches: 1) Use Request.PathInfo Parameters Instead of QueryStrings; 2) Using an HttpModule to Perform URL Rewriting; 3) Using an HttpModule to Perform Extension-Less URL Rewriting with IIS7; 4) ISAPIRewrite to enable Extension-less URL Rewriting for IIS5 and IIS6; also discusses how to handle ASP.NET postbacks correctly with URL rewriting.

• URL Rewriting by Salman (CSharpFriends) – simple implementation of URL rewriting logic within the Application_BeginRequest() method of the Global.asax file.

• Search Engine Friendly URLs using ASP.NET (C#.NET) by Maziar Aflatoun (The UK Web Design Company) – similar to the above, but regular expression is used to match URLs.

• Rewrite.NET – A URL Rewriting Engine for .NET by Robert Chartier (15Seconds.com). Solution steps:
  • Create the HttpModule to process the web request and rewrite the URL
  • Add the handler in Web.config
  • Create a configuration section in Web.config to define URL mapping rules
  • Add extensibility by creating a rules engine interface
  • Write class or classes to implement rules engine interface
  • Add code to the HttpModule to dynamically load the desired rules from Web.config

• URL Rewriting in ASP.NET by Scott Mitchell (MSDN) – examines how to implement URL rewriting in a HTTP module; also explains how to handle postbacks.

• URL Rewriting with ASP.NET by Richard Birkby (CodeProject) – shows how legacy ASP sites can be upgraded to ASP.NET, while maintaining links from search engines. Solution steps:
  • Create the configuration section in Web.config for defining URL mapping rules
  • Write the configuration section handler class, incorporating the URL rewriting logic
  • Create a call to handler in Global.asax in Application_BeginRequest() method
  • Compile the code and install the rewriter assembly in the Global Assembly Cache (GAC)
  • Configure IIS to map non- .aspx files to the ASP.NET ISAPI extension

Related Resources

• Making Sense of ASP.NET Paths by Rick Strahl
• Fixing Microsoft’s Bugs: URL Rewriting by Jesse Ezell
• Regular Expressions with .NET by Dan Appleman and Daniel Appleman
• UrlRewritingNet.UrlRewrite – an Open Source Component which allows you certainly to rewrite URLs with ASP.NET 2.0.
• Open Source URL Rewriter for .NET / IIS / ASP.NET