Search Results | SQL Server Performance Forums

How to get the transaction state of a particular table in sql server 2005

Thread by: bab_ganesh, Aug 13, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi How to get the transaction state of a particular table in sql server 2005? ie. I want to know whether the particular table is in transaction or...

Challanging scenario in Index

Thread by: bab_ganesh, Aug 3, 2008, 16 replies, in forum: SQL Server 2005 General Developer Questions

Hi I have a table with 4 million records,35 fields. A primary key field. Every 1 hours 1000s or 10000s of records inserting in this table using...

Table Locked while Bulk Insert in sql server 2005

Thread by: bab_ganesh, Jul 31, 2008, 8 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello, I have a table with 2.5 million records. I will insert bulk of records in this table using BULK INSERT every day(more than 4 times). While...

Setting Non-Clustered index in Indexed View Vs setting in Table

Thread by: bab_ganesh, Jun 16, 2008, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, I have a table with 30 columns and 3 million records. I am quering a field amount 25 fields. All the 25 fields are searchable fields. When I...

Non-clustered index to 20+columns

Thread by: bab_ganesh, May 26, 2008, 4 replies, in forum: SQL Server 2005 Clustering

Hi All, I have a table with 35 columns,3+ million records,1 clustered index unique field. I developed a search application to search the records...

Getting TotalRows in SQL is too slow for huge records.

Thread by: bab_ganesh, May 24, 2008, 13 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I am using SQL Server 2005 Std. Ed. I have a table with 30+ Lakhs records. I have the index on this table. When I write the SELECT COUNT(*) FROM...

Difference betwn JOINS and normal two table joins

Thread by: bab_ganesh, Mar 31, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, Can anyone tell me the actual difference between these queries? SELECT * FROM Table1 AS A, Table2 AS B WHERE A.Field1 = B.Field1 SELECT * FROM...