Search Results | SQL Server Performance Forums

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

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

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

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

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

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

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