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 Tom Lucas - 0411 for this product (signing in could show even more results)
Showing 1 - 4 of 4 Previous 1 Next

1
0
Sign in
to vote
Query hangs with new CE - by Tom Lucas - 0411
From Connection: SQL Server
I have a query which is producing a bad query plan and hanging in SQL 14. It will run for over an hour. But, if I provide a query hint "option (hash join) ", at the end of the query, it returns in a…
Created on 10/6/2013 (updated 47 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 804700  | 
Resolved
as By Design Help for as By Design
1
0
Sign in
to vote
From Connection: SQL Server
After switching to use clustered column store indexes on my fact tables, a query is now hanging. I am swtching over to clustered column store because it helps many other queries in the workload. The…
Created on 9/30/2013 (updated 21 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 803984  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
I have a query which is hanging under new cardinality estimator in SQL 14(compatibility=120), which returns in about 10 seconds using previous CE (compatibility = 110). This is for the same sql serve…
Created on 9/27/2013 (updated 9 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 803739  | 
Closed
as Not Reproducible Help for as Not Reproducible
2
0
Sign in
to vote
From Connection: SQL Server
I have a query which returns in 15 seconds using the old CE, and it is hanging using the new CE. By hanging, I mean that it runs for over an hour and then fills up tempdb. This query represents a …
Created on 9/19/2013 (updated 9 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 801676  | 
Closed
as Not Reproducible Help for as Not Reproducible
Showing 1 - 4 of 4 Previous 1 Next