Search Results | SQL Server Performance Forums

problem with sys.dm_db_index_physical_stats

Post by: suvresh, Mar 16, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

thanks comeaugilles it is now really working, thankx again. regards, suvresh

Shrink My Logfile

Thread by: suvresh, Feb 23, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

hi i have a problem - while i am rebuild my index my log file is increasing. it doubled its size when i am re-building my index. so i decided to...

Table and Index partition on Sql Server 2005

Thread by: suvresh, Feb 13, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

hi everyone, can anyone tell the process how to partition SQL SERVER 2005 Tables and Indexes thanks in advance

problem with sys.dm_db_index_physical_stats

Post by: suvresh, Jan 30, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

still giving same error! not working

problem with sys.dm_db_index_physical_stats

Thread by: suvresh, Jan 30, 2008, 8 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

hi, i am using SQL Server 2005. i have a database DBOneshelp, in that Database there is a table - tblSearch. now i want to see the fragmentation...

e-book for sql server 2005 maintaining and performance tuning

Thread by: suvresh, Jan 27, 2008, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

can anyone provide me links where i can download a sql server 2005 e-book which will provide complete reference of sql server 2005 maintaining and...

how to speed up freetext search

Post by: suvresh, Jan 23, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

nothing - that's the ultimate

how to speed up freetext search

Post by: suvresh, Jan 21, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

thank u sir, i am reading the topics care fully. yes i am talking about full-text search, do you have any other idea to speed up the query i will be...

how to speed up freetext search

Thread by: suvresh, Jan 20, 2008, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

i am using the statement: select * from <tablename> where contains(*, '<search criteria>') but while i am seeing the query execution plan - that...