In a Database Mirroring configuration, if the operating mode is set to high performance asynchronous and then set back to high safety with automatic failover, then some data modifications made during …
Created on 1/3/2013 (updated 18 weeks ago) | 1 validation | 1 workaround | 4 comments | feedback id: 775741
|
|
execution_count column of the sys.dm_exec_trigger_stats view increases for user trigger just by starting a SQL Server Agent Job.
While the Profiler doesn't show any execution of the trigger, the execu…
Created on 8/10/2012 (updated 40 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 757810
|
|
The BOL for SQL Server 2012 says (http://msdn.microsoft.com/en-us/library/ms173530(v=SQL.110).aspx) :
When large value types out of row is set to 1, partial updates to a LOB will not fire an after tri…
Created on 1/3/2012 (updated 55 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 716414
|
|
|
Closed
as Fixed
|
|
When a table is partitioned, trigger has a high Duration and LogicalReads cost, that seems to be excessive.
Created on 8/8/2011 (updated 48 weeks ago) | 2 validations | 0 workarounds | 3 comments | feedback id: 683397
|
|
|
Closed
as Duplicate
|
|
SQL Server Database Engine Seteup fails when a file named tempdb.mdf already exists and is open in the User Database Datafiles Directory, even if the Temdb Datafiles Directory is different.
Created on 7/24/2011 (updated 93 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 680582
|
|
|
Closed
as Fixed
|
|
http://msdn.microsoft.com/en-us/library/ms191272(v=SQL.110).aspx
In the Key-Range Locking page on the MSDN library, there's an error in the Examples chapter.
- the 2nd leaf level page shows an ent…
Created on 1/30/2011 (updated 20 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 640344
|
|
The "Include IF NOT EXISTS clause" in the Scripting options impacts the DROP scripts generated by the Wizard (Script Table as / DROP To / ...) in SSMS in the Denali version while it didn't impacted it…
Created on 11/23/2010 (updated 27 weeks ago) | 1 validation | 0 workarounds | 4 comments | feedback id: 624075
|
|
|
Closed
as Fixed
|
|
When pressing the F1 key in particular circumstances in SSMS, I get a error "Index was outside the bounds of the array".
Created on 11/20/2010 (updated 110 weeks ago) | 2 validations | 0 workarounds | 3 comments | feedback id: 623498
|
|
|
Closed
as Fixed
|
|
When creating an index on a temporary temporary table whitin a snapshot isolation level transaction, no error should be thrown if the temporary table has been created in the scope of the transaction (…
Created on 2/6/2010 (updated 52 weeks ago) | 4 validations | 1 workaround | 5 comments | feedback id: 531747
|
|
|
Closed
as By Design
|
|
The doc "Obtaining Changes by Using the Change Tracking Functions" (http://msdn.microsoft.com/en-us/library/cc280358.aspx) contains an incorrect code to demonstrate how to check the last synchronizati…
Created on 12/11/2009 (updated 146 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 519925
|
|
|
Closed
as Fixed
|
|