We have experienced tempdb contention (PAGELATCH_EX contention) which caused performance problems. The resource is always (2:1:103) and it is seen when many temp tables are created often.
I understa…
Created on 1/21/2013 (updated 2 weeks ago) | 1 validation | 1 workaround | 3 comments | feedback id: 777072
|
|
|
Closed
as Fixed
|
|
Several words, when on their own line, are not colored green when part of a /* */ style comment...
Blue: (IO,TIME,PRECISION,CONTAINS,KEY,INTO,LOAD,DISK,DUMP, etc...)
Grey: (ALL,AND,EXISTS,ANY,BETWEEN…
Created on 7/27/2010 (updated 103 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 579127
|
|
|
Closed
as Fixed
|
|
When debugging, the next statement arrow indicates the next statement that is to be executed when stepping through code.
This arrow can indicate the wrong statement if the newlines are non-standard.…
Created on 9/19/2008 (updated 49 weeks ago) | 1 validation | 0 workarounds | 4 comments | feedback id: 368661
|
|
|
Closed
as Won't Fix
|
|
In SQL Server Management Studio 2008, there is an option to assign status bar colors to different connections. When new query windows are opened. The color of the status bar takes the custom color tha…
Created on 8/14/2008 (updated 5 weeks ago) | 19 validations | 1 workaround | 15 comments | feedback id: 361832
|
|
When intellisense displays parameters for a sproc, the window is still displayed even if Ctrl+Home is pressed.
Created on 7/31/2008 (updated 103 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 359153
|
|
2008 Feb CTP:
In the "Sql Editor" Toolbar, there's a "Available Da&tabases" dropdown that can be used to display or set the current database for a connected query editor window. (Ctrl+U gives this co…
Created on 6/6/2008 (updated 261 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 349732
|
|
|
Closed
as Fixed
|
|
Try using the Alt+F1 shortcut key with pretty much any table in Adventureworks and you'll see where I'm coming from.
When I try to select a two-part table name and press Alt+F1, I expect to see the …
Created on 6/3/2008 (updated 20 weeks ago) | 24 validations | 1 workaround | 8 comments | feedback id: 349116
|
|
### I'm reopening as active ###
Can you please give an indication as to whether there's a fix for SSIS 2005???
Original description follows:
In SSIS, I have a simple package with one connection manag…
Created on 5/24/2008 (updated 136 weeks ago) | 3 validations | 0 workarounds | 6 comments | feedback id: 345979
|
|
|
Closed
as Fixed
|
|
Looking at the command line that was executed when SSMS launched profiler from a query window. I see the specification of template, server and I also see "/C spid=53"
I tried the same command line wi…
Created on 5/23/2008 (updated 257 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 345788
|
|
|
Closed
as Won't Fix
|
|
The "count" argument to the batch seperator keyword "GO" is underlined with a red squiggly line in SMSS's query editor. Hovering over the line gives the warning
Incorrect syntax near '10'.
The co…
Created on 5/13/2008 (updated 72 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 343750
|
|