Search
SQL Server Home
DownloadsFeedbackSurveys
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 akelly for this product (signing in could show even more results)
Showing 1 - 10 of 11 Previous 12 Next

12
0
Sign in
 to vote
dm_exec_requests does not show blocking SPID - by akelly
From Connection: SQL Server
It appears as if the behavior of sys.dm_exec_requests has changed when it comes to blocked sessions. In SQL2005 if I run the following code to simulate a blocked session I would see the SPID of t…
Created on 11/16/2008 (updated 89 weeks ago) | 5 validations | 0 workarounds | 3 comments | feedback id: 382323  | 
Closed
as Won't Fix Help for as Won't Fix
11
0
Sign in
 to vote
GETDATE() returns multiple calues in a single SELECT statement - by akelly
From Connection: SQL Server
If you use GETDATE() in a select statement it can return more than one value in the result set. GETDATE() should only ever return a single value per any one ATOMIC sql statement. This seems to be as a…
Created on 5/3/2008 (updated 169 weeks ago) | 3 validations | 1 workaround | 6 comments | feedback id: 341838  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
 to vote
Trace rowsets do not drop events - by akelly
From Connection: SQL Server
Rowset based traces do not drop events, it just scales back performance dramatically even under extreme duress.
Created on 4/16/2008 (updated 120 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 338499  | 
Closed
as Won't Fix Help for as Won't Fix
2
0
Sign in
 to vote
Katmai - Detach db gives error after detach - by akelly
From Connection: SQL Server
When you detach a db in SSMS (Katmai) and choose Drop Conncection it detaches the db and then gives an error message that the db is not accessible.
Created on 10/23/2007 (updated 282 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 306349  | 
Closed
as Not Reproducible Help for as Not Reproducible
2
0
Sign in
 to vote
Katmai Trace does not show rowcounts for RPC events - by akelly
From Connection: SQL Server
Trace or Profiler does not always show the values in the RowCounts column in Katmai for RPC Completed events.
Created on 10/22/2007 (updated 265 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 306174  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
 to vote
Registered Server Name Property does not persist - by akelly
From Connection: SQL Server
If you add a Registered Server in SSMS the Registered Server Name Property does not persist when opening that server in Object Explorer.
Created on 3/17/2007 (updated 105 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 263899  | 
Closed
as Won't Fix Help for as Won't Fix
2
0
Sign in
 to vote
Maintenance Plan gives wrong error if SQL Agent is not running - by akelly
From Connection: SQL Server
IF you attempt to open an existing Maintenance Plan and SQL Agent is not running you get an error that states you need to enable "Agent XP's" thru the Surface Area Configuration . This is misleading s…
Created on 3/6/2006 (updated 69 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 125643  | 
Active
2
0
Sign in
 to vote
The Shrink Database task of the Maint Plan does not work as advertised - by akelly
From Connection: SQL Server
The Shrink Databse Task of the MP gives you two options. "Retain Free space in the files" or "Return freed space to the OS". If you choose the later it uses the "TRUNCATEONLY" option which does rele…
Created on 2/22/2006 (updated 74 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 125646  | 
Active
3
0
Sign in
 to vote
SSMS doesn't retain or script Index options properly - by akelly
From Connection: SQL Server
If you create an index with certain properties the UI does not show them properly and does not script the creation properly.
Created on 2/21/2006 (updated 355 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 125644  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
 to vote
FTS Service is set to Manual yet turns itself on - by akelly
From Connection: SQL Server
Often times when I am in SSMS I notice that the FTS service is running. It is set via the Configuration manager in MANUAL mode. I have reset it several times to Stopped and MANUAL yet it still starts…
Created on 2/21/2006 (updated 44 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 125645  | 
Active
Showing 1 - 10 of 11 Previous 12 Next





© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement