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 461 Previous 123 Next

1
0
Sign in
to vote
From Connection: SQL Server
I was just playing around with PBM and added a policy to prevent creation of procedures with the name starting in sp_. I found that no matter what name I gave my procedure, the policy prevented creati…
Created on 4/23/2017 (updated 2 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 3132860  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
There are several problem with BCP and space in column names. 1) You cannot generate an XML format at all if one column has space in the names. 2) If you generate an old-style format file with BCP f…
Created on 4/16/2017 (updated 5 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3132515  | 
Active
4
0
Sign in
to vote
Poor query plan with MAX + NOT EXISTS - by Erland Sommarskog
From Connection: SQL Server
I run a query like SELECT MAX(O.OrderID) FROM Orders O WHERE O.OrderID NOT IN (SELECT t.id FROM #temp t) Orders is a big table and #temp is small. The expected plan is that SQL Server would…
Created on 4/12/2017 (updated 5 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3132366  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
You have two natively compiled stored procedures, an outer and an inner. The latter inserts row into a table. In a TRY block, the outer calls the inner twice. The second call fails. However, the CATCH…
Created on 3/24/2017 (updated 4 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 3130608  | 
Active
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 17 weeks 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 12 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3116976  | 
Resolved
as By Design Help for as By Design
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 24 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 26 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 30 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 25 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3105328  | 
Active
Showing 1 - 10 of 461 Previous 123 Next