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

1
0
Sign in
to vote
From Connection: SQL Server
When running BULK INSERT on the attached file, this ends with an assertion error. This appears on SQL 2008 up to SQL 2016. I only found this when playing around, so I cannot say that this is a hig…
Created on 8/5/2015 (updated 3 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1631407  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
As reported by Ryan Web Dev in thread http://social.Msdn.microsoft.com/Forums/en-US/sqltools/thread/4340a44d-3104-4c84-ab46-6a362160e501#4340a44d-3104-4c84-ab46-6a362160e501 the trigger node is missin…
Created on 8/1/2015 (updated 3 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1617533  | 
Resolved
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
In the repro, the plan is a nested loop join. Towards the end of the query, the inner part of the query lits up completed, while the CI scan which is driving the loop join is still running. This is an…
Created on 7/25/2015 (updated 1 week ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1589096  | 
Closed
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
You have a contained database, and a database-authenticated users connects to SSMS. The user navigates Object Explorer, when right-clicking a table, the user gets this error: The module being execu…
Created on 7/24/2015 (updated 4 weeks ago) | 2 validations | 1 workaround | 1 comment | feedback id: 1587129  | 
Resolved
as Duplicate Help for as Duplicate
2
0
Sign in
to vote
From Connection: SQL Server
I have a database called sommar_1910. In the UI for Query Store it is presented as SOMMAR1910. Yes, the rest of the header is in uppercase, but my system collation is case sensitive. And where did the…
Created on 7/21/2015 (updated 5 days ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1574612  | 
Resolved
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
On the page https://msdn.microsoft.com/en-us/library/mt147923.aspx there floursishes a stored procedure sp_add_customer. The sp_ prefix is reserved for system procedure, and it is not good practice to…
Created on 7/13/2015 (updated 6 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1542422  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
I downloaded SQL Server Management Studio June 2015 preview from https://msdn.microsoft.com/en-us/library/mt238290.aspx. When downloaded had completed, I clicked Run, and I got a UAC screen. The UAC s…
Created on 6/27/2015 (updated 8 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 1480692  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Say that you have two existing tables, one with current data and one with historical data. You attempt to connect these by making the the table with current data a temporal table. The historical table…
Created on 6/21/2015 (updated 9 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1457407  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
There are several errors in the syntax graph for CREATE TABLE with regards to temporal table. 1) The clause PERIOD FOR SYSTEM_TIME is listed as coming after FILESTREAM ON when it fact belongs in th…
Created on 6/15/2015 (updated 10 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1437438  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
In SSMS I set the option "Switch to results tab after the query executes" as I always do. It works for text mode, but not for grid mode. I have to switch to the results tab myself. The OS is Window…
Created on 6/1/2015 (updated 12 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1390296  | 
Active
Showing 1 - 10 of 422 Previous 123 Next