See also BOL SQL 2005 ---> Reorganizing and Rebuilding Indexes and http://www.sqlservercentral.com/Forums/Topic789128-149-1.aspx#bm789512.

Basically from now on you'll be free to perform config & maintenance but only for your own databases.

See also BOL ---> Permiossions of Fixed Database Roles & Permiossions of Fixed...

I tried the cursor on the whole set of records in my Salary table (~3.000.000 rows) and still it seems to be the faster - it takes ~6 minutes. I...

See also http://www.sqlservercentral.com/Forums/Topic789128-149-1.aspx#bm789512 for some real life experiences.

Thanks, Jack. I added the links to my briefcase.

I'm not sure I've understood you - do you need 2 rows for product type 1?

Otherwise, see the info about the PIVOT operator in BOL and also http://articles.techrepublic.com.com/5100-10878_11-6143761.html.

Can you add to your process a step which checks that the input XML is well formed?

While working on a similar requirement (involving running totals) I came upon http://www.sqlteam.com/article/calculating-running-totals.

Indeed the cursor solution described here is very fast (even if during tests there was no...

See if dynamic SQL is helpful - you can start at http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=DynamicSearch, however in my opinion the most valuable resource is http://www.sommarskog.se/dynamic_sql.html#Dyn_DB.

Explore also the full text...

http://www.amazon.com/Microsoft%C2%AE-Server-2005-Administrators-Companion/dp/0735621985/ref=sr_1_1?ie=UTF8&s=books&qid=1253776575&sr=1-1

I extensively used this way of updating while working on SQL 2000. Now I prefer to use a CTE or, if dealing with SQL 2008, a MERGE statement.

As george said, f you're on the "full" recovery model and you do not take any log backups, the log will grow and grow...

You should use a template to view your comments.

Go to SSMS ---> View ---> Template Explorer. Right click on "SQL Server templates", choose "new template" and create one, for example:

--procedure...

Try to automatically update the statistics - see BOL ---> Using Statistics to Improve Query Performance.

Go to the "tables" node (for a db) in SSMS, expand the "statistics" node, right...

I can see some "missing index" elements in the query plan you've posted.

Please see BOL ---> Using Missing Index Information to Write CREATE INDEX Statements or use the "db...