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

4
0
Sign in
to vote
From Connection: SQL Server
If I connect to a server with SSMS on the ADMIN connection, I get the error message "Failed connect to server ADMIN:SERVER." This can scare anyone, but looking in the status bar, I can see that I am c…
Created on 9/12/2017 (updated 5 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3140969  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
If I set a Execution timeout under Tools->Options->Query Execution this is not respected for windows that are opened on start up or cloned from this window, but I get an inifinite timeout. I believ…
Created on 9/9/2017 (updated 5 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 3140650  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
When you start SSMS and it opens a query window as part of start up, the application name is not set to "Microsoft SQL Server Management Studio - Query" like it is for other windows. If you start …
Created on 6/1/2017 (updated 10 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3135115  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
If I open SSMS from Explorer by right-clicking a file and select SSMS and later close SSMS, I lose some of my settings. Not all, for instance keyboard shortcuts and fonts are retained. This occurs wit…
Created on 6/1/2017 (updated 20 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3135113  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
In SQL 2017, you can now use SELECT INTO to create a table on a different filegroup from default. If you instead of a filegroup you give a partition scheme, you get an error message. This is to be exp…
Created on 5/26/2017 (updated 21 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3134865  | 
Active
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 1 week ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 3132860  | 
Closed
as Fixed Help for as Fixed
2
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 11 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 17 weeks ago) | 0 validations | 0 workarounds | 9 comments | feedback id: 3132366  | 
Active
3
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 6 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 3130608  | 
Closed
as Fixed Help for as Fixed
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 4 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3117603  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 466 Previous 123 Next