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

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 1 hour 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 1 week 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 2 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 4 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1390296  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I prefer to set the default database for my admin user to tempdb to avoid littering master by mistake. However, this makes Watch Live Data difficult to use. For instance, I select the system_heath_ses…
Created on 4/3/2015 (updated 12 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1222582  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
The attachment has the full definition for the tables as well as data to demonstrate the issues. We have three queries. First A1 and A2, where A1 is this query with the hint commented and A2 has the …
Created on 2/21/2015 (updated 18 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 1141527  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
The functions suser_name, suser_sname, suser_sid, user_id, database_principal_id, is_rolemember and is_srvrolemember all permits an unprivilged user to retrieve information he is not supposed to have …
Created on 1/17/2015 (updated 19 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 1090900  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I wanted to create an endpoint for Service Broker programmatically, and if the chosen port was in use, I wanted to try the next one and so own. I wrote some standard error-handling code with TRY-CATCH…
Created on 12/11/2014 (updated 24 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1052540  | 
Closed
as By Design Help for as By Design
1
0
Sign in
to vote
From Connection: SQL Server
The topic for CASE and COALESCE says about simple CASE expression: "Evaluates input_expression, and then in the order specified, evaluates input_expression = when_expression for each WHEN clause." …
Created on 11/28/2014 (updated 30 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1042044  | 
Active
4
0
Sign in
to vote
From Connection: SQL Server
This concerns a query that is business-critical in our application. We have a table with transactions, and then there is a temp table with new transactions. A transaction is identified by position key…
Created on 9/20/2014 (updated 21 weeks ago) | 2 validations | 0 workarounds | 1 comment | feedback id: 977383  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 416 Previous 123 Next