faijurrahuman17 (11/3/2010)

---

Dear All;

Any one help to solve this problem

CIDEmpId EDATETIMEs ...

What you are...

Hi

Craig Farrell has used a table you can avoid the physical...

Anamika (11/4/2010)

---

to be more precise,

in the above code I have 2 customers doing 4 transaction on a given day.

I need only one transaction for one customer in the report. I'm...

Hi

In your code you have set as IDENTITY(1,1) then how you are inserting values to a colum with identity

INSERT Customer(CustId,CustName,CustAddress) ...

Hi Perry

Thanks for your...

Hi

You are inserting/deleting/Updating data tro .Net then you can try with .Net itself,in.Net there is Possibility of doing it.You can code which will capture Client's IP address but...

Select * from sys.syscolumns 5 sec and in another server(B) it not even take a sec

Select * from sys.sysobjects 2 sec and in another server(B) it not even take...

Paul White NZ (10/29/2010)

---

To verify that the bottleneck is network/client speed, try running:

SELECT COUNT(*) FROM table WITH (INDEX(1));

That will force SQL Server to read every row in the table, but...

No i am not saying problem on sql server i am asking how we can reduce the query time to less than 1 min for 10,000 records i have given...

The Column name i have kept on my server is...

Much longer than what? Another server? Compare the actual execution plans.

I meaned here is, will it take nearly 2 min to return 10,000 records,i am not having any other server...

Hi

The difference is in version not in way they work some new featues has been added,you may need to know difference between previous version and R2...

Hi

I was not able to do as u said above.Any other way.

...

You don't have the...