Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
November 2004 - Posts - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, Xamarin.iOS, Xamarin.Android, and Windows Azure.

News

Visual Studio Magazine Column Personal Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

November 2004 - Posts

Get a performance pop within a Sql CLR Stored Procedure

According to the BOL with the October CTP bits, you can get a performance improvement with Sql Server 2005 CLR objects if the send the results directly to the network buffer and bypass managed memory.  How do you do this?

Do this:

SqlCommand sqlCm = SqlContext.GetCommand();
sqlCm.CommandText = "blah, blah, blah.........";
SqlContext.GetPipe().Execute(sqlCm);

instead of

SqlCommand sqlCm = SqlContext.GetCommand();
sqlCm.CommandText = "blah, blah, blah..........";
SqlDataReader sqlDr = sqlCm.ExecuteReader();
SqlContext.GetPipe().Send(sqlCm);

Source: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/bbdd51b2-a9b4-4916-ba6f-7957ac6c3f33.htm

**Note, no code has been checked against the editor to see if it runs, this is just something I pulled from the BOL.  Your mileage may vary**

Glad to see that JAVA has a few flaws to..............

http://news.com.com/Java+flaw+could+lead+to+Windows%2C+Linux+attacks/2100-1002_3-5464872.html?tag=nl

And to think it took 6 months for Sun to release a fix and still another month to acknowledge the problem.

Wally

Nuts - UGA 19 - GT 13

Well, I must admit that my boys did a much better job than I had thought they would do on Saturday.  UGA opened up a 16 - 0 lead at the half.  UGA's qback David Greene had to go out due to an injury to his hand.  Backup QB DJ Shockley threw a touchdown pass on his first series after replacing Greene to make it 16 - 0.  For the next 30 game minutes, the Tech defense took over and dominated the UGA offense.  DJ Shockley looked like he didn't know which end was up.  In the third quarter, Tech closed to 16-13.  While dominating the game, Tech could only muster 13 points due to a determined UGA defense.  Sensing things were in flux, David Greene came back in the game and led a UGA drive starting midway through the fourth quarter to get a field goal.  On their final series, Tech moved to the UGA 20 yard line with about a minute to go in the game.  On first down, there was a screen pass with no gain.  On second down, Tech qb Reggie Ball took an 11 yard sack trying to elude the UGA defense.  On third down, to stop the clock, Tech spiked the ball.  On fourth down, flushed out of the pocket and needing 21 yards for a first down, Reggie Ball through the football away and Tech turned the ball over on downs.  UGA ran one play and the game was over.  Congratulations to the UGA defense, they won the game for Georgia.  Better luck next year for my Tech boys.  Thank goodness we won't have to deal with David Greene who has been a Tech killer over the last four years.

Wally

New undocumented Exception with Whidbey has been discovered...............

A new Whidbey Exception.

Winform change between beta 1 and October CTP

FYI.  I just went back to a winforms application in beta 1.  It ran fine in beta 1, but when I opened it in the October CTP bits, I got a complaint from the MyApplication.vb file.

Here is what the file looked like in the beta1 bits.


Option Strict On
Option Explicit On


Namespace My
   
    Partial Class MyApplication
        Inherits System.Windows.Forms.WindowsFormsApplicationBase
       
        <Global.System.Diagnostics.DebuggerStepThrough()> Public Sub New()
            MyBase.New(System.Windows.Forms.AuthenticationMode.Windows)
            Me.IsSingleInstance = false
            Me.EnableVisualStyles = true
            Me.ShutDownStyle = System.Windows.Forms.ShutdownMode.AfterMainFormCloses
        End Sub
       
        <Global.System.Diagnostics.DebuggerStepThrough()> Protected Overrides Sub OnCreateMainForm()
            Me.MainForm = My.Forms.Form1
        End Sub
    End Class
End Namespace

With the october CTP bits, the file needs to look a little more like this:

Option Strict On
Option Explicit On


Namespace My
   
    Partial Class MyApplication

        <Global.System.Diagnostics.DebuggerStepThrough()> Public Sub New()
            MyBase.New(ApplicationServices.AuthenticationMode.Windows)
            Me.IsSingleInstance = False
            Me.EnableVisualStyles = True
            Me.ShutdownStyle = ApplicationServices.ShutdownMode.AfterMainFormCloses
        End Sub

        <Global.System.Diagnostics.DebuggerStepThrough()> Protected Overrides Sub OnCreateMainForm()
            Me.MainForm = My.Forms.Form1
        End Sub
    End Class
End Namespace

By making the changes, I was able to compile my application.  I hope this was helpful.  Obviously, I have no idea how well this will work against future versions.

Wally

Phil Mickelson shoots 59 - Offtopic

Lefty shot a 12 under par 59 at the Grand Slam of Golf.  While the course was relatively short by the stanards of the monster courses seen on today's golf tour, 59 is still 59.

My best golf score on my local course is a 76, which I shot in 1996.  My best score from a full length course that would standup to the professionals is an 83.  The difference between 59 and 83 is over a shot per hole.  Wow, that just shows how much difference there is between pro golfers and guys like me.  Right now, my golf game is in hibernation.

http://sports.espn.go.com/golf/news/story?id=1931417

Wally

Sounds just like me

My name is Wally.

My hobby is Programming.

I am told I talk to much and ask too many questions.

Sounds just like me

My name is Wally.

My hobby is Programming.

I am told I talk to much and ask too many questions.

Two important Lessons I keep learning over and over

I keep learning and re-learning two important lessons.

  1. Technology people have no concept of negotiations.  I believe in discussion and negotiations.  Technology people tend to come with this "take it or leave it" mentality.
  2. Asking questions intimidates people.  This is the one that I just don't get.  It seems that the more questions I ask, the madder people get at me.

Wally

Posted: Nov 22 2004, 10:20 PM by Wallym | with 2 comment(s)
Filed under:
Two important Lessons I keep learning over and over

I keep learning and re-learning two important lessons.

  1. Technology people have no concept of negotiations.  I believe in discussion and negotiations.  Technology people tend to come with this "take it or leave it" mentality.
  2. Asking questions intimidates people.  This is the one that I just don't get.  It seems that the more questions I ask, the madder people get at me.

Wally

Posted: Nov 22 2004, 10:19 PM by Wallym | with 2 comment(s)
Filed under:
More Posts Next page »