Skip to main content

“SQL Server 2005 Everywhere Edition” Now Called “SQL Server 2005 Compact Edition”

Ahead of the final release in December 2006, Microsoft have released SQL Server Compact Edition RC1. SQL Server 2005 Compact Edition is a very lightweight, in process relational database engine for use in desktop applications and mobile devices. It has an extremely small footprint (~3MB) and minimal overhead. It won’t use any where near as […]

Read More

SQLIOSim Tool Released

Microsoft have released their SQLIOSim Tool for stress testing IO subsystems. Different from the SQLIO tool which is tests IO throughput. The tool is designed to simulate the effects SQL Server would have on disk subsystems. It includes options for testing multiple files; random OLTP style queries; read aheads; bulk inserts; checkpoints; rollbacks; backup; sort; […]

Read More

Count the Occurrence of a Phrase or Word in a Column (SQL Server 2005)

Simple little bit of code that will show you the number of times the value of @PhraseOrWordToCount is found in TextColumn. SELECT (LEN(TextColumn) – LEN(REPLACE(TextColumn, @PhraseOrWordToCount, ”)) / LEN(@PhraseOrWordToCount)) AS Occurrence FROM dbo.MyTable I noticed this on Simon Sabin’s blog, I think it has more applications than just FullText searches so I thought I’d do […]

Read More

Count the Occurrence of a Phrase or Word in a Column

Simple little bit of code that will show you the number of times the value of @PhraseOrWordToCount is found in TextColumn. SELECT (LEN(TextColumn) – LEN(REPLACE(TextColumn, @PhraseOrWordToCount, ”)) / LEN(@PhraseOrWordToCount)) AS Occurrence FROM dbo.MyTable I noticed this on Simon Sabin’s blog, I think it has more applications than just FullText searches so I thought I’d do […]

Read More