TOP needs to be placed before the variable setting.

Declare @Name varchar(30)

Select Top 1 @Name = CustName

From Customer

Order By CustName

I do not know why you had the GROUP BY clause in...

Doing so...are there problem of security?

Uhm, well definitely. I would say that unless you are creating your own Enterprise Manager-ish admin client I would seriously question the need to create...

What sets my warning bells on is that you have AWE enabled and yet only max server memory configured to 1024. I am not sure what effects that will have....

I do not think there is any way to do that in t-sql. If you are executing the command from a .Net client (or similar) you can get that information...

Adding a secondary log file is definitely not something he should do. I have yet to see a single scenario where having multiple log files gives any advantage at all....

SELECT Name, 'column1' AS newColumnName, column1 AS newColumnValue

FROM yourtable

UNION ALL

SELECT Name, 'column2', column2

FROM yourtable

UNION ALL

SELECT Name, 'column3', column3

FROM yourtable

(Saving the Site Owners from some hard work)

Answered in other thread

I do not have any benchmarks, but one simple pro for Dual Core procs is that Microsoft only charge you per socket.

No, it is not possible.

First of all, you should read this good article by Trudy Pelzer regarding metadata. As you will find, the INFORMATION_SCHEMA way of describing metadata is the ANSI-standard recommended way,...

The memory issues are very annoying. I always read the forums br browsing the Active Threads to see everything that is new since my last visit. If I get an...

This is normal in any development environment, am i right!!!

What do you mean? It should never be considered normal to allow dirty reads.

Will this give an order of magnitude difference...

I assume you mean "every table on my database where a column with a particular name is present".

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = @columnname

Use any Windows implementation of tail, for instance by installing Cygwin.

What happens when you connect through QA?

If nothing else works, you could try reinstalling just the client tools.