Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

You can capture the cursor code using SQL Profiler.  It sounds like you have sp_updatestats running as a scheduled job.  The next time it runs and you are experiencing the...

Ditto

DECLARE @Load TABLE (LoadID int IDENTITY(1,1), LoadDesc varchar(10))

INSERT INTO @Load (LoadDesc)

SELECT 'Load 1' UNION ALL

SELECT 'Load 2' UNION ALL

SELECT 'Load 3' UNION ALL

SELECT 'Load 4' UNION ALL

SELECT 'Load 5'

DECLARE...

To further the point David has made, not only are temp tables in insert statements documented in BOL, they are T-SQL fundamentals.  Many of the posts that come from...

It may also be helpful to look for the MDF and LDF files in case the database has just been detached instead of deleted.

Search the SSC forums for Calendars or Dates table and you will see many examples of how to create and use a static Calendars table. 

The only way to guarantee sort order is to specify ORDER BY.  I, too, am curious as to why.  If you post the problem, you may get a better answer.

It sounds like you need some help.  The other consultant wanted to re-build the system from the ground up, but you should be able to find someone who can just...

I recommended going through the 'short-list' as opposed to diving right into Profiler because this will give him the most bang for the least amount of work.  You are correct,...

Must...........learn........how...........to............read........

Wow, I read right over the MSDE detail in Rob's post.  I think when I read it, it registered that the vendor used MSDE for testing but I assumed that...

Rob,

I should apologize in advance for the length of this post, but I got going and did some cut/pasting from some of my home grown docs that I’ve created...

I don't know what to tell you in terms of books to read, but a great starting place would be right here on SSC in the articles section.  The articles...

If you do not have an index on the Comments column, SQL Server usaully goes to the clustered index or primary key and scans that.  An index scan of this...