I have read and worked on fulltext but everytime i stuck when there is a requirement to search database base on fulltext search and combination...
I would like to know if i can use sql server data mining feature to generate report where i need to show analytical informataion from million of...
I was checking if i search F18 in Google is show all related pages even it appear with F/18 or F/A18.
Is it possible to perform a similar search...
I am not very old in DBA field and one of our customer has asked to provided them data-feed against hundurard of thousand of records.
Today i came across a strange issue (although i have solved it but that is not the answer of my question).
I have a table with following...
I have 4 columns in a table.
1 is foreign key and other 3 columns will be matched based on the give values.
Here is my table structure
Recently we have purchased
1x DELL 6950 - 2xDual core optron with 4XGB RAM - 4x146-15k SAS
3x MD 1000 - 15x146k-15k SAS with 3 x PERC 5/e.
I know may be it will seem a newbie question, but i facing this problem.
I have created a table users where i have 3 columns
CREATE TABLE USERS
I have multiple columns in a Single Table and i want to search values in different columns. My table structure is
col1 (identity PK)
I am trying to search word within a varchar(max) field with CONTAINS but it is not returning correct result.
Here is my table structure and data...
Hi,<br /><br />I have created 2 similar tables, both have 9899999 records each. <br /><br />Structure of tables is as shown below<br /><br /><b>TABLE...
I am currently running follow server for my production server
2x73Gx10K RPM (OS/SQL/TEMP DB) - RAID 1
I have table TBLA with Column Col1 VARCHAR(200) (Col1 has Full-Text Index Enabled).
I have a few values in Col1
I am using PowerValut 220s as single RAID 5 array.
It is working well but speed slow down when i pump 30~40k records from text file in database...
I have 2 tables
CREATE TABLE [dbo].[a](
[col0] [int] NOT NULL,
[col1] [int] NOT NULL,
I am using SQL 2005 Enterprise Edition with 8GB or RAM and Dual core DELL SERVER.
I am writing a simple query to extract some data but i...
I have table with 60 million records , now i wanted to add 4 more columns in same table.
But i have only 6 million correspond records to...
Hi guys,<br /><br />I need suggestion for my existing SSIS package which is currently importing csv file. I wanted to use bulk import but in my...
I am reading
MCTS Self-Paced Training Kit (Exam 70-431) Microsoft SQL Server 2005â€”Implementation and Maintenance
Is there any book i need to...
Separate names with a comma.