Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

The Incremental Servicing model for SQL Server continues to march on with Cumulative Update # 3 now available for SQL Server 2008. Microsoft has committed to a CU every 2 months and this strategy ...

I'm trying to get either Server.Transfer or Server.Execute to work. I tried using it in a real page, but gave up and now am trying to get just this to work:<BR><BR ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...