Search Results | SQL Server Performance Forums

My last resort- Fulltext Index

Thread by: whygh, Jun 25, 2007, 1 replies, in forum: General DBA Questions

Hi all, SQL server 2000 SP4 is running on active/passive clustered nodes. Every node is Windows 2003 64bit 4 CPUs and 8GB Ram. Pagefile.sys on C:...

how to config Max Server Memory?

Thread by: whygh, Jun 18, 2007, 3 replies, in forum: General DBA Questions

Hello, My Situation is sql server 2000 EE Sp4 windows 2003 EE. 4CPU 8G RAM Dedicated Server, running Fulltext index. Sp_Configure: Min Server...

Gthrlog.vbs

Thread by: whygh, Jun 11, 2007, 1 replies, in forum: General DBA Questions

Hi, when I use gthrlog.vbs to read the fulltext log files, I got "Could not create object named "MSSearch.GatherLog.1" <br...

Distributed Transaction or query?

Thread by: whygh, Jun 6, 2007, 4 replies, in forum: General DBA Questions

Hello everyone, I met one problem about distributed tranaction. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was...

Fact table join Dimension table with condition

Thread by: whygh, Apr 30, 2007, 3 replies, in forum: Analysis Services/Data Warehousing

Hi all, I am new guy to SQL 2000 AS. Right now I met a problem about how to populate dimension table. My situation is: Fact table structure:...

Sql Job access linked server

Thread by: whygh, Mar 27, 2007, 5 replies, in forum: General DBA Questions

Hi all, Thanks for all your help. I created one job to run stored procedure on server A. this Stored procedure will access...

Index on DateTime

Thread by: whygh, Mar 21, 2007, 6 replies, in forum: General DBA Questions

Hi everyone, Good morning. One table has around 100 million rows.two indexes: one is clustered index and another is non clustered index on datetime...

Only one table could not open through EM

Thread by: whygh, Feb 26, 2007, 2 replies, in forum: General DBA Questions

Hi All, Through EM, Only one TABLE in database could not open. Other tables in same database have no this problem. When I right click the table,...

Fulltext failed to cause SQL Server failover

Thread by: whygh, Feb 21, 2007, 1 replies, in forum: General DBA Questions

Hi all, This is Second time that SQL Server Stoped in this week(It happened since I updated Server from Sp3 to Sp4). I checked the Event log in...

Matrix Detail expression

Thread by: whygh, Jan 5, 2007, 0 replies, in forum: SQL Server Reporting Services

Hi all, I need to create one report using Reporting Service. Dataset like this: ActionDate ,ActionName , ActionData Jan-06Number of Page...

Group By using different Function

Thread by: whygh, Jan 5, 2007, 7 replies, in forum: General Developer Questions

Hello All, I need to create a SQL query to get summary data. Data like this: FieldName FieldData A1 10 A2 20 A3...

Error 17883 please help

Thread by: whygh, Dec 8, 2006, 9 replies, in forum: General DBA Questions

Hi, I got the following Error in the errorLog. After that, SQL Server failover to Another SQL Node in the cluster automaticlly. <br...

one datafile cross multi hard drive

Thread by: whygh, Dec 7, 2006, 2 replies, in forum: General DBA Questions

Hi, In our development server , there are over 100 database runnig on it. recently, space is not enough. so we bought another 250G to install on...

Query Top 2 in each group

Thread by: whygh, Dec 6, 2006, 5 replies, in forum: General Developer Questions

My table structure, Create table temp_DrugandDiseaseTop10 ( TopicID int, Topic varchar(100), Tabletype int, tableName varchar(100),...

After DBCC DBReindex, Space double

Thread by: whygh, Nov 27, 2006, 14 replies, in forum: General DBA Questions

Hi, I have a 47G database. I did a "DBCC Dbredindex" on one table. After 4 hours, It did not finish, So I canceled it. Then I check the space of...

non-clustered index is not used by execution plan

Thread by: whygh, Nov 24, 2006, 8 replies, in forum: Performance Tuning for DBAs

Hi all, I have a table with more than 100 millions rows. there are indexes on column primary_capture_id,capture_date, table_Id. not...

Move SP3 to SP4

Thread by: whygh, Nov 13, 2006, 4 replies, in forum: General DBA Questions

Hi all, I am pretty new to SQL Server. Now I had to move SQL Server 2000 SP3 to a brand new Server <img...