What does checkdb recommend for a repair level? If the repair level is REPAIR_ALLOW_DATA_LOSS you will need to find a good backup and restore from it and subsequent...

I'm not sure that this is perfect, but you can look at sys.dm_exec_sessions which has a memory_usage column that shows the # of 8KB pages used by the session.

I'm not sure why they would be using CROSS APPLY, as it seems to me they could use an INNER JOIN if they are accessing tables or views. Here...

A couple of comments. If you are really using SQL Server 2005 then you should not be using the Text data type you should be using the varchar(max) data...

To sort of answer your question. Yes, both DTS and the Access applications are taking locks on the tables/indexes/rows affected by the processes. If data is not being...

Still looks like a permissions issue to me. Works in vs because it is running using your privileges. In a job it is running under the agent account...

You need to answer Dave's question. Based on what I see in the trigger I can...

Could you move some of the filtering into the Derived Table instead of outside the derived table. For example, couldn't this, OH.TeamIsLost = 'N', be int eh derived...

What has changed? Did the Exchange Server get restarted? Did the password get changed for the SQL Server Agent or SQL Server service account? Have you tried...

Check your anti-virus settings.

Filters within the report, like on a table/tablix, are applied AFTER all the data is returned from the data source. You really want to pass a date parameter to...

What is the error returned? My guess is that you need to create proxy using a user that has rights to start and stop services and then runt he...

As Ron has pointed out, you should be using the Try-Catch error handling. But you also have an error in your code. The @@error function returns the error...

GilaMonster (2/23/2010)

---

Jack Corbett (2/23/2010)

---

3. Using an 'OR' also limits the usefulness of indexes. The Optimizer has to choose to access 2 indexes and merge those results (requires ordering)...

This is duplicate post #8 for this problem. I provided an answer in another one, but it's not on my clipboard anymore and I'm not going to go searching...