Monthly Archives: July 2007

SQL Server 2005 – Technical Articles

SQL Server 2005 Accessing External Data Sources with Analysis Services 2005Add Custom Data Mining Algorithms to SQL Server 2005Analysis Services 2005 Processing ArchitectureBuilding a Localized Report on a SQL Server 2005 Analysis Service Cube Data SourceBuilding a Rule Engine with … Continue reading

Posted in SQL Server 2005 | Leave a comment

SQL Server Full Text Search Language Features

SQL Server Full Text Search Language Features   Strict querying using CONTAINS By default, use of the CONTAINS predicate will entail minimal language specific query time expansion. For example, consider a search on the term book. select * from TableName … Continue reading

Posted in Uncategorized | Leave a comment

SQL 2005 Symmetric Encryption

read more at: SQL 2005 Symmetric Encryption

Posted in SQL Server 2005 | Leave a comment

Selective Defrag/Reindex and Log

SQLServerCentral.com Script Library: Selective Defrag/Reindex and Log USE master GO ———————————————————- — This creates a table to log all activity and results — ———————————————————- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fragreport]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1) drop … Continue reading

Posted in Code Snippets | Leave a comment

Converting Binary data to a Hex Character String

SQLServerCentral.com Script Library: Converting Binary data to a Hex Character String declare @binary_field varbinary(85) declare @c int declare @hexnum char(100) set @binary_field = 0x12323DFE345987AD980089A12312312312312345345344567CDAFE set @hexnum = ‘0x’ while len(@binary_field) > 0 begin set @c=cast(substring(@binary_field,1,1) as int) set @binary_field=substring(@binary_field,2,len(@binary_field)) set … Continue reading

Posted in Code Snippets | Leave a comment

Fast Text Processing in SQL Server

Fast Text Processing in SQL Server Processing text or long strings usually reduces SQL to a prosaic procedural language. Processing text or long strings in SQL has never been an easy task. SQL is a powerful language for performing fast … Continue reading

Posted in SQL Server 2005 | Leave a comment

Unbesiegbar – Der Traum seines Lebens (2006)

Unbesiegbar – Der Traum seines Lebens (2006) Inhalt: 1975 ist kein gutes Jahr für den Hilfslehrer Vincent Papale (Mark Wahlberg), er wird entlassen, muß verstärkt als Barkeeper arbeiten und dann verläßt ihn auch noch seine Frau mit allen Sachen. Wirtschaftlich … Continue reading

Posted in Uncategorized | Leave a comment