I answered it the same way I answer...

Agreed. It's not something I can see all that many uses in knowing. Maybe tran log...

Why does it have to be after the 2nd column?

If you absolutely have to have the table design in that order (for whatever reason), create a new table, copy all...

shahid00704 (1/8/2010)

---

i think you have not studied the scenario clearly.... in sqlteam there was similar question but not the same... once again read it carefully then u will get... u...

If I wasn't interested, I wouldn't have asked for them in the first place.

SQL will take memory a needed and will not release it unless the OS demands it back.

So if you have a SQL service that has just started and no one...

Great, now I'm getting Twitter messages (along with the PMs and mails) "Please answer this forum thread"

If you understand Assembler, you can download a debugger and the public symbols from Microsoft and read through the dump yourself. Other than that, no. The Customer Support team have...

Is there more to the error log than what you've indicated?

Did you try to query the databases from Query Analyser like I asked?

Besides, the redgate tool is SQL 2000 only.

There's a chance that this problem is repairable without any data loss at all. However, seeing as the OP has not bothered to...

Little bit far from my neck of the woods.

Just bear in mind that there are some procs (any with recompile) that will never appear at all in the cache.

Did you read the article?

What I'm asking is sample data in a usable format, something I don't have to spend hours on to get into a SQL table.

Do some analysis, work out which of the queries is the slow one. Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Why are there distincts all over...

Take DTA's recommendations with a very large pinch of salt. Test them all carefully before you decide to implement (yes, the statistics too).

It's also worth noting that SQL seldom will...