Opportunity to provide feedback on performance improvements in SQL Server...

Please consider giving your feedback or suggestions on the top 5 OLTP and data warehouse performance improvments you would like to see in the next version of SQL Server. Use the links below to provide your comments.

http://blogs.msdn.com/sqltips/archive/2006/09/20/TOP_5_OLTP_PERF_IMP_NEXT_SQL.aspx

http://blogs.msdn.com/sqltips/archive/2006/09/20/TOP_5_DW_PERF_IMP_NEXT_SQL.aspx

Thanks

Any thought on
1. Reverse Key, Functional based and Bit map indexes?
2. UPSERT Statement (Update and insert)
3. Regular expressions in SQL Server
4. Row level trigger (due since first version)

Thanks
Bushan.|||there should something similar to XML documentation for stored procedure as in C# for T-SQL.
That will help document stored Procedures. Please correct me if there already is similar feature.|||

I would like to see SQL Server have something like the MINUS set-operator I have used in ORACLE. It provides a very easy way to see if anything is different between two tables. It is not necessary to specify the columns or any sort of JOIN condition -- merely

SELECT * FROM A MINUS SELECT * FROM B

This simple query returns all rows from A that do not match all values in some row of B. (I seem to recall that duplicate rows are not easily identified by a MINUS query.)

|||

hi Uma,

I've got the silliest idea of them all !

how about an ETL diagraming tools. Something like a flowchart

or the ERD which allows me to analyze the flow

of the etl when i have it printed. The diagram alone should be sufficient to explain the entire flow which minimize my needs to scrutine the properties of the transform.

i've got an initial idea of how it may look like hope you be interested.

thanks,

joey