Search Results | SQL Server Performance Forums

Fetching records from HUGE table - need help

Post by: Rocky, Feb 8, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks to SQL guru and other gurus who replied to this <img src='/community/emoticons/emotion-3.gif' alt=':o' />)

Fetching records from HUGE table - need help

Post by: Rocky, Feb 3, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Here is the select statement: SELECT Code_Type, tbl_name, A.r_cre_id, A.r_cre_time, cur_rec, lodgement_id FROM CADR A ,COCR C WHERE...

Fetching records from HUGE table - need help

Thread by: Rocky, Feb 1, 2007, 9 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have this huge table for activity logs which has quarter billion records in it. There is a query from the application to view activities, the...

sql server not using the index

Post by: Rocky, Nov 13, 2006 in forum: SQL Server 2005 Performance Tuning for DBAs

Thanks Adriaan and gurucb

sql server not using the index

Post by: Rocky, Nov 13, 2006 in forum: SQL Server 2005 Performance Tuning for DBAs

Thanks Adriaan, I do not have access to the database right now, so can not actually find if the max count for that value for the column is...

sql server not using the index

Post by: Rocky, Nov 13, 2006 in forum: SQL Server 2005 Performance Tuning for DBAs

yes i do, this is how the query looks, select name, address, email, blah, blah, blah from table1 where corp_id = 'blah' and the 2nd databsae is...

sql server not using the index

Post by: Rocky, Nov 13, 2006 in forum: SQL Server 2005 Performance Tuning for DBAs

Hi Adriaan, The second one is showing index scan and I am running the exact same query (if thats what you mean by same filter criteria). -Rocky...

sql server not using the index

Thread by: Rocky, Nov 13, 2006, 9 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, I have exact schema on 2 databases, the table structure, columns and indexes match but one of them has huge data compared to other. Now the...

Extracting schema of a database in sql server 2000

Post by: Rocky, Nov 9, 2006 in forum: SQL Server 2005 General DBA Questions

Thanks Mate.<br /><br />Pretty basic isn't it, new to sql server <img src='/community/emoticons/emotion-3.gif' alt=':o' />).<br /><br />-Rocky<br...

Extracting schema of a database in sql server 2000

Thread by: Rocky, Nov 9, 2006, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Can you please let me know how to extract the schema(tables, views, etc but not data) of a sql server database. With this extracted file I...

INSERT, if exists UPDATE

Post by: Rocky, Nov 2, 2006 in forum: General Developer Questions

I do not want to do explicit inserts and updates as the number of tables and PK for them is too many and it would involve a lot of text processing to...

Equivalent of INSERT ... ON DUPLICATE KEY UPDATE

Thread by: Rocky, Nov 2, 2006, 3 replies, in forum: General Developer Questions

Hi, Can you please let me know if there is equivalent thing for INSERT ... ON DUPLICATE KEY UPDATE which is in my SQL.

INSERT, if exists UPDATE

Post by: Rocky, Nov 2, 2006 in forum: General Developer Questions

I do not want to do explicit inserty and updates as the number of tables and PK for them is too many and it would involve a lot of text processing to...

INSERT, if exists UPDATE

Thread by: Rocky, Nov 2, 2006, 9 replies, in forum: General Developer Questions

Hi, I have a set of insert statements which needs to be run a particular table, there could be a possibility that some of the record may exist...

column order in an index

Post by: Rocky, Oct 18, 2006 in forum: T-SQL Performance Tuning for Developers

The product/database is designed to handle only one country, there is no replication done one this, this is absolutely redundant in the current...

column order in an index

Thread by: Rocky, Oct 17, 2006, 5 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I am looking at a database which has one of the columns present in almost all tables and that column is also part of the PKs and hence is part...

column order in an index

Thread by: Rocky, Oct 17, 2006, 2 replies, in forum: Performance Tuning for DBAs

Hi, I am looking at a database which has one of the columns present in almost all tables and that column is also part of the PKs and hence is part...

query not using the right index

Post by: Rocky, Oct 4, 2006 in forum: T-SQL Performance Tuning for Developers

Thanks mate.

query not using the right index

Thread by: Rocky, Oct 4, 2006, 8 replies, in forum: T-SQL Performance Tuning for Developers

Hello, I am analysing a query which is performing bad even though it has the right indexes on the table.The problem is that sql server is not using...