Submit My Question - Recent Questions - Recent Answer

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

[838 byte] By [UmachandarJayachandran-MS] at [2007-12-28]

«« XML BULK LOAD very simple but I CANT UPLOAD THE DOCUMENT! HEEEEEEELP!!!!! PLS !!!!!!
»» datagridview to microsoft excel

# 1

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.

Bushan at 2007-9-4 >

top of Msdn Tech,SQL Server,Transact-SQL...

# 2

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.

connect2sandeep at 2007-9-4 >

# 3

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.)

DanR1 at 2007-9-4 >

# 4

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

joeydj at 2007-9-4 >

SQL Server

Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech