Submit Your Feedback on SQL ServerBy submitting feedback, you can actively work with members of the Microsoft product team to identify and evaluate the importance of issues, recommend workarounds, and help ensure that the product is reliable and meets customer needs. Your feedback can take the form of a suggestion for improving product design or behavior, or a description of a problem that interferes with your work or causes the product to behave unexpectedly.
To provide feedback, please ensure the following:
- You are signed in with your Windows Live ID account. The "Sign in" link can be found in the upper right hand corner.
- You have completed the Connect registration. To verify you have registered, click “Your Profile,” in the upper right hand corner and complete the registration form.
After you have registered and are signed in, do the following to send your feedback:
- Search for your issue to see if it has already been reported by another customer. If you find your issue in the search results list, you can give it more weight by voting on it.
- If you do not find your issue in the Search results list, click the Submit Feedback button to send your feedback.
For administrative issues with Connect please send an email to
SQL Server Connect Admin.
|
1. |
Lock Resource Hash Value not visible in Deadlock Graph Graphical View
Without the Hash Value you can not be 100% sure what resource was being locked at the time of the deadlock. By having this value and using %%lockres%% an administrator could better understand the dea...
|
Opened By
|
James Rowland-Jones
|
|
ID
|
458080 |
|
Status
|
Active |
|
Opened
|
5/25/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
2 |
|
Comments
|
2 |
|
|
2. |
Update statistics, top 100 percent and Sort warnings
Sort Warnings are generated when explicit sorting of queries is spilled into tempdb when there are less memory buffers left. Index maintenace scripts do NOT generate these and the expectation is, thes...
|
Opened By
|
Sankar Reddy
|
|
ID
|
457024 |
|
Status
|
Active |
|
Opened
|
5/23/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
0 |
|
Comments
|
2 |
|
|
3. |
Management Studio generates invalid TOP 100 PERCENT ... ORDER BY in views
If you build a view in Management Studio view designer and select a column to order the results by, a view such as the below is generated:
CREATE VIEW xxx AS
SELECT TOP (100) PERCENT ....
(.....
|
Opened By
|
Hugo Kornelis
|
|
ID
|
249248 |
|
Status
|
Active |
|
Opened
|
1/2/2007 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
6 |
|
Comments
|
7 |
|
|
4. |
Wrong calculation for unary operator with many-to-many relationships
This is a problem similar to ID 200152 and ID 200154. I open another feedback just to send another scenario that demostrate the issue from another point of view.
The problem is that a parent-child di...
|
Opened By
|
marcorusso
|
|
ID
|
243429 |
|
Status
|
Active |
|
Opened
|
12/4/2006 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
8 |
|
Comments
|
1 |
|
|
5. |
Incorrect "Duplicate key" error with unique filtered index
When updating a table with a unique filtered, the "Cannot insert duplicate key row" error appears, even if the final state of the updated table does not contain duplicates. In this case, SQL Server be...
|
Opened By
|
rsocol
|
|
ID
|
462042 |
|
Status
|
Active |
|
Opened
|
5/30/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
0 |
|
Comments
|
2 |
|
more...
|
1. |
Add support for multi-subnet clusters
SQL 2008 should add support for clusters with nodes running on different subnets. Lack of support is a huge blow to the mulit-site clustering community as SQL is probably the number 1 clustered applic...
|
Opened By
|
JohnToner
|
|
ID
|
353894 |
|
Status
|
Active |
|
Opened
|
6/27/2008 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
9 |
|
Comments
|
1 |
|
|
2. |
Greek full text search support
Full text search is probably the best tool when it comes to searching through large amount of database data and has come a long way since the early versions of SQL server in of performance but also wi...
|
Opened By
|
kpantos
|
|
ID
|
384017 |
|
Status
|
Active |
|
Opened
|
11/25/2008 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
67 |
|
Comments
|
3 |
|
|
3. |
Add optional checks for more robust development
As programming environment SQL Server has shortcomings that are entirely
inappropriate for enterprise development. In a modern programming language,
the compile tries to catch as many errors as poss...
|
Opened By
|
Erland Sommarskog
|
|
ID
|
260762 |
|
Status
|
Active |
|
Opened
|
3/1/2007 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
14 |
|
Comments
|
2 |
|
|
4. |
Create globally-scoped metadata views
When working on administrative scripts -- especially those that deal with locking and blocking issues -- I need to use a lot of rather convoluted dynamic SQL in order to get information about the actu...
|
Opened By
|
Adam_Machanic
|
|
ID
|
432689 |
|
Status
|
Active |
|
Opened
|
4/15/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
5 |
|
Comments
|
2 |
|
|
5. |
OVER clause enhancement request - ROWS and RANGE window sub-clauses
SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for f...
|
Opened By
|
Itzik Ben-Gan
|
|
ID
|
254392 |
|
Status
|
Active |
|
Opened
|
1/28/2007 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
8 |
|
Comments
|
1 |
|
more...
To submit feedback, you must sign in with your Windows Live ID and in some cases
you need permission.
Sign in to access items in your watch list.
|
Title
|
Last Updated
|
Status
|
|
|
7/3/2009
|
Active |
performance of Filter needs to improve
Excel 2007, if you right click on a dimension member on rows and set a Value filter, it uses an MDX Filter function in the MDX it generates. The performance of the Filter function is terrible compared...
|
Opened By
|
furmangg
|
|
ID
|
472474 |
|
Status
|
Active |
|
Opened
|
7/3/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
1 |
|
Comments
|
0 |
|
7/3/2009
|
Active |
Report Builder 3.0 crashes when resizing design surface
In Report Builder 3.0 (build 10.50.1062.6) every time the design surface is resized, the program bombs and freezes, forcing the use of task manager to end program.
|
Opened By
|
TeeDubs
|
|
ID
|
472465 |
|
Status
|
Active |
|
Opened
|
7/3/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
0 |
|
Comments
|
0 |
|
7/3/2009
|
Active |
|
|
7/3/2009
|
Active |
Query optimizer chooses a very inefficient plan
In certain cercumstances, detailed in "Steps to Reproduce", the generated plan is very inefficient and does not scale. If a temporary table is built by doing a SELECT INTO and then that table is used...
|
Opened By
|
thomkc
|
|
ID
|
472398 |
|
Status
|
Active |
|
Opened
|
7/3/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
0 |
|
Comments
|
0 |
|
7/3/2009
|
Active |
Allow me to specify an order for processing files in SSIS
The for each loop container, when set to iterate across files in a directory does so based on alphabetical order. This is rarely useful in business scenarios, where the most common request is to proc...
|
Opened By
|
mhotek
|
|
ID
|
472364 |
|
Status
|
Active |
|
Opened
|
7/2/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
0 |
|
Comments
|
0 |
|
7/2/2009
|
Active |
|
|
7/2/2009
|
Active |
|
|
7/3/2009
|
Active |
Install fails when choosing a path for tempdb two folders deep
64bit Enterprise edition of sql 2008 and 2008 SP1 slipstream install. Install fails when the value for tempdb is set to a path 2 folders deep including the neame tempdb
|
Opened By
|
iain27
|
|
ID
|
472266 |
|
Status
|
Active |
|
Opened
|
7/2/2009 |
|
Your Rating
|
|
|
Overall Rating
|
|
|
Validations
|
0 |
|
Comments
|
0 |
|
7/2/2009
|
Active |
|
|
7/2/2009
|
Active |
Sign in to access items posted by you.
