I got to know that It cannot be indexed, so how can I re-write the view so that I can create a Indexed view?

I have customerID for every day but...

Thanks John Mitchell for your reply. But can we use the IN clause in

case statement? I have a similiar case in other table.

CREATE TABLE TABLE1 (ID INT IDENTITY(1,1),PERSON_NAME VARCHAR(50),ReviewedID...

Does the two part naming of a table helps in single Select statement in the application side, because I have lot of Select queries in the application side which is...

It is called from front end application. If I convert into procedure do you think that it helps a lot. This is query is used a lot in when I...

I have a Select query like

Select Column1,column2,column3 from table1 T1,table2 T2 ,table3 T3 WHERE T1.ID = T2.ID AND T1.ID = t3.ID AND T2.USERID = @VALUE AND T3.NAME LIKE '@NAME.%'

This...

Whenever we execute the sys.dm_exec_sql_text or other views which is very important the usecounts or size_in_bytes column. Based on which column gives me the better idea?

When I checked out the application code written previously by the ex-employee I observed that he has used lot of very big select queries about 200 columns in the application...

Hi

what about the usecounts in sys.dm_exec_cached_plans table? How can I derive any neccessary observation from this column?

Regarding fulshing the queries from the RAM, I think it is wise to use cach plan which are already in the RAM, which do not have a wide range of...

I checked each of the queries they are not what we call bad queries. They cannot be optimized further which I am sure. The one thing I noticed about these...

The Enterprise Evaluation Edition service pack on server1 is SP1 and SERVERPROPERTY('ProductLevel') is RTM.

The Workgroup Edition service pack on server2 is SP2 and SERVERPROPERTY('ProductLevel') IS RTM

I have a user table in every database. The user table contains many users with their user name and password to log in from application side. Whenever a user logins...

Yes the procedure name is same in all the database. But there are around 45 databases of which I have to execute the procedure only in 40 databases. The remaining...

Hi thanks for the reply they can run one after another.

But I want to do this in a single job.

Hi Thanks Jack I got to know what was wrong. I changed some of the datatype in the destination table and increased the length of some of the columns in...