Blogs

Browse by Tags

• SQL 2005
• SQL 2008

• Remove All Non-Numeric Characters From A String

  I completely lack creativity today but thought this link on removing non-numeric characters was kind of cool. Oh... Also... I am a big fan of Captain Varchar(MAX) and the Pagelatch Posse . The greatest thing about the cartoons is that the more you know Read More... Posted Thursday, September 18, 2008 1:48 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQL 2000

• Incrementing Values

  Occasionally, I run across procedures that mimic the functionality of the IDENTITY property. There are always various reasons for these procedures to exist, some valid and some not quite so. Recently while trying to tune one of these procedures that someone Read More... Posted Wednesday, November 14, 2007 10:12 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2000 Attachment(s): IDENTITY_OLD.txt

• Deadlock Resources

  Deadlocks are a not so wonderful unnaturally occurring event that all DBAs will eventually have the pleasure to take a look at. Since deadlocks are time senisitive it is important that at the time of the deadlock the correct mechanisms are in place to Read More... Posted Monday, September 17, 2007 11:20 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2000