SQL Server

SQL Server Split Function Using Spaces as Delimiter

Hello – I know you can find free Split functions all over the web. But I wrote one anyway. I really like it. It is part of my search engine code which I might get around to sharing some day.   The main reason I wrote this Split? Because I wanted to be able to […]

SQL Server Split Function Using Spaces as Delimiter Read More »

BLOBs – The AIG of Data Integrity

OK – so there is no one-size-fits-all way to define the use of BLOBs in your database.  But this crazy bandwagon of putting file storage into BLOBs really has me baffled.  I think it is…well…down right stupid.  Why the metaphor with AIG – because people are treating BLOBs like they represent an additional layer of

BLOBs – The AIG of Data Integrity Read More »

SQL Server 2008: Adding an Identity to Existing Column

No. You are probably not.  Here is a SHORT ANSWER (just to show the concept) for putting an IDENTITY on an existing column, based on what I’ve seen: Use All Tasks -> Generate Scripts to script the schema of the table(s) you want to alter.  Script it to an SSMS query window. Go through the

SQL Server 2008: Adding an Identity to Existing Column Read More »