a level 19 = "Indicates that a nonconfigurable Database Engine limit has been exceeded" not a hardware problem.

I could suggest a number of things to try but since this is...

Some comments:

• Using suser_name() won't work in a N-tiers environment
• Using getdate() gives you inconsistant timestamping across your transaction if you have more than 1 statement. Thus you don't know exactly...

I have done the same thing but with a recursive SP instead of a UDF. Passing the reference worked (and is still working in a heavy production environment) perfectly.

You...

Usually, you would query the base table but specify only the attributes (aka columns) you need. Going againts a view which exposes only the columns you need can be done...

The indexed view must be kept up to date and this is part of any transaction that modify rows refered to by the view. If each row in the view is...

No. It would be a bad thing anyway. SQL's indexed views are dynamic (contrary wise to Oracle materialized views which are depressingly static) and the overhead would be ugly.

Don't know...

If I understand correctly**, you run:

EXEC sp_attach_db @dbname = N'MyDB',

   @filename1  = N'D:\MSSQL\MSSQL\Data\MyDB.mdf',

   @filename2...

wangkhar,

How can you manage developers and educate them with such an agressive attitude? The problems you have with developers is not uncommon, on the contrary, but the solution is 10%...

You are using an adjency list but materializing a Deway path. May save some IO but you have to maintain that path and your model is not normalized (no easy...

There are specialized applications for this. Usually they will log to a file (can be a different server) and you then bulk insert this into SQL. Routers also can produce...

This looks like a simple cross-tab report. This is solved by a simple SUM(CASE). Search for cross tab or cross-tab and you should find a zillion examples on this site...

Not pretty. You will have to cast all columns (hope you don't have a CLOB in there).

Since you did not provide a DDL, I will fake something:

select a.au_id,

       c.COLUMN_NAME,

       case...

I don't care about feeling stupid once in a while, it keeps my ego from bursting the seams

Think about it:

Select *

From MyTable

Funny...

 Lots of ideas

But since this is just a hit and run thing, why don't you use a global temporary table? Just add another...

Good point. Developers never seem to realize that nothing is free. I have seem SELECT statements with an ORDER BY clause on 20 columns