Search
SQL Server Home
DownloadsFeedbackSurveys
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by Adam Machanic for this product (signing in could show even more results)
Showing 1 - 10 of 37 Previous 123 Next

17
0
Sign in
 to vote
CLR TVFs Are Not Gracefully Handled During AppDomain Recycles - by Adam Machanic
From Connection: SQL Server
When an AppDomain recycle occurs, most CLR module types are able to gracefully handle the situation: in-flight requests continue on the old AppDomain, new requests go to the new AppDomain, and eventua…
Created on 10/3/2012 (updated 11 weeks ago) | 3 validations | 0 workarounds | 1 comment | feedback id: 765930  | 
Closed
as Won't Fix Help for as Won't Fix
12
1
Sign in
 to vote
Startup predicates not honored in plans with parallel nested loops subtrees - by Adam Machanic
From Connection: SQL Server
In a parallel query plan that uses nested loops, a Filter on the inner side that uses a startup expression predicate that references the outer table does not appear to be honored. This problem can be …
Created on 8/7/2012 (updated 13 weeks ago) | 0 validations | 1 workaround | 8 comments | feedback id: 757383  | 
Resolved
as By Design Help for as By Design
26
0
Sign in
 to vote
OLEDB Wait Type Lacks resource_description in sys.dm_os_waiting_tasks - by Adam Machanic
From Connection: SQL Server
In the sys.sysprocesses legacy view, the OLEDB wait type populates the waitresource column with information about the remote instance name and remote SPID. (At least, for SQL Server linked servers.) …
Created on 6/25/2012 (updated 32 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 750782  | 
Closed
as Fixed Help for as Fixed
9
1
Sign in
 to vote
Recursive CTE Allows Duplicate Column Names - by Adam Machanic
From Connection: SQL Server
Table expressions are supposed to have unique column names, and this is the case for derived tables, subqueries, and most CTEs. However, recursive CTEs allow this requirement to be broken.
Created on 12/9/2011 (updated 52 weeks ago) | 6 validations | 1 workaround | 2 comments | feedback id: 712799  | 
Closed
as Fixed Help for as Fixed
30
0
Sign in
 to vote
Valid showplan XML fails to automatically produce graphical showplan - by Adam Machanic
From Connection: SQL Server
In most cases, when clicking on showplan XML returned by a DMV, the graphical showplan automatically pops up. However, I have found one case (the attached file) where this fails. If the XML is saved a…
Created on 3/22/2011 (updated 11 weeks ago) | 11 validations | 2 workarounds | 3 comments | feedback id: 652855  | 
Closed
as By Design Help for as By Design
16
0
Sign in
 to vote
Denali SSMS Incorrectly Reports session_id for connected tabs - by Adam Machanic
From Connection: SQL Server
SSMS no longer correctly reports the connection's session_id (SPID) in parenthesis in the tab for each query window, when it has to re-connect for some reason. Re-opening this. I put new repro steps …
Created on 11/28/2010 (updated 75 weeks ago) | 4 validations | 0 workarounds | 5 comments | feedback id: 625266  | 
Closed
as Not Reproducible Help for as Not Reproducible
60
0
Sign in
 to vote
Indexed view creation causes queries on the base table to block - by Adam Machanic
From Connection: SQL Server
While building the clustered index on an indexed view, queries against the base tables may block due to a schema stability lock. Since building the index may take many hours on big systems, this rende…
Created on 7/29/2010 (updated 36 weeks ago) | 9 validations | 0 workarounds | 4 comments | feedback id: 581056  | 
Closed
as Fixed Help for as Fixed
7
0
Sign in
 to vote
Linked server query does not optimize properly when a filtered unique index exists - by Adam Machanic
From Connection: SQL Server
If there is a filtered unique index, a linked server query is optimized as though a non-filtered unique index were present. See repro below.
Created on 12/8/2009 (updated 3 weeks ago) | 3 validations | 0 workarounds | 5 comments | feedback id: 518900  | 
Closed
as Won't Fix Help for as Won't Fix
35
0
Sign in
 to vote
Lock escalation no longer kicks in for INSERTs in SQL Server 2008 - by Adam Machanic
From Connection: SQL Server
The lock escalation algorithm seems to have changed in SQL Server 2008, and it no longer kicks in for INSERTs. This means that when inserting large sets of rows without explicitly using a locking hint…
Created on 10/30/2009 (updated 48 weeks ago) | 12 validations | 0 workarounds | 11 comments | feedback id: 506453  | 
Closed
as Fixed Help for as Fixed
5
0
Sign in
 to vote
request_id in sys.dm_os_tasks wrong when using MARS - by Adam Machanic
From Connection: SQL Server
When a session is using MARS, the request_id column in sys.dm_os_tasks can have the wrong values, reflecting a request that is not really associated with the task. I tested this in both SQL Server 20…
Created on 9/16/2009 (updated 127 weeks ago) | 0 validations | 1 workaround | 3 comments | feedback id: 490178  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 37 Previous 123 Next





© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement