if it's taking 1.5 hours to complete, i bet it's got a row by row cursor on a big table, and whatever it is doing might be optimized into one...

Stephen's right...you could use a case statement to avoid the < 20 pitfall:

CASE WHEN len(Incident_Details.Description) < 20 then '' ELSE

substring(Incident_Details.Description, 20, len(Incident_Details.Description) -19) END AS...

peter I'm having a similar issue when i try to do it as well in my 2005 test server.

I never created my info views based on other views, so in...

it's the alias for the count....we still need the schema and datasample to give a meaningful answer.

SELECT USER,

CASE WHEN ISNULL(APPLICATION1,0)=0 THEN 0 ELSE 1 END  +

CASE WHEN ISNULL(APPLICATION2,0)=0 THEN...

thanks for the correction Vladan; i missed that one since i just winged it and didn't test it in QA. Maybe he can redesign the schema and fix the issue.

really difficult without the schema of the tables...can we assume that the table CitrixApps, with only a single column, is source for the values in the Working table's Application1/2/3... columns?

if...

that's not true; I've created lots of information_schema views in sql 2000;

like Peter outlined, you simply create a view in master and change the owner to INFORMATION_SCHEMA; I've done...

as I understand it, SQL Lite speed uses the updated SQL Server API's to create a standard SQL Server backup, abiet much faster, because the TSQL/Enterprise Manager backup commands use...

what is the defined size of the tempdb? tempdb gets recreated every time you stop and start the server, so if you stoip and start, and it is still 5...

there's no event you can use, but you can check to see if soemthing has been backedup since a certain date, and do your special process from there (i assume...

you didn't explain what you meant by "slowness"... I still suspect the autoclose issue;

you can run this statement to see if anything is set to autoclose=true or not:

SELECT + [name]...

you'll want to dbcc reindex the database now. basically the space that was used by the char fields is still there, and new space was added for the varchars....the system...

You could test how many fields are empty, ie  null/not null, but not how of often they are used.

when SQL inserts or updates a row, no statistics are available wether...

Correct me if I'm wrong, but the blocker script is an example of what happens when you have high volume inserts, right?  I've read that the identity() column can have...

by slow you mean it takes a long time for EM to display the list of databases?

If that is true, then it's a known issue where if each database needs...