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...
Can you tell me which order Can I create the index? Like DateTime, Numeric, etc.,
Thanks for your reply. My problem is that i dont know which field will query commonly. All the 25 fields are coming in the scene. (Here I have given...
Windows 2003 Server R2 Dell Server with 4GB of Ram and some 200GB of HDD. SQL Server 2005 Enterprise Edition.
I saw the Execution plan for the covering indexes. The operator cost is high. nearly 40.xx. Is it OK?
Ya.. Index created with INCLUDE option. Now how about performance of the insert and update process. I see in a website that if more indices then the...
I could not create covering Index for 25 columns. Its alowing only 16 columns and sum of 900 bytes. But I have 25 columns with 4000+ bytes. :(
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...
SQL Server 2005 Enterprise Edition SP2
Hi Satya, Thanks for your reply. This article is saying about the performance of the BULK Insert. But the scenario is that my database gets hanged...
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...
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...
Hi All, Thanks for your responses. I go with Indexed View. That is I created a View with neccessary fields for my search and set the non-clustered...
Hi, I am getting the count as "SELECT COUNT(0) FROM tblMasterTable". Actually I am doing a search page. For every search I am getting how much of...
HI Frank, Thanks for your valuable response. I hope the indexed view is helpful to my process. Please tell me if I set the non-clustered index to the...
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...
I have the table with more than 25 Columns and have unique column with Primary Key clustered Index. Regarding reporting service, Can I implement it...
HI Satya.. Thanks for your response. Actually I do a search pages. It will bring only top 100 records from the DB and show. But i need to show how...
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...
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...
Separate names with a comma.
