Search Results | SQL Server Performance Forums

Search base on Fulltext search and varchar columns taking for ever

Thread by: waqar, Sep 7, 2011, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi, 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...

Can data minning be used for reporting?

Thread by: waqar, Oct 16, 2008, 1 replies, in forum: SQL Server 2005 Database Mirroring

Hi, 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...

Can fulltext search perform similar way as google search?

Thread by: waqar, Jul 30, 2008, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi, 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...

What is data-feed?

Thread by: waqar, May 12, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi, 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. Now i...

SQL Query Analyzer don't pick correct Index if i use Variable

Thread by: waqar, Apr 29, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, 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...

Anyway to tune this query

Thread by: waqar, Dec 11, 2007, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, 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 CREATE...

Can i use this Version as 1 Processor License?

Thread by: waqar, Nov 5, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

http://h30094.www3.hp.com/product.asp?sku=2797571

Do i use SQL 2005 Standard or Enterprise

Thread by: waqar, Oct 29, 2007, 4 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

Hi, 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. Now...

Avoid duplicate INSERT for Single Column

Thread by: waqar, Oct 4, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

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 (ID...

Multiple Columns with different Values OR Single Column with Multiple Values?

Thread by: waqar, Aug 21, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have multiple columns in a Single Table and i want to search values in different columns. My table structure is col1 (identity PK) col2...

Full-Text Search Contain result

Thread by: waqar, Aug 7, 2007, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi, 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...

Why speed is slow with these indexes

Thread by: waqar, Jun 22, 2007, 7 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, I have created 2 similar tables, both have 9899999 records each. Structure of tables is as shown below TABLE...

Some hardware Advice to Process million of records

Thread by: waqar, Jun 20, 2007, 3 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

Hi, I am currently running follow server for my production server PowerEdge 2850 2x73Gx10K RPM (OS/SQL/TEMP DB) - RAID 1 PoweValut220 10x146Gx10K...

Using Full-Text index search, How to search this?

Thread by: waqar, Apr 25, 2007, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have table TBLA with Column Col1 VARCHAR(200) (Col1 has Full-Text Index Enabled). I have a few values in Col1 1- 12345abc 2- 12345abcd 3-...

Do i create Multiple array for different Tasks?

Thread by: waqar, Mar 5, 2007, 6 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

Hi, 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...

Brain stuck for following query

Thread by: waqar, Mar 2, 2007, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have 2 tables TBL 1 CREATE TABLE [dbo].[a]( [col0] [int] NOT NULL, [col1] [int] NOT NULL, [col2] [int], [col3] [int]...

Cannot understand where is the problem

Thread by: waqar, Dec 19, 2006, 11 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi Guys, 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...

Do i add column in existing table or new?

Thread by: waqar, Aug 7, 2006, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi, 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...

Can i use bulk import for this case?

Thread by: waqar, Jul 25, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

Hi guys, I need suggestion for my existing SSIS package which is currently importing csv file. I wanted to use bulk import but in my...

Which books to use for 70-431 exam

Thread by: waqar, Jul 24, 2006, 4 replies, in forum: SQL Server 2005 Certification [Archive]

Hi, 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...