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...
Recent Posts
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).
Mini-primer on handling exceptions in .NET
There’s a lot of good technique in a short article. I wont repeat it all here, just a taste…