Well,

I think in any software development project, you need to think about the 3 dimensions: time, quality, and cost. In most cases, you will need to compromise one over another....

I guess the ifnull() function that will make your query using index scan. I've come across this kind of query many times. Not the is null or is not null...

How do you connect to your local server? Are you using Enterprise Manager or Query Analyzer? Run the Service Manager. Check whether the server is run and what is the...

Sorry for that. :p

Forget to add the CAST.

Change those with these ones:

CAST(MONTH([Date]) AS varchar(2))

CAST(DAY([Date]) AS varchar(2))

CAST(YEAR([Date]) AS varchar(4))

Other way to do the query is:

Select userID, CONVERT(varchar(10),[Date],101) as...

Does the application shows the error message or the exception message clearly, such as: unable to find host or invalid login id/password or access denied for database ....?

Try to run...

You can use DTS (Data Transformation Service) to do that. You can create source from csv file and then create destination node of your table. Setting the arrow between the...

What do you mean by backend and frontend? Do you mean that backend is the server itself and the front ends are the other computers? Do you use Enterprise Manager...

select userID, (Month([Date]) + '/' + Day([Date]) + '/' + Year([Date])) as [onlyDate], count(*) as [Count]

from someTable

group by userID, (Month([Date]) + '/' + Day([Date]) + '/' + Year([Date]))

UPDATE Table SET col = LEFT(col, LEN(col) - 2)

Is that the error message because of wrong connection string?

If the connection string is wrong then the error message should say that it can't connect to the specified database server....

karthikeyan,

Your idea for saving the max value in a special table is feasible. For example, a system that creates a sales order with increasing sales order code (SO0001, SO0002, and...

I'm not quite sure also about SQLDMO_1. But it seems from other posts in the internet to be a system process. Some say that It is linked with Enterprise Manager....

Well, I agree with the others to first look at your index. If the index is still there then start with performance monitor to look at the processor counter, batch...

Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any other query/transaction execution...

It is worth to check what actually your view is (I mean the complexity of the select and joins within that view). See from the Execution Plan and try to...