Demoed FinalBuilder at TVUG
Last month I demoed FinalBuilder at TVUG. That was an interesting experience. I have managed to spend my entire career without having to do a public presenta...
Recent Posts
Enhanced version of sp_who
I often use sp_who and sp_who2 to see who is connected to what on our development database server. When we need to restore a database, I need to make sure no...
My web application is running at 98% of the CPU
We are in the middle of testing a new web application and we have 7 instances of it running on 2003 Server box. Each instance has a web page virtual director...
When to use cursors
This is cool <a href=”http://anotherlab.rajapet.net/” http: title=”Running sums, redux”>article</a> that describes a good reason for using cursor...
Get just the date from a SQL Server datetime column
This should be faster than the other way ( converting it to a varchar and lopping off the time part).