How to make fast indexing and flat text search in SQL database
Our objective is to achieving good speed with Full-Text Search on an MS-SQL/2008, using Sphinx DB Indexing and text search engine. Our challenge: can we reach speeds better than 3 sec/per simple term search on a DB containing about 2GB of data / 200+ tables with complex permission system allowing/restricting user access with granularity down [...]

Answer Question   |  November 26, 2012  11:26 PM
Microsoft SQL Server 2008, Sphinx

table size strange in SQL SERVER
Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl](     [IdUrl] [Int] IDENTITY(1,1) NOT NULL,     [IdSupply] [Int] NOT NULL,     [Url] [varchar](512) NOT NULL,     [UrlCod] [varchar](256) NOT NULL,     [Status] [Int] NOT NULL,     [InsertionDate] [datetime] NOT NULL, [...]

Answer Question   |  May 5, 2012  2:21 PM
Database, Microsoft SQL Server 2008, SQL Server