Home Dashboard Directory Help
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

18
0
Sign in
to vote
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 16 weeks ago) | 3 validations | 0 workarounds | 1 comment | feedback id: 765930  | 
Closed
as Won't Fix Help for as Won't Fix
13
1
Sign in
to vote
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 17 weeks ago) | 0 validations | 1 workaround | 8 comments | feedback id: 757383  | 
Closed
as By Design Help for as By Design
26
0
Sign in
to vote
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 100 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 750782  | 
Closed
as Fixed Help for as Fixed
9
1
Sign in
to vote
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 119 weeks ago) | 6 validations | 1 workaround | 2 comments | feedback id: 712799  | 
Closed
as Fixed Help for as Fixed
30
0
Sign in
to vote
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 79 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
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 142 weeks ago) | 4 validations | 0 workarounds | 5 comments | feedback id: 625266  | 
Closed
as Not Reproducible Help for as Not Reproducible
61
0
Sign in
to vote
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 17 weeks ago) | 9 validations | 0 workarounds | 4 comments | feedback id: 581056  | 
Closed
as Fixed Help for as Fixed
9
0
Sign in
to vote
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 63 weeks ago) | 4 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
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 115 weeks ago) | 12 validations | 0 workarounds | 11 comments | feedback id: 506453  | 
Closed
as Fixed Help for as Fixed
5
0
Sign in
to vote
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 194 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