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 Erland Sommarskog for this product (signing in could show even more results)
Showing 1 - 10 of 457 Previous 123 Next

1
0
Sign in
to vote
From Connection: SQL Server
When trying to get the query plans with dm_exec_query_statistics_xml for sessions in a table variable, the update fails with an assertion error. The assertion error only occurs if TF7412 is in use. (I…
Created on 12/28/2016 (updated 3 days ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3117603  | 
Resolved
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
When you feed a NULL value to concat_ws, you don't get a delimiter for that element, despite that the document only says that NULL is handled as the empty string. Furthermore, it is somewhat difficult…
Created on 12/20/2016 (updated 4 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3116976  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
In SSMS, you can select under Help->Set Help Preference whether you want to view Help in browser or in Help Viewer. However, no matter what you select, selecting Help->View Help opens the page in SSMS…
Created on 11/30/2016 (updated 7 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3113678  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
The encryption wizard in SSMS fails if the database you operate on has a view that refers to tables or view in a different database, even if this view has no relation to the column(s) you want to encr…
Created on 11/17/2016 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3111906  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
If you try to use ALTER SCHEMA TRANSFER to move an object which is in a schema that starts with a # sign, you are told "Cannot change the schema of a temporary object." However, the schema is not a te…
Created on 10/18/2016 (updated 13 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3107226  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
If you load a Unicode file encoded in UTF-16LE and that has a BOM (byte-order-mark), BCP is able to load this file correctly, if you load it without a format file. However, when using a format file, B…
Created on 10/2/2016 (updated 8 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3105328  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
You have a data file in UTF-8. The separator is outside the ASCII range. The file can be loaded with BCP. However. BULK INSERT does not seem to be able to handle the file.
Created on 10/1/2016 (updated 16 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3105304  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
Books Online says about this column. "ID of database. For ad hoc and prepared SQL statements, the ID of the database where the statements were compiled." However, it seems that dbid is NULL…
Created on 9/29/2016 (updated 16 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3105033  | 
Active
16
0
Sign in
to vote
From Connection: SQL Server
You have a query window connected. The connection to SQL Server is lost, for instance because your proceess is killed. When SSMS reconnect, it silently changes the current database to your default dat…
Created on 9/9/2016 (updated 12 weeks ago) | 2 validations | 0 workarounds | 1 comment | feedback id: 3102337  | 
Closed
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
You run a query with parallelism where all threads wait with EXECSYNC on one thread which performs all the work. If you look in sys.dm_os_waiting_tasks, you find that there is no official blocking_ses…
Created on 7/16/2016 (updated 6 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 2938118  | 
Active
Showing 1 - 10 of 457 Previous 123 Next