Browse by Tags
All Tags »
C# »
sql (RSS)
this is a little unique of a setup. i'm having to update a varbin field, but the data that is coming in from the other sources is being cast from xml. so i'm sort of replicating the stupid thing we are doing on the other side, but it seems like...
//reference this metholodogy justification at // http://www.lacoude.com/Docs/public/public.aspx?doc=SQL90XML.PDF int bufferSize = 0; byte [] buffer = new byte [ 8040 ]; string update_sql = @"update tablewithblobs set blobcolumn .write(@a,null,0)...
Recently I put together a SQL talk for developers and gave it at our local JAXDUG meeting. It went over well and one of the items I covered was utilizing CommandBehavior.CloseConnection with the command being used. While the implicit finally created by...
There are a ton of articles about using command cancel vs close when you are using a datareader. The idea is that it will make things faster if you cancel the command rather than just closing it if you have an occasion to interrupt the execution. If you...
this is a very basic load tester. it basicaly lets you from the command line specify what command to run, how many times, against what connection string and whether you want to see any results. obviously, you can tweak it to print the results differently...
i went to look for a super simple way to setup a test of the endpoint feature in sql 2005. i couldn't find one simple enough, so i made this one up. here's some sql code. just run all of this. there are comments in here for what's going on. --copy the...