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 »
Go ahead and fire up SQL Server (I have 2008 R2) and type the following into a query window (c’mon, you know you wanna): PRINT LEN(‘ ‘) Now run it (F5). 0 That’s right, no matter how many space you put in, the length is 0. This has apparently been around a while and a
SQL SERVER 2008 LEN() AND SPACES: The Debacle Read More »
Bad News… OK, I read this post and it has me thoroughly pissed off… Basically neither SQL Server 2008 SP1 or SP2 are compatible with SQL Server 2008 R2. That is completely lame! I have work to get done, and I already lost an hour applying the Service Pack. Now, in order to attach my
SQL Server 2008 version 661 and 662 Read More »
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 »
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 »
