I have complained in the past about SP1 setup showing confusing things about services and applications that might cause a restart to be required:
https://connect.microsoft.com/SQLServer/feedback/deta…
Created on 12/12/2012 (updated 18 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 774111
|
|
|
Closed
as Won't Fix
|
|
If I create the following table:
CREATE TABLE dbo.foo(ID INT, CONSTRAINT foo_ID PRIMARY KEY(ID));
GO
Then in Object Explorer, expand my table > indexes and right-click the constraint, choosing scrip…
Created on 11/29/2012 (updated 4 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 772800
|
|
We recently stumbled on a scenario where if a plan uses TOP and parallelism, with a low enough DOP, SET STATISTICS IO ON produces incorrect and unreliable information. Thanks to Steve Wright and Thoma…
Created on 10/12/2012 (updated 2 weeks ago) | 5 validations | 0 workarounds | 4 comments | feedback id: 767250
|
|
|
Resolved
as Fixed
|
|
In Management Studio 2012, attempting to modify a numbered procedure only yields the first numbered procedure, rather than all versions. Create the following numbered procedure:
CREATE PROCEDURE dbo.…
Created on 9/22/2012 (updated 2 weeks ago) | 3 validations | 0 workarounds | 3 comments | feedback id: 764197
|
|
|
Closed
as Fixed
|
|
In Cumulative Updates 1, 2 and 3 for SQL Server 2012, the very first setup dialog ("Install a SQL Server 2012 update") has the following text:
"Welcome to the SQL Server 2012 update. This installatio…
Created on 9/4/2012 (updated 35 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 761178
|
|
|
Closed
as Duplicate
|
|
When you write TRY_PARSE() in SSMS, you get little tooltips trying to help you. Except they don't really help you because the syntax they tell you to use is wrong.
When you type TRY_PARSE( and move y…
Created on 8/25/2012 (updated 4 weeks ago) | 2 validations | 0 workarounds | 4 comments | feedback id: 759535
|
|
First, turn on the server option, "disallow results from triggers":
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure 'disallow results from triggers',…
Created on 8/21/2012 (updated 27 weeks ago) | 0 validations | 1 workaround | 9 comments | feedback id: 758984
|
|
|
Closed
as Fixed
|
|
Error Msg 3159 states:
"The tail of the log for the database "%ls" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH R…
Created on 8/21/2012 (updated 13 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 758935
|
|
|
Closed
as By Design
|
|
In the 2012 version of the Indexed Views topic:
http://msdn.microsoft.com/en-us/library/ms191432.aspx
The set of restrictions listed in table form does not mention outer joins, among other things, w…
Created on 7/24/2012 (updated 32 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 755360
|
|
|
Closed
as Fixed
|
|
In the DDL Triggers topic:
http://msdn.microsoft.com/en-us/library/ms175941.aspx
It starts with:
"You can use DDL triggers to audit database or server operations that create, modify, or delete data…
Created on 7/3/2012 (updated 29 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 752210
|
|
|
Closed
as Fixed
|
|